pgsql-sql since 2007-12-10 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

Dec. 10, 2007

Thread Author Time
join on three tables is slow Gerry Reno 01:31
Re: join on three tables is slow Gerry Reno 02:16
Re: join on three tables is slow Shane Ambler 04:45
SQL INSERT/TRIGGER Help Poovendran Moodley 06:36
Re: SQL INSERT/TRIGGER Help A. Kretschmer 06:44
Re: SQL INSERT/TRIGGER Help Poovendran Moodley 07:27
Re: SQL INSERT/TRIGGER Help A. Kretschmer 07:43
Re: SQL INSERT/TRIGGER Help Poovendran Moodley 09:13
Re: INSERT INTO relational tables Stefan Scheidegger 10:42
Re: INSERT INTO relational tables A. Kretschmer 11:08
Re: INSERT INTO relational tables A. Kretschmer 11:29
Re: INSERT INTO relational tables Stefan Scheidegger 13:21
Re: SQL INSERT/TRIGGER Help Alvaro Herrera 14:08

Dec. 11, 2007

Thread Author Time
Insert Rule, Multiple Insert, Update Problem Scott 04:23
Re: join on three tables is slow Gerry Reno 04:24
Re: Insert Rule, Multiple Insert, Update Problem Richard Broersma Jr 04:50
Re: join on three tables is slow Pavel Stehule 06:00
Re: join on three tables is slow Gerry Reno 13:23
Re: join on three tables is slow Pavel Stehule 14:55
case sensitivity for tables, columns, and constraint names Ertel, Steve 17:05
Re: case sensitivity for tables, columns, and constraint names A. Kretschmer 17:24
Re: case sensitivity for tables, columns, and constraint names Andrew Sullivan 17:30
Re: case sensitivity for tables, columns, and constraint names Richard Huxton 17:35
Re: join on three tables is slow Gerry Reno 18:18
Foreign Key for multi PK or design question PostgreSQL Admin 18:20
Re: Foreign Key for multi PK or design question Erik Jones 18:35
Re: Foreign Key for multi PK or design question A. Kretschmer 18:53
Re: Foreign Key for multi PK or design question PostgreSQL Admin 19:12
Re: Foreign Key for multi PK or design question Alvaro Herrera 19:42
Re: join on three tables is slow Pavel Stehule 19:46
Re: Foreign Key for multi PK or design question A. Kretschmer 19:48
Re: Foreign Key for multi PK or design question PostgreSQL Admin 20:04

Dec. 12, 2007

Thread Author Time
Query design assistance - getting daily totals Paul Lambert 01:34
Re: join on three tables is slow Tom Lane 04:35
Function result using execute Paul Lambert 05:15
Re: Function result using execute Tom Lane 06:01
Re: Function result using execute Erik Jones 06:25
Re: Function result using execute Paul Lambert 06:30
Re: Query design assistance - getting daily totals A. Kretschmer 06:31
Re: Query design assistance - getting daily totals Paul Lambert 06:39
Re: Query design assistance - getting daily totals A. Kretschmer 07:29
Re: join on three tables is slow Gerry Reno 14:29
Re: Query design assistance - getting daily totals Scott Marlowe 15:48
Query Assistance Gary Chambers 16:58
Re: Query Assistance D'Arcy J.M. Cain 17:31
Re: Query Assistance Gary Chambers 18:00
Re: Query design assistance - getting daily totals Rodrigo De León 19:53
Re: Query Assistance Richard Huxton 20:21
Trigger definition . . . puzzled Rolf A. de By 21:38
Re: Trigger definition . . . puzzled Erik Jones 22:30

Dec. 13, 2007

Thread Author Time
Re: Trigger definition . . . puzzled Rolf A. de By 07:19
Re: Trigger definition . . . puzzled Tom Lane 15:49
Re: Trigger definition . . . puzzled Rolf A. de By 15:59
Re: Trigger definition . . . puzzled Tom Lane 16:33
Re: Trigger definition . . . puzzled Rolf A. de By 20:22
Re: Query design assistance - getting daily totals Steve Midgley 21:11
SELECT MAX returns wrong value 📎 Gavin Baumanis 23:09
Re: SELECT MAX returns wrong value Tom Lane 23:32

Dec. 14, 2007

Thread Author Time
odd error updating - varchar Gary Stainburn 17:02
Re: odd error updating - varchar Tom Lane 17:17
Re: SELECT MAX returns wrong value Scott Marlowe 17:24

Dec. 15, 2007

Thread Author Time
Bad count of rows estimated for emerge join Oleg Kharin 15:15

Dec. 17, 2007

Thread Author Time
passing a multiple join to a function? Louis-David Mitterrand 13:06
Describe Table danap 16:56
Re: passing a multiple join to a function? Rodrigo De León 17:27
Re: Describe Table Erik Jones 17:33
Re: Describe Table Colin Wetherbee 17:34
Re: Describe Table Richard Broersma Jr 17:47
Re: Describe Table Tom Lane 18:03
Insert into and Sequence Luigi Pirillo 19:30

