pgsql-sql - May 2007

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 22 23 24 25 29 30 31

May 1, 2007

Thread Author Time
"is not distinct from" syntax error? Collin Peters 00:03
Re: "is not distinct from" syntax error? Tom Lane 00:46
Re: Dynamic prepare possible in plpgsql? Tom Lane 00:52
Re: Dynamic prepare possible in plpgsql? Collin Peters 16:52
Re: Dynamic prepare possible in plpgsql? Jonah H. Harris 17:16

May 2, 2007

Thread Author Time
Re: We all are looped on Internet: request + transport = invariant Dmitry Turin 05:05
Re: We all are looped on Internet: request + transport = invariant Joe 12:47
Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant Richard Huxton 14:19
Re: Dynamic prepare possible in plpgsql? Collin Peters 15:53
Possible to access value in RECORD without knowing column name? Collin Peters 19:17
Re: Possible to access value in RECORD without knowing column name? Richard Albright 19:26

May 3, 2007

Thread Author Time
Joe Celko's method to "generate_series" not working? Richard Broersma Jr 00:17
Re: Joe Celko's method to "generate_series" not working? Richard Broersma Jr 00:35
Needs Function Penchalaiah P. 04:38
Needs Function Penchalaiah P. 04:38
Re: Dynamic prepare possible in plpgsql? Tom Lane 05:55
Re: Needs Function Rodrigo De León 07:17
Re: Needs Function Aaron Bono 14:14
Re: Needs Function Bart Degryse 14:20
Insert into VIEW using RULE. Not possible to use nextval()? Collin Peters 17:04
Re: Insert into VIEW using RULE. Not possible to use nextval()? Richard Broersma Jr 17:26
Re: Insert into VIEW using RULE. Not possible to use nextval()? Collin Peters 18:30
Re: Insert into VIEW using RULE. Not possible to use nextval()? Richard Broersma Jr 19:26

May 4, 2007

Thread Author Time
select slows from 3 seconds to 30 seconds 📎 Gary Stainburn 15:49
Re: Insert into VIEW using RULE. Not possible to use nextval()? Collin Peters 21:51
Re: Insert into VIEW using RULE. Not possible to use nextval()? Richard Broersma Jr 22:16

May 5, 2007

Thread Author Time
Re: select slows from 3 seconds to 30 seconds Tom Lane 00:57
Sequence vs. Index Scan Aaron Bono 21:05
Re: Sequence vs. Index Scan Andrew Sullivan 21:30
Re: Sequence vs. Index Scan Aaron Bono 22:00

May 6, 2007

Thread Author Time
Re: Sequence vs. Index Scan Tom Lane 00:22
Re: Sequence vs. Index Scan Andrew Sullivan 00:40
Re: Sequence vs. Index Scan Aaron Bono 03:28
Re: Sequence vs. Index Scan Aaron Bono 04:13
Re: Sequence vs. Index Scan Aaron Bono 04:25
Re: Sequence vs. Index Scan Jaime Casanova 04:37
ROW_NUMBER alias Robins 16:01
Re: ROW_NUMBER alias Stefan Becker 18:41
Re: Sequence vs. Index Scan Aaron Bono 18:45
Re: hi John Summerfield 23:42

May 7, 2007

Thread Author Time
Re: ROW_NUMBER alias Robins 02:03
How to use function PointN? Nemo Terry 08:07
syntax error in "createdb" kannan kk 09:01
Re: syntax error in "createdb" Joris Dobbelsteen 09:12
Re: [SQL] syntax error in "createdb" Phillip Smith 09:25
Re: Sequence vs. Index Scan Andrew Sullivan 10:58
Re: How to use function PointN? Michael Fuhr 13:13
Re: Sequence vs. Index Scan Tom Lane 14:37
Temporal Table Relations and Referential Integrity Richard Broersma Jr 14:59
Re: Sequence vs. Index Scan Aaron Bono 16:40
Re: Dynamic prepare possible in plpgsql? Jim Nasby 16:58
Error: Input string was not in a correct format Rommel the iCeMAn 23:17
Re: Error: Input string was not in a correct format Rommel the iCeMAn 23:37
Re: Error: Input string was not in a correct format Michael Glaesemann 23:46

May 8, 2007

Thread Author Time
Re: Error: Input string was not in a correct format Tom Lane 00:11
Query RE using COPY Paul Lambert 01:51
Re: Query RE using COPY Jonah H. Harris 02:16
Re: Query RE using COPY Paul Lambert 02:44
Re: Query RE using COPY Phillip Smith 04:14
Re: Query RE using COPY Paul Lambert 04:22
Re: select slows from 3 seconds to 30 seconds Gary Stainburn 10:08
Needs Query Penchalaiah P. 12:18
Re: Needs Query A. Kretschmer 12:58
Re: Query RE using COPY Jonah H. Harris 13:30
Re: Needs Query Reuven Abliyev 14:00
Re: Error: Input string was not in a correct format Rommel the iCeMAn 14:10

