pgsql-sql since 2006-02-12 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

Feb. 12, 2006

Thread Author Time
Re: Very slow updates when using IN syntax subselect Tom Lane 00:37
Trigger/Sequence headache Foster, Stephen 22:27
Re: Trigger/Sequence headache Stephan Szabo 23:10
Re: Trigger/Sequence headache Foster, Stephen 23:25

Feb. 13, 2006

Thread Author Time
Re: Trigger/Sequence headache rlee0001 07:03
Re: Trigger/Sequence headache Markus Schaber 11:38
ORDER BY CASE ... Mario Splivalo 15:35
Re: ORDER BY CASE ... Mathieu Arnold 15:39
Re: ORDER BY CASE ... Reinoud van Leeuwen 15:40
Re: ORDER BY CASE ... Mario Splivalo 15:47
Re: ORDER BY CASE ... Mathieu Arnold 16:10
Re: Very slow updates when using IN syntax subselect Bryce Nesbitt 17:27
Tough Problem -- Record Checkouts Alfred 17:33
Re: CREATE VIEW form stored in database? George Weaver 17:33
Problems with distinct Andreas Joseph Krogh 19:19
Re: Problems with distinct Tom Lane 19:22
Re: Problems with distinct Owen Jacobson 19:24
Re: Problems with distinct Andreas Joseph Krogh 19:29
Re: ORDER BY CASE ... Mario Splivalo 21:28

Feb. 14, 2006

Thread Author Time
group by complications Mark Fenbers 00:14
Slow update SQL Ken Hill 01:48
Re: Slow update SQL Michael Fuhr 02:14
Re: group by complications chester c young 02:29
Re: Slow update SQL Michael Fuhr 05:17
passing array(java) to postgre sql function bond 10:11
SELECT on a to-be-determined table garhone 15:28
Re: Slow update SQL Ken Hill 16:35
Re: Slow update SQL Markus Schaber 16:39
Re: Non Matching Records in Two Tables Ken Hill 20:55
Re: Non Matching Records in Two Tables Tom Lane 21:07
Re: Non Matching Records in Two Tables chester c young 21:08
create table and data types Maciej Piekielniak 21:12
Re: Non Matching Records in Two Tables Ken Hill 21:24
Re: Non Matching Records in Two Tables Ken Hill 21:25
Re: create table and data types Ken Hill 21:30
Re: create table and data types Maciej Piekielniak 22:03
Re: create table and data types Tom Lane 22:06
Re: create table and data types Ken Hill 22:42
Re: Non Matching Records in Two Tables Bryce Nesbitt 23:05

Feb. 15, 2006

Thread Author Time
Re: create table and data types Bath, David 00:21
Re: Non Matching Records in Two Tables Ken Hill 01:47
view of weekly data Ding Xiangguang 03:39
Re: Non Matching Records in Two Tables Ken Hill 15:45
Modifying postgresql.org file Ken Hill 16:15
Re: Modifying postgresql.org file Andrew Sullivan 16:20
Re: Modifying postgresql.org file Devrim GUNDUZ 16:24
Btrieve to PostgreSQL Adam Alkins 16:24
Re: Modifying postgresql.org file Ken Hill 16:35
Re: Modifying postgresql.org file Andrew Sullivan 16:47
Re: Modifying postgresql.org file Peter Eisentraut 17:09
Re: Modifying postgresql.org file Owen Jacobson 17:13
Re: Modifying postgresql.org file Ken Hill 17:36
Re: Modifying postgresql.org file Alvaro Herrera 17:38
alter table Maciej Piekielniak 18:11
Re: alter table Andreas Kretschmer 18:54
Re: alter table Maciej Piekielniak 19:23
Re: alter table Andreas Kretschmer 19:27
Re: alter table Maciej Piekielniak 19:30
Re: alter table Owen Jacobson 19:31
Re: alter table Maciej Piekielniak 19:45
Re: alter table Owen Jacobson 19:56
Re: alter table Stephan Szabo 20:03
Re: alter table Maciej Piekielniak 20:05
Re: alter table Owen Jacobson 20:09
Re: alter table Maciej Piekielniak 20:29
How to force PostgreSQL using an index Daniel Caune 21:58
Re: How to force PostgreSQL using an index Owen Jacobson 22:06
Re: How to force PostgreSQL using an index Andrew Sullivan 22:06
Re: How to force PostgreSQL using an index Daniel Caune 22:26
Re: How to force PostgreSQL using an index Owen Jacobson 22:32
Re: How to force PostgreSQL using an index Andrew Sullivan 22:33
Re: How to force PostgreSQL using an index Tom Lane 22:47
Re: How to force PostgreSQL using an index Daniel Caune 22:48
Re: How to force PostgreSQL using an index Tom Lane 23:02
Re: How to force PostgreSQL using an index Daniel Caune 23:22

