pgsql-sql - January 2004

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 26 27 28 29 30 31

Jan. 1, 2004

Thread Author Time
Re: not in vs not exists - vastly diferent performance Randolf Richardson 04:48
Re: Radius of a zip code Randolf Richardson 04:56
Re: [SQL] index row size 2728 exceeds btree maximum, 2713 Dinesh Pandey 09:43
Re: index row size 2728 exceeds btree maximum, 2713 Dinesh Pandey 10:09

Jan. 2, 2004

Thread Author Time
Stored procedures beyaRecords - The home Urban music 01:50
Re: Stored procedures Tom Lane 02:10
Ambiguous error message Samuel Tardieu 16:49

Jan. 3, 2004

Thread Author Time
Re: Ambiguous error message Michael Glaesemann 00:46
Re: Ambiguous error message Tom Lane 00:47
Re: Ambiguous error message Samuel Tardieu 00:55
Re: Ambiguous error message Samuel Tardieu 00:56
Re: Ambiguous error message Michael Fuhr 01:05
sort by on two columns Andy Lewis 01:15
Re: Ambiguous error message Bertrand Petit 01:30
Re: sort by on two columns Michael Glaesemann 02:40
Re: sort by on two columns Andy Lewis 02:55
Re: sort by on two columns Michael Glaesemann 03:04
Re: sort by on two columns Chris Travers 04:05
Re: sort by on two columns Adam Ruth 04:32
Complex Update John Coryat 09:20

Jan. 4, 2004

Thread Author Time
DO INSTEAD in rule Tatsuo Ishii 13:51
Re: DO INSTEAD in rule Tom Lane 17:48
Historic Query using a view/function ? Chris Gamache 18:54
Re: DO INSTEAD in rule Tatsuo Ishii 23:39

Jan. 5, 2004

Thread Author Time
Re: not in vs not exists - vastly diferent performance Iain 01:40
Re: "on insert" rules happen before the insert? Tom Lane 05:26
Virtual records Kumar 11:04
Re: Complex Update Richard Huxton 11:10
grouping by date teknokrat 17:14
ecpg - problem compiling prepare and declare statements Paul Tilles 18:14
PostgreSQL Array Syntax Evan Klinger 21:47
Re: Virtual records Rich Hall 23:21

Jan. 6, 2004

Thread Author Time
Calendar Scripts - Quite a complex one Kumar 06:06
Re: Calendar Scripts - Quite a complex one Peter Eisentraut 18:56
Re: Calendar Scripts - Quite a complex one Josh Berkus 22:13
unix time -> timestamp boyd 23:29
Re: unix time -> timestamp boyd 23:36
question : the choice of the primary key. Loeke 23:38

Jan. 7, 2004

Thread Author Time
Re: Calendar Scripts - Quite a complex one Kumar 06:06
COPY command azwa 06:19
Re: Calendar Scripts - Quite a complex one Chris Travers 07:49
COPY command azwa 08:35
Different query results in psql and Perl DBI with Postgres 7.2.1 Brendan LeFebvre 11:14
Re: Calendar Scripts - Quite a complex one Kumar 12:39
Importation wtih copy generated some wrong registers.. Rodrigo Sakai 13:58
unique constraints Kenneth Gonsalves 14:17
Re: question : the choice of the primary key. Loeke 14:17
Notation of index Andreas 17:09
Re: unique constraints Michael Fuhr 17:31
Re: Notation of index Richard Huxton 18:25
Re: Notation of index Peter Eisentraut 18:36
Re: Importation wtih copy generated some wrong registers.. Peter Eisentraut 18:41

Jan. 8, 2004

Thread Author Time
Re: unique constraints Kenneth Gonsalves 04:20
Re: Calendar Scripts - Quite a complex one Chris Travers 10:02
Re: Different query results in psql and Perl DBI with Postgres 7.2.1 boyd 12:05
Start-up problems beyaRecords - The home Urban music 12:59
Date select question... Lance Munslow 13:13
Re: Start-up problems Kaloyan Iliev Iliev 14:00
Re: Start-up problems Johannes Lochmann 14:17

Jan. 9, 2004