May 9, 2007

Thread Author Time
query to select a linked list Louis-David Mitterrand 12:55
Re: query to select a linked list Gregory Stark 13:24
Re: query to select a linked list Louis-David Mitterrand 13:28
Re: query to select a linked list Aaron Bono 13:29
Re: query to select a linked list Achilleas Mantzios 13:31
Re: query to select a linked list Louis-David Mitterrand 14:30
Re: query to select a linked list Louis-David Mitterrand 14:33
Re: query to select a linked list Scott Marlowe 18:03
Re: query to select a linked list Scott Marlowe 18:04
Re: query to select a linked list Gregory Stark 23:16
Re: query to select a linked list Robert Edwards 23:49

May 10, 2007

Thread Author Time
Passing input to a view? Paul Lambert 06:03
Re: Passing input to a view? A. Kretschmer 06:14
Re: Passing input to a view? Phillip Smith 06:14
Count rows by day interval Loredana Curugiu 08:01
Re: query to select a linked list Louis-David Mitterrand 08:05
insert a sequence ivan marchesini 14:49
Re: Count rows by day interval chester c young 18:34

May 11, 2007

Thread Author Time
Re: insert a sequence Ireneusz Pluta 10:03
PL/PGSQL Record type question Gábriel Ákos 14:00
Re: PL/PGSQL Record type question imad 14:09
Re: PL/PGSQL Record type question Gábriel Ákos 14:42
Re: PL/PGSQL Record type question John DeSoi 15:12
Convert serial column to regular integer Collin Peters 16:24
Re: Convert serial column to regular integer Rodrigo De León 16:36
Re: PL/PGSQL Record type question imad 16:40
Re: PL/PGSQL Record type question Robins 17:39
Re: PL/PGSQL Record type question imad 18:19
Re: Convert serial column to regular integer Collin Peters 20:18
Re: Convert serial column to regular integer Tom Lane 20:32
check_constraint and Extract not working? Fernando Hevia 21:14

May 12, 2007

Thread Author Time
Howto convert / (re)store xml column to table in trigger using contrib/xml2? Joost Kraaijeveld 09:32
Funny date-sorting task Andreas 23:40

May 13, 2007

Thread Author Time
Re: Funny date-sorting task Frank Bax 03:13
Re: Funny date-sorting task Rodrigo De León 08:49
Re: Funny date-sorting task Greg Sabino Mullane 13:47

May 14, 2007

Thread Author Time
Re: table juxtaposition Rodrigo De León 05:56
need help Penchalaiah P. 06:50
Re: need help Ashish Karalkar 06:55
Re: need help Andrej Ricnik-Bay 06:59
ignoring primary key violations in COPY command singh.srajendra 11:57
ignoring primary key violations in COPY command singh.srajendra 12:36
select ..... not in ..... Gary Stainburn 15:07
Re: select ..... not in ..... Tom Lane 15:37
Re: Temporal Table Relations and Referential Integrity Michael Glaesemann 16:10
Re: Temporal Table Relations and Referential Integrity Richard Broersma Jr 17:00
How to retrieve a n-ary tree in SQL? Joost Kraaijeveld 18:02
Re: need help Aaron Bono 18:40
Re: How to retrieve a n-ary tree in SQL? Rodrigo De León 20:12
pg_dump? Richard Dunne 22:48
Doing a conditional aggregate (e.g. count(*) if x=y) in postgres? Bryce Nesbitt 22:55
Re: pg_dump? Paul Lambert 22:56
Re: Doing a conditional aggregate (e.g. count(*) if x=y) in postgres? Jim Buttafuoco 23:16
Re: Doing a conditional aggregate (e.g. count(*) if x=y) in postgres? Geoff Tolley 23:18
Re: Doing a conditional aggregate (e.g. count(*) if x=y) in postgres? Bryce Nesbitt 23:48

May 15, 2007

Thread Author Time
How to process inverted comma in "EXECUTE 'insert into xxx values(...)'; "? Nemo Terry 04:51
Re: How to process inverted comma in "EXECUTE 'insert into xxx values(...)'; "? Rodrigo De León 06:25
Re: How to process inverted comma in "EXECUTE 'insert into xxx values(...) Nemo Terry 06:50
Re: How to process inverted comma in "EXECUTE 'insert into xxx values(...) Richard Huxton 07:12
Re: How to process inverted comma in "EXECUTE 'insert into xxx values(...) Rodrigo De León 07:14
Re: How to process inverted comma in "EXECUTE 'insert into xxx values(...) Nemo Terry 07:42
workday function Gary Stainburn 08:51
Re: workday function Richard Huxton 09:09
Re: workday function Richard Huxton 09:17
Re: workday function Kenneth Gonsalves 09:28
Re: workday function Reinoud van Leeuwen 09:44
Re: workday function Dave Page 09:46
Re: pg_dump? Andrew Sullivan 11:19
Serial number of a record [email protected] 11:40
Re: workday function Pavel Stehule 12:03
SQL Query Validate Records Multiple Tables - Help Needed Paul251 13:17
Re: Serial number of a record Andrew Sullivan 13:36
Re: workday function 📎 Gary Stainburn 14:09
Adding "on delete cascade" to all foreign key constraints Peter Hanson 17:19
Re: SQL Query Validate Records Multiple Tables - Help Needed Rodrigo De León 22:32