Feb. 16, 2006

Thread Author Time
Re: alter table Michael Glaesemann 00:54
to count no of columns in a table AKHILESH GUPTA 09:13
Re: to count no of columns in a table Juris 09:34
Re: to count no of columns in a table A. Kretschmer 09:37
Re: [SQL] to count no of columns in a table Ragnar 09:40
VIEWs and TEMP tables problem Antal Attila 11:26
Re: VIEWs and TEMP tables problem Richard Huxton 11:57
Re: VIEWs and TEMP tables problem Markus Schaber 12:13
Re: How to force PostgreSQL using an index Daniel Caune 13:57
Re: VIEWs and TEMP tables problem Tom Lane 15:05
Using calculated columns as arguments in same SELECT Michael Burke 15:07
Re: Using calculated columns as arguments in same SELECT Michael Burke 15:42
Re: group by complications 📎 Mark Fenbers 17:47
Using EXPLAIN-ANALYZE Kashmira Patel (kupatel) 20:07
Re: Using EXPLAIN-ANALYZE Andrew Sullivan 20:39
Re: Using EXPLAIN-ANALYZE Abhishek 20:39
Re: Using EXPLAIN-ANALYZE Kashmira Patel (kupatel) 21:08
Re: Using EXPLAIN-ANALYZE Owen Jacobson 21:11
Re: Using EXPLAIN-ANALYZE Andrew Sullivan 21:14
Re: Using EXPLAIN-ANALYZE Kashmira Patel (kupatel) 21:15
Re: group by complications Markus Schaber 22:41

Feb. 17, 2006

Thread Author Time
ORDER BY with LTREE Axel Straschil 14:28
Given 02-01-2006 to 02-28-2006, output all days. Henry Ortega 21:07
Re: Given 02-01-2006 to 02-28-2006, output all days. Owen Jacobson 21:14
Re: Given 02-01-2006 to 02-28-2006, output all days. Michael Fuhr 21:20
Re: Given 02-01-2006 to 02-28-2006, output all days. Owen Jacobson 23:08
two count columns? Jan Danielsson 23:56

Feb. 18, 2006

Thread Author Time
Re: two count columns? Tom Lane 00:47
Re: two count columns? Greg Stark 00:51
Re: view of weekly data Greg Stark 07:36
Re: Tough Problem -- Record Checkouts Greg Stark 07:58
Interval subtracting Milorad Poluga 13:44
Re: Interval subtracting Milen A. Radev 14:24
Re: Interval subtracting Milorad Poluga 14:36
Re: Interval subtracting Milen A. Radev 14:45
Need help: Find dirty rows, Update, Delete SQL ogjunk-pgjedan 17:41
Re: [SQL] Interval subtracting Tom Lane 18:30
Re: [SQL] Interval subtracting Stephan Szabo 19:03

Feb. 19, 2006

Thread Author Time
Re: Need help: Find dirty rows, Update, Delete SQL Janning Vygen 10:44
Re: Given 02-01-2006 to 02-28-2006, output all days. Henry Ortega 18:47
Re: Given 02-01-2006 to 02-28-2006, output all days. Stephan Szabo 18:57
Re: Given 02-01-2006 to 02-28-2006, output all days. Michael Fuhr 19:07

Feb. 20, 2006

Thread Author Time
Re: ORDER BY with LTREE Michael Fuhr 07:41
Re: Interval subtracting Milorad Poluga 08:39
Re: SELECT on a to-be-determined table Patrick JACQUOT 11:02
Re: Need help: Find dirty rows, Update, Delete SQL Patrick JACQUOT 11:24
Re: ORDER BY CASE ... Bruno Wolff III 17:33
Re: Given 02-01-2006 to 02-28-2006, output all days. Pedro B. 20:30
Re: Given 02-01-2006 to 02-28-2006, output all days. Mark R. Dingee Pedro 20:39
Re: ... more than one count with left join Pedro B. 20:56

Feb. 21, 2006

Thread Author Time
Re: ORDER BY with LTREE Michael Fuhr 06:31
Re: ORDER BY with LTREE Axel Straschil 07:03
Avoid querying a specific field - how? Stefan Schwarzer 11:55
Re: Avoid querying a specific field - how? Ibrahim Tekin 15:32
Re: Avoid querying a specific field - how? Achilleus Mantzios 17:06

Feb. 22, 2006