Dec. 18, 2007

Thread Author Time
Re: Describe Table danap 01:21
System catalog future changes Steve Midgley 16:53
Re: System catalog future changes Pavel Stehule 17:36
Re: System catalog future changes Erik Jones 17:38
Re: System catalog future changes Steve Midgley 19:29

Dec. 19, 2007

Thread Author Time
Re: Insert into and Sequence 📎 Ireneusz Pluta 13:21
DBLink or setof record functions & type shortcuts Jeff Trout 15:23

Dec. 20, 2007

Thread Author Time
sql query - create replace function Iuri Sampaio 05:29
Re: sql query - create replace function Richard Huxton 08:31

Dec. 21, 2007

Thread Author Time
Concatenation through SQL Philippe Lang 10:33
Re: Concatenation through SQL Andreas Kretschmer 10:58
Re: Concatenation through SQL Pavel Stehule 11:07
Re: Concatenation through SQL Leif B. Kristensen 11:16
Re: Concatenation through SQL imad 11:51
Re: Concatenation through SQL Niklas Johansson 12:07
Re: Concatenation through SQL Leif B. Kristensen 12:31
Re: Concatenation through SQL Philippe Lang 13:48
Re: Concatenation through SQL Pavel Stehule 14:24
Re: Concatenation through SQL Philippe Lang 16:01

Dec. 22, 2007

Thread Author Time
Misnamed field in subquery does not cause error when field name exists in parent query Rick Innis 22:12

Dec. 23, 2007

Thread Author Time
Re: Misnamed field in subquery does not cause error when field name exists in parent query Michael Glaesemann 00:14
Re: passing a multiple join to a function? Louis-David Mitterrand 16:37
returning an array as a list fo single-column rows? Louis-David Mitterrand 20:55
Re: returning an array as a list fo single-column rows? Pavel Stehule 21:19
Re: returning an array as a list fo single-column rows? Louis-David Mitterrand 21:22
Re: returning an array as a list fo single-column rows? Pavel Stehule 21:27
Re: returning an array as a list fo single-column rows? Louis-David Mitterrand 21:33
Re: returning an array as a list fo single-column rows? Pavel Stehule 21:45
returning an array as a list of single-column rows... (different approach) pgsql 23:02

Dec. 24, 2007

Thread Author Time
Different Query plans filtering between dates Dani Castaños 12:49
Re: Different Query plans filtering between dates Pavel Stehule 13:12
slow query - only uses indices Marc 14:46
Re: slow query - only uses indices imad 16:34
Re: slow query - only uses indices Pavel Stehule 16:41
Re: Misnamed field in subquery does not cause error when field name exists in parent query Rick Innis 19:25

Dec. 26, 2007

Thread Author Time
Advice for generalizing trigger functions Richard Broersma Jr 00:20
Re: Advice for generalizing trigger functions chester c young 18:11
need help A. Wiryawan 19:19
Re: Advice for generalizing trigger functions Richard Broersma Jr 20:20
Re: need help Richard Broersma Jr 20:22
Re: need help Richard Broersma Jr 20:42

Dec. 27, 2007

Thread Author Time
how to use pgsql like mssql 📎 liuzg2 00:18
Re: how to use pgsql like mssql 📎 liuzg2 02:05
Re: how to use pgsql like mssql Pavel Stehule 04:54
Re: how to use pgsql like mssql Pavel Stehule 04:55
Re: Advice for generalizing trigger functions Erik Jones 17:51
Re: Advice for generalizing trigger functions Richard Broersma Jr 18:03
Re: Advice for generalizing trigger functions Erik Jones 18:22

Dec. 29, 2007

Thread Author Time
Re: Advice for generalizing trigger functions Marcin Stępnicki 02:09
PL/pgsql: function passing argument to IN operator Daniel Myers 06:40
Re: PL/pgsql: function passing argument to IN operator Pavel Stehule 07:29
sql query question ? Trilok Kumar 10:52
Re: sql query question ? Shane Ambler 17:22
temp table existence Marcin Krawczyk 19:16
Re: temp table existence Pavel Stehule 19:33
Re: temp table existence Marcin Krawczyk 20:43
Re: temp table existence Marcin Krawczyk 21:16
Re: temp table existence Pavel Stehule 21:23
Re: temp table existence Adrian Klaver 22:25

Dec. 30, 2007

Thread Author Time
Re: temp table existence Erik Jones 06:26
Re: temp table existence Pavel Stehule 08:44

Dec. 31, 2007

Thread Author Time
Re: sql query question ? Trilok Kumar 13:53
Limit # of recs on inner join? Josh 18:52

Jan. 1, 2008