May 16, 2007

Thread Author Time
Re: Adding "on delete cascade" to all foreign key constraints Jim C. Nasby 01:38
Re: SQL Query Validate Records Multiple Tables - HelpNeeded Bart Degryse 06:59

May 17, 2007

Thread Author Time
doubt S balasankaravadivel 09:43
Whole-row comparison ? christian.roche.ext 12:56
How can you generate a counter for ordered sets? Christopher Maier 13:19
Re: Whole-row comparison ? Richard Broersma Jr 13:38
Re: Whole-row comparison ? Richard Broersma Jr 17:20
Re: Whole-row comparison ? christian.roche.ext 18:00

May 18, 2007

Thread Author Time
Re: hi Lew 12:43

May 19, 2007

Thread Author Time
Against legal disclaimers in email Tom Lane 18:33
Re: ignoring primary key violations in COPY command Paul Lambert 22:29
Re: ignoring primary key violations in COPY command chester c young 23:58

May 20, 2007

Thread Author Time
Re: doubt John DeSoi 01:01

May 22, 2007

Thread Author Time
system table storing sequence attributes Sabin Coanda 07:03
Re: system table storing sequence attributes Marcin Stępnicki 07:43
Re: system table storing sequence attributes Sabin Coanda 12:23
Re: system table storing sequence attributes A. Kretschmer 12:38
Re: system table storing sequence attributes Marcin Stępnicki 12:41
Re: system table storing sequence attributes Sabin Coanda 13:12
Re: system table storing sequence attributes A. Kretschmer 13:22
Re: system table storing sequence attributes Sabin Coanda 13:47
Re: system table storing sequence attributes Milen A. Radev 14:01

May 23, 2007

Thread Author Time
FATAL: cache lookup failed for function 1003 John Summerfield 13:41
Re: FATAL: cache lookup failed for function 1003 Alvaro Herrera 20:37
Re: FATAL: cache lookup failed for function 1003 John Summerfield 23:01
Re: FATAL: cache lookup failed for function 1003 Alvaro Herrera 23:10
Re: FATAL: cache lookup failed for function 1003 Tom Lane 23:16

May 24, 2007

Thread Author Time
Potential bug in postgres 8.2.4 Tomas Doran 11:20
Re: Potential bug in postgres 8.2.4 Marcin Stępnicki 11:34
Re: Potential bug in postgres 8.2.4 Peter Eisentraut 11:51
Re: Potential bug in postgres 8.2.4 Tomas Doran 11:54
Re: Potential bug in postgres 8.2.4 Richard Huxton 12:19
Re: Potential bug in postgres 8.2.4 Marcin Stępnicki 12:30
Re: Potential bug in postgres 8.2.4 Tomas Doran 12:34
Re: Potential bug in postgres 8.2.4 Tom Lane 14:51
Re: Potential bug in postgres 8.2.4 Tomas Doran 15:19
off topic chester c young 18:15
Re: off topic Rodrigo De León 18:23
group by day Edward W. Rouse 18:49
Re: group by day A. Kretschmer 19:42
Re: group by day Rodrigo De León 19:45

May 25, 2007

Thread Author Time
Re: group by day Richard Huxton 08:08

May 29, 2007

Thread Author Time
aggregate query Raj A 04:32
Re: aggregate query Andrew Kroeger 08:04
Re: aggregate query Gregory Stark 10:50
Re: aggregate query Raj A 12:32
Recursively traversing a partially ordered set Jason Grout 14:06
Re: Recursively traversing a partially ordered set Gregory Stark 15:47
problems with SELECT query results Joshua 15:47
Re: problems with SELECT query results Richard Huxton 16:36
Re: problems with SELECT query results Joshua 17:46
Re: problems with SELECT query results Lew 19:33
Re: problems with SELECT query results Richard Broersma Jr 20:35

May 30, 2007

Thread Author Time
spi and error messages Bart Degryse 07:33
logging amount rows retrieved? Gerardo Herzig 13:44
Re: spi and error messages Michael Fuhr 14:13
slow query execution Trigve Siver 15:56
Re: slow query execution Andrew Sullivan 16:45
Re: slow query execution Trigve Siver 17:03

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 22 23 24 25 29 30 31