Thread Author Time
data loading azwa 02:13
Re: COPY command Gregory S. Williamson 03:06
Re: COPY command azwa 04:11
Re: COPY command Michael Glaesemann 04:49
Re: grouping by date Robert Creager 04:59
Left outer join on multiple tables David Witham 05:23
Re: Date select question... Tom Lane 05:49
Missing data for column azwa 07:15
Type conversion from TEXT to DOUBLE PRECISION Daniel Lau 07:35
Re: Type conversion from TEXT to DOUBLE PRECISION Tom Lane 07:47
Re: Type conversion from TEXT to DOUBLE PRECISION Richard Huxton 08:09
Re: Missing data for column Michael Glaesemann 09:54
Re: Type conversion from TEXT to DOUBLE PRECISION Tom Lane 14:57
Re: Type conversion from TEXT to DOUBLE PRECISION Daniel Lau 15:44
Re: data loading Richard Huxton 20:04
Re: data loading Richard Huxton 20:06
how to show table structure? Bing Du 23:05
Re: how to show table structure? scott.marlowe 23:10
Re: how to show table structure? Larry Rosenman 23:12

Jan. 10, 2004

Thread Author Time
Re: how to show table structure? Kumar 04:03
Adding a column to a VIEW which has dependent objects. Rajesh Kumar Mallah 07:54
Re: Adding a column to a VIEW which has dependent objects. Tom Lane 16:48
Re: data loading Jeff Eckermann 18:28

Jan. 11, 2004

Thread Author Time
Re: Different query results in psql and Perl DBI with Postgres 7.2.1 Greg Sabino Mullane 19:17
Re: Left outer join on multiple tables Peter Eisentraut 19:55

Jan. 12, 2004

Thread Author Time
Re: Missing data for column azwa 01:07
Select into beyaRecords - The home Urban music 01:09
Problem with NOT IN portion of query. Robert Creager 04:04
Unique field key or several fks ? Katarn 05:18
Unique key field or serverl fks ? katarn 05:51
Re: Problem with NOT IN portion of query. Tomasz Myrta 06:28
Insert into azwa 09:12
Re: Select into Richard Huxton 09:45
Re: Unique key field or serverl fks ? Richard Huxton 09:52
Re: Problem with NOT IN portion of query. Robert Creager 13:05
Triggers beyaRecords - The home Urban music 16:14
Re: Triggers Peter Eisentraut 16:33
Re: Adding a column to a VIEW which has dependent objects. scott.marlowe 16:34
Re: Triggers Sai Hertz And Control Systems 16:47
Re: Triggers Richard Huxton 17:11
Re: Unique key field or serverl fks ? katarn 21:36
Is it possible in PostgreSQL? Bronx 23:58

Jan. 13, 2004

Thread Author Time
Transpose rows to columns David Witham 01:12
Re: Transpose rows to columns Michael Glaesemann 03:50
Re: Triggers Benoît BOURNON 08:26
Re: Triggers BenLaKnet 09:11
Re: Insert into Gabriel Dovalo Carril 10:15
problem with function trigger jclaudio 11:00
problem with function trigger jclaudio 13:42
Problems with postgresql 7.4.1 configuration - URGENT beyaRecords - The home Urban music 14:05
Email function using c instead of tclu beyaRecords - The home Urban music 14:19
Re: Problems with postgresql 7.4.1 configuration - URGENT Peter Eisentraut 15:31
Re: Transpose rows to columns Luis C. Ferreira (aka lcf) 15:46
Re: Problems with postgresql 7.4.1 configuration - URGENT Tom Lane 15:54
Re: Problems with postgresql 7.4.1 configuration - URGENT Sai Hertz And Control Systems 16:01
Copying rows between tables? Steve Wampler 16:23
Re: Copying rows between tables? Viorel Dragomir 16:30
Re: Copying rows between tables? Reinoud van Leeuwen 16:32
can insert 'null' into timestamp type field from command line but not from input file? Bing Du 17:28
Re: can insert 'null' into timestamp type field from command scott.marlowe 17:31
Re: can insert 'null' into timestamp type field from command Bing Du 17:45
Configure issues beyaRecords - The home Urban music 18:45
Re: Copying rows between tables? Sai Hertz And Control Systems 18:49
help with limiting query results OizOne 19:34
Re: Configure issues Peter Eisentraut 19:36
Rule won't let me NOTIFY, no matter how hard I try Jeff Boes 21:07
Historical logging of pg_stat_activity ? Stef 21:40

Jan. 14, 2004

Thread Author Time
Re: Insert into:Bad date external representation azwa 07:39
Re: Insert into:Bad date external representation Michael Glaesemann 08:24
DROP TRIGGER sad 14:45
Re: Transpose rows to columns Luis C. Ferreira (aka lcf) 21:03
REPOST[GENERAL] Quoting for a Select Into - Please Help A E 22:47

Jan. 15, 2004