Thread Author Time
Re: Limit # of recs on inner join? Rodrigo E. De León Plicet 02:07
Re: Limit # of recs on inner join? Richard Broersma Jr 05:25
Using rules to implement backward-compatible schema changes Mario Becroft 05:51
Re: Using rules to implement backward-compatible schema changes Tom Lane 07:09
Re: Using rules to implement backward-compatible schema changes Mario Becroft 07:40
Re: EPOCH TIMESTAMP Conversion Problem Louis-David Mitterrand 14:28
Re: EPOCH TIMESTAMP Conversion Problem Tom Lane 19:03
Re: EPOCH TIMESTAMP Conversion Problem Michael Glaesemann 19:32

Jan. 2, 2008

Thread Author Time
PG is in different timezone than the OS Fernando Hevia 18:43
Re: PG is in different timezone than the OS Scott Marlowe 20:06
Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Scott Marlowe 20:18
Re: PG is in different timezone than the OS Scott Marlowe 20:27
Re: [SQL] PG is in different timezone than the OS Scott Marlowe 20:31
Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Joe 20:49
Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Scott Marlowe 23:29
Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Tom Lane 23:45

Jan. 3, 2008

Thread Author Time
Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Fernando Hevia 12:27
WAL archiving blowed. Gerardo Herzig 19:33

Jan. 4, 2008

Thread Author Time
Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db? Fernando Hevia 03:57
Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db? Tom Lane 04:37
Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db? Fernando Hevia 14:01

Jan. 6, 2008

Thread Author Time
tsearch2: ts_headline performance problem Anders Østergaard Jensen 14:15
Re: tsearch2: ts_headline performance problem Oleg Bartunov 15:09

Jan. 7, 2008

Thread Author Time
reading WAL files in python Gerardo Herzig 13:19
Re: reading WAL files in python C. Bergström 14:05
Re: reading WAL files in python Gerardo Herzig 14:26
Cheers for DISTINCT ON Peter Kovacs 16:02
Re: Cheers for DISTINCT ON Andrew Sullivan 16:18
Re: Cheers for DISTINCT ON Bruce Momjian 16:22
Re: Cheers for DISTINCT ON Chris Browne 17:51
Re: Cheers for DISTINCT ON Chris Browne 17:52
Re: Cheers for DISTINCT ON Andrew Sullivan 18:35
Re: reading WAL files in python Erik Jones 18:53
Re: reading WAL files in python gherzig 20:47
Get the max(value1, value2, value3) from a table Emi Lu 22:03
Re: Get the max(value1, value2, value3) from a table Scott Marlowe 22:16
Re: Get the max(value1, value2, value3) from a table Richard Broersma Jr 22:27
Re: Get the max(value1, value2, value3) from a table Scott Marlowe 22:37
Re: Get the max(value1, value2, value3) from a table Emi Lu 22:37
Re: Get the max(value1, value2, value3) from a table Josh Williams 22:38
Re: Get the max(value1, value2, value3) from a table Scott Marlowe 22:40
Re: Get the max(value1, value2, value3) from a table Scott Marlowe 22:43
Re: Get the max(value1, value2, value3) from a table Emi Lu 22:53
Re: Get the max(value1, value2, value3) from a table Scott Marlowe 23:16
Re: Get the max(value1, value2, value3) from a table Erik Jones 23:16

Jan. 8, 2008

Thread Author Time
How to keep at-most N rows per group? periodic DELETEs or constraints or..? Jamie Tufnell 14:24
Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? codeWarrior 15:45
Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Erik Jones 16:30
Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Jamie Tufnell 16:31
Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Steve Midgley 17:31
Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Jamie Tufnell 17:41
Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? codeWarrior 17:53
trigger for TRUNCATE? Gerardo Herzig 18:19
Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Erik Jones 18:28
Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Jamie Tufnell 18:49
Re: trigger for TRUNCATE? Chris Browne 20:57
Re: trigger for TRUNCATE? Pavel Stehule 21:38

Jan. 9, 2008

Thread Author Time
Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Steve Midgley 18:20
Re: Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Scott Marlowe 19:09
Re: Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Erik Jones 20:17
Re: Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Jamie Tufnell 23:30

Jan. 10, 2008

Thread Author Time
Support for SQL TOP clause? Chinyi Woo 03:13
Re: Support for SQL TOP clause? Phillip Smith 03:19
Shorthand column labels (SELECT col1 foo, ...) vs (SELECT col1 AS foo, ...) Ken Johanson 07:11
Re: Shorthand column labels (SELECT col1 foo, ...) vs (SELECT col1 AS foo, ...) Paul Lambert 07:20
Re: Shorthand column labels (SELECT col1 foo, ...) vs (SELECT col1 AS foo, ...) Ken Johanson 07:40
Re: Shorthand column labels (SELECT col1 foo, ...) vs (SELECT col1 AS foo, ...) Paul Lambert 08:04

Browse Archives

Prev | Next