Thread Author Time
restircting rows padmanabha konkodi 09:06
Re: passing array(java) to postgre sql function Markus Schaber 09:17
Re: restircting rows Richard Huxton 09:18
Re: restircting rows A. Kretschmer 09:19
Re: restircting rows Michael Glaesemann 09:23
Feature, my misconception or bug?? Achilleus Mantzios 12:04
Re: Feature, my misconception or bug?? Peter Eisentraut 12:47
Re: Feature, my misconception or bug?? Markus Schaber 12:55
Re: Feature, my misconception or bug?? Markus Schaber 12:56
pg reserved words Irina Gadassik 15:27
Re: Feature, my misconception or bug?? Achilleus Mantzios 16:31
Update in all tables Judith Altamirano Figueroa 17:59
'locking' the SELECTs based on indices... Mario Splivalo 18:02
Update in all tables Judith 18:08
Re: Update in all tables Janning Vygen 18:33
Re: 'locking' the SELECTs based on indices... Tom Lane 18:58
Re: Update in all tables Scott Marlowe 19:12
Re: Update in all tables Andrew Sullivan 21:13
Re: Update in all tables Scott Marlowe 21:16
Re: Update in all tables Owen Jacobson 21:25

Feb. 23, 2006

Thread Author Time
Re: Feature, my misconception or bug?? Achilleus Mantzios 09:03
Re: 'locking' the SELECTs based on indices... Mario Splivalo 10:13
Re: 'locking' the SELECTs based on indices... Mario Splivalo 11:02
Re: 'locking' the SELECTs based on indices... PFC 16:30
Re: 'locking' the SELECTs based on indices... PFC 16:35
Sum If Daniel Hernandez 17:46
Re: Sum If Jim Buttafuoco 18:09
Re: Sum If Daniel Hernandez 19:03
Re: 'locking' the SELECTs based on indices... Mario Splivalo 20:07
Question about index scan vs seq scan when using count() Kashmira Patel (kupatel) 21:44
Re: Question about index scan vs seq scan when using count() Andrew Sullivan 22:12
Re: Question about index scan vs seq scan when using count() Kashmira Patel (kupatel) 22:25
Re: Question about index scan vs seq scan when using count() Kashmira Patel (kupatel) 22:35
Re: Question about index scan vs seq scan when using count() Andrew Sullivan 22:47
Re: Question about index scan vs seq scan when using count() Kashmira Patel (kupatel) 22:55
Re: Question about index scan vs seq scan when using count() Owen Jacobson 23:08

Feb. 24, 2006

Thread Author Time
how to add primary key to existing table with multiple primary keys Daniel Joo 01:45
CREATE TABLE AS and tablespaces Markus Schaber 10:45
dbLink Query Richard C 11:29
"Installing" dbLink Richard C 11:48
Re: "Installing" dbLink A. Kretschmer 12:43
Re: After Trigger assignment to NEW Tom Lane 16:06
After Trigger assignment to NEW Achilleus Mantzios 16:44
Re: After Trigger assignment to NEW Alvaro Herrera 17:16
Re: After Trigger assignment to NEW Tom Lane 17:37
Missing fields on Query result. Daniel Hernandez 18:08
Re: Missing fields on Query result. Daniel Hernandez 18:10
Re: After Trigger assignment to NEW Owen Jacobson 18:58
Re: After Trigger assignment to NEW Achilleus Mantzios 19:47
Re: After Trigger assignment to NEW Achilleus Mantzios 19:51
Can't connect to the db Judith 22:17
Re: Can't connect to the db Andrew Sullivan 22:21
Obtaining client IP address Alexis Paul Bertolini 23:16
Re: Obtaining client IP address Michael Fuhr 23:34

Feb. 25, 2006

Thread Author Time
Re: CREATE TABLE AS and tablespaces Bruce Momjian 04:51
Relation 0 does not exist Yasuhiro Furuse 07:06
Re: After Trigger assignment to NEW Achilleus Mantzios 07:40
Re: Obtaining client IP address Alexis Paul Bertolini 09:26
Re: "Installing" dbLink Richard C 10:42
Index to support LIKE '%suffix' queries Florian Weimer 14:17
Re: After Trigger assignment to NEW Stephan Szabo 14:40
Re: Relation 0 does not exist Alvaro Herrera 15:24
Re: Index to support LIKE '%suffix' queries Tom Lane 17:22
Re: Index to support LIKE '%suffix' queries Florian Weimer 17:52
Re: Index to support LIKE '%suffix' queries Alvaro Herrera 18:13

Feb. 26, 2006

Thread Author Time
Re: Relation 0 does not exist Yasuhiro Furuse 23:26

Feb. 27, 2006

Thread Author Time
Re: Slow update SQL Bungsuputra Linan 02:42
Disabling triggers/constraints pg<8.1 Bath, David 02:44
Dump/restore comments only? Bath, David 02:56
Problem with query on history table Andreas Joseph Krogh 07:19

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28