Thread Author Time
Atomic query and update of sequence generators Jeffrey Tenny 00:51
Re: REPOST[GENERAL] Quoting for a Select Into - Please Help Stuart Barbee 03:17
Re: Atomic query and update of sequence generators Tom Lane 03:30
Re: Atomic query and update of sequence generators Greg Sabino Mullane 12:47
Re: Rule won't let me NOTIFY, no matter how hard I try Luis C. Ferreira 18:34
Problem with plpgsql function Chris Bowlby 18:39
Re: Problem with plpgsql function Joe Conway 18:47
Re: Problem with plpgsql function Chris Bowlby 19:06
Trigger to identify which column(s) updated Jack Kerkhof 21:15

Jan. 16, 2004

Thread Author Time
Initially Deffered - FK denis 04:32
Initially Deffered - FK Denis 04:34
Re: Initially Deffered - FK Stephan Szabo 05:18
Re: Initially Deffered - FK denis 05:31
Problem with LEFT JOIN Thomas Wegner 09:39
Re: Email function using c instead of tclu Christoph Haller 10:01
sql query with join and parameter in postgresql function Philippe Lang 11:30
Re: problem with function trigger Christoph Haller 11:34
Re: sql query with join and parameter in postgresql function Michael Glaesemann 11:44
Re: sql query with join and parameter in postgresql function Philippe Lang 13:03
Re: Is it possible in PostgreSQL? [email protected] 18:10
simple tree in postgress Liza 18:44

Jan. 17, 2004

Thread Author Time
Left joins with multiple tables Colin Fox 02:30
count(*) from cursor 📎 Yuri Gordienko 07:58

Jan. 18, 2004

Thread Author Time
Re: Is it possible in PostgreSQL? Chris Travers 13:02
Re: Left joins with multiple tables Richard Poole 21:57
Re: Trigger to identify which column(s) updated Vishal Kashyap @ [Sai Hertz And Control Systems] 22:29

Jan. 19, 2004

Thread Author Time
Execute permissions for stored functions Paul Hart 02:58
Re: Problem with LEFT JOIN Tom Lane 04:10
How can I get the last element out of GROUP BY sets? Robert Creager 04:28
Re: help with limiting query results Tom Lane 04:54
Re: Left joins with multiple tables Denis 04:58
Re: Execute permissions for stored functions Tom Lane 05:40
Re: How can I get the last element out of GROUP BY sets? Tom Lane 05:44
Re: DROP TRIGGER Tom Lane 06:20
Re: Initially Deffered - FK Stephan Szabo 10:33
Re: How can I get the last element out of GROUP BY sets? Christoph Haller 11:12
name of a column returned from a table function Iain 11:35
Re: Initially Deffered - FK Denis 12:11
Re: name of a column returned from a table function Tom Lane 15:07
Re: How can I get the last element out of GROUP BY sets? Robert Creager 17:38

Jan. 20, 2004

Thread Author Time
Re: Is it possible in PostgreSQL? Jim Johannsen 00:13
Re: Trigger to identify which column(s) updated V i s h a l Kashyap @ [Sai Hertz And Control Systems] 05:27
Fetching a single column from a record returning function Kumar 06:12
Database diagram Ganesan Kanavathy 06:38
Re: Database diagram Denis 07:01
Re: [SQL] Database diagram Roberto Mello 07:17
Re: Database diagram Gregory S. Williamson 07:35
comparing nulls Kenneth Gonsalves 13:43
Re: Database diagram Jodi Kanter 13:44
Re: comparing nulls Chris Bowlby 13:56
Re: comparing nulls D'Arcy J.M. Cain 14:06
Re: comparing nulls Kenneth Gonsalves 14:24
Re: [SQL] Database diagram Luis Sousa 14:30
Re: comparing nulls Reinoud van Leeuwen 14:33
Re: comparing nulls Chris Bowlby 15:04
Re: comparing nulls Guy Fraser 15:28
Re: comparing nulls Jeff Eckermann 15:53
Re: Fetching a single column from a record returning function Tom Lane 15:58
Re: comparing nulls Christopher Browne 16:06
Re: Fetching a single column from a record returning function Joe Conway 16:13

Jan. 21, 2004

Thread Author Time
Re: Fetching a single column from a record returning function Kumar 06:29
cygwin warnings in the log file Terence Kearns 08:09
time series data azwa 08:53
Re: time series data Tomasz Myrta 09:37
Re: time series data Tomasz Myrta 11:36
array_lower /array_prepend doubt Rajesh Kumar Mallah 14:00
Re: array_lower /array_prepend doubt Stephan Szabo 15:53
Re: array_lower /array_prepend doubt Tom Lane 17:14
Re: array_lower /array_prepend doubt Joe Conway 18: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 21 22 23 24 26 27 28 29 30 31