Skip site navigation (1)
Skip section navigation (2)
pgsql-sql 2002-08 Chronological Index (1/3)
Last updated: Wed Jan 18 04:35:37 2012
433 messages
30 August 2002
Re: query problem Jean-Luc Lachance (19:57)
Large number of lookups Jeff Boes (19:39)
Re: query problem Josh Berkus (18:48)
Re: How to Select with more than one AND in a Where SQL Clause? Josh Berkus (17:02)
query problem Marco Muratori (16:41)
Re: Why must the function that a trigger calls return "opaque" ??? Josh Berkus (16:08)
Re: RFC822 Checker Bruno Wolff III (14:19)
RFC822 Checker Matthew Price (14:08)
Re: record count Bhuvan A (05:32)
29 August 2002
Re: record count Bruno Wolff III (18:59)
record count Marie G. Tuite (18:35)
Re: union optimization in views Josh Berkus (17:52)
the optimizer and exists Thomas F. O'Connell (16:13)
Why must the function that a trigger calls return "opaque" ??? Greg Patnude (15:21)
Re: signed/unsigned integers Bruno Wolff III (13:34)
Re: SELECT ... WHERE ... NOT IN (SELECT ...); Yon Den Baguse Ngarso (06:14)
union optimization in views JOE (04:46)
trigger viewing Kemin Zhou (00:18)
28 August 2002
Re: select question Wei Weng (20:21)
select question george young (20:12)
Re: Retrieving the new nextval... Jeff Eckermann (18:33)
Re: Case Statement Stephan Szabo (18:25)
Case Statement Tom Haddon (17:44)
Re: UPDATE & LIMIT together? Bruce Momjian (17:01)
nextval... friedrich nietzsche (16:51)
Re: Retrieving the new "nextval" for primary keys.... friedrich nietzsche (16:36)
Re: Retrieving the new nextval... friedrich nietzsche (16:32)
Re: Retrieving the new "nextval" for primary keys.... Kevin Brannen (16:09)
UPDATE & LIMIT together? tp (16:08)
Re: Problems with version 7.1, could they be fixed in 7.2? Ligia Pimentel (15:43)
Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Vivek Khera (15:28)
Re: SERIAL parameters Bruce Momjian (15:09)
Re: Problems with version 7.1, could they be fixed in 7.2? Stephan Szabo (15:04)
Re: triggers and plpgsql question Mathieu Arnold (14:23)
Can I use "UPDATE" sql statement in trigger before or after update ? Ivan Jordanov (11:40)
Re: signed/unsigned integers Christopher Kings-Lynne (08:15)
signed/unsigned integers Roger Mathis (08:09)
Re: "reverse()" on strings h012 (08:09)
VIRUS IN MAIL FOR YOU FROM <jdickso5(at)utk(dot)edu > postmaster (08:03)
unsubscribe Gaetano Mendola (07:30)
Re: triggers and plpgsql question Mathieu Arnold (06:42)
Re: Calculation Error on Epoch? Tom Lane (04:14)
SERIAL parameters Arnold Putong (04:12)
Re: Calculation Error on Epoch? Christopher Kings-Lynne (03:54)
Calculation Error on Epoch? Josh Berkus (03:30)
Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Christopher Kings-Lynne (01:45)
27 August 2002
Re: Problems with version 7.1, could they be fixed in 7.2? Ligia Pimentel (23:16)
Re: triggers and plpgsql question Josh Berkus (22:38)
Re: IDENT authentication problem Tom Lane (22:14)
Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Larry Rosenman (22:12)
Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Tom Lane (22:07)
Re: Problems with version 7.1, could they be fixed in 7.2? mark carew (21:33)
IDENT authentication problem Wei Weng (21:26)
Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Bruce Momjian (20:59)
Re: decode('hallo',???) Bruce Momjian (20:29)
decode('hallo',???) Fritz Lehmann-Grube (20:23)
triggers and plpgsql question Mathieu Arnold (16:18)
Year of the week : How to ? Emmanuel Guyot (09:52)
Help needed Mowat, Paul (09:21)
Problems with version 7.1, could they be fixed in 7.2? Ligia Pimentel (01:00)
26 August 2002
Re: "reverse()" on strings Josh Berkus (21:10)
Re: "reverse()" on strings Jeff Boes (20:56)
"reverse()" on strings h012 (20:13)
Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Bruce Momjian (19:54)
Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Magnus Enbom (19:50)
Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Tom Lane (19:01)
Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Bruce Momjian (18:53)
Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Jan Wieck (18:42)
Re: weird situation, BUG or I'm not doing it right Jiaqing Wang (12:46)
Re: Separating data sets in a table Oliver Elphick (10:31)
Re: Separating data sets in a table Andreas Tille (09:46)
unsubscribe Gaetano Mendola (09:29)
Re: Separating data sets in a table Oliver Elphick (08:36)
ANNOUNCE: Bricolage 1.3.3 David Wheeler (07:06)
Re: Separating data sets in a table Andreas Tille (06:26)
Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Bruce Momjian (00:31)
25 August 2002
Re: Separating data sets in a table Mark Stosberg (21:35)
Re: Separating data sets in a table Andreas Tille (20:12)
Re: weird situation, BUG or I'm not doing it right Tom Lane (15:20)
Re: left join query does not perform well Tom Lane (15:12)
Re: weird situation, BUG or I'm not doing it right Michael Paesold (12:48)
left join query does not perform well Manuel Sugawara (05:22)
Re: weird situation, BUG or I'm not doing it right Ross J. Reedstrom (04:27)
weird situation, BUG or I'm not doing it right Jiaqing Wang (03:45)
24 August 2002
Re: Separating data sets in a table OU (21:11)
Re: SELECT ... WHERE ... NOT IN (SELECT ...); OU (18:42)
Retrieving the new "nextval" for primary keys.... Greg Patnude (01:01)
23 August 2002
Re: question on UPDATE TABLE Stephan Szabo (19:51)
question on UPDATE TABLE Wei Weng (19:16)
Re: [GENERAL] 'on delete' rule: bug or feature... Dmitry Tkach (18:05)
Re: [GENERAL] 'on delete' rule: bug or feature... Jan Wieck (17:57)
Re: speeding up \d commands. Bruce Momjian (17:21)
'on delete' rule: bug or feature... Dmitry Tkach (17:16)
Re: speeding up \d commands. Rajesh Kumar Mallah. (16:01)
Re: SELECT ... WHERE ... NOT IN (SELECT ...); Ross J. Reedstrom (15:01)
Re: SELECT ... WHERE ... NOT IN (SELECT ...); Tom Lane (13:25)
Updatable View (Was: Separating data sets in a table) Andreas Tille (10:01)
Re: SELECT ... WHERE ... NOT IN (SELECT ...); Richard Huxton (09:52)
signed/unsigned integers Roger Mathis (09:12)
Re: SELECT ... WHERE ... NOT IN (SELECT ...); Yon Den Baguse Ngarso (08:28)
Re: SELECT ... WHERE ... NOT IN (SELECT ...); Yon Den Baguse Ngarso (07:55)
Re: speeding up \d commands. Björn Lundin (06:53)
Re: SELECT ... WHERE ... NOT IN (SELECT ...); Tom Lane (05:28)
speeding up \d commands. Rajesh Kumar Mallah. (04:37)
SELECT ... WHERE ... NOT IN (SELECT ...); Yon Den Baguse Ngarso (03:40)
22 August 2002
Re: BITMAP INDEXES... imtiaz sm (16:26)
Re: bytea etc. Joe Conway (15:33)
Re: BITMAP INDEXES... Bruce Momjian (14:30)
Re: Problem with timestamp field/time function.. (upgrading Stephan Szabo (14:28)
bytea etc. Andrew Klimov (13:34)
bytea ,etc. Klimov Andrew (13:31)
Re: Problem with timestamp field/time function.. (upgrading Lucas Brasilino (11:49)
Separating data sets in a table Andreas Tille (09:47)
sql statement to give functionality of \d tablename? Philip Rudling (09:05)
BITMAP INDEXES... Rajesh Kumar Mallah. (08:19)
Re: [ADMIN] How to execute my trigger when update certain columns Oliver Elphick (06:10)
Re: Event recurrence - in database or in application code ???? Mark Stosberg (02:20)
21 August 2002
Re: Trigger/Function problem Bhuvan A (09:14)
Re: Trigger/Function problem Ludwig Lim (09:11)
Trigger/Function problem Andreas Johansson (07:35)
Re: Event recurrence - in database or in application code ???? Mark Stosberg (02:15)
20 August 2002
Re: functions and triggers Martin Marques (21:37)
Re: functions and triggers Stephan Szabo (21:16)
functions and triggers Martin Marques (20:29)
Re: Problem with timestamp field/time function.. (upgrading Stephan Szabo (17:03)
Problem with timestamp field/time function.. (upgrading from 7.0 to 7.2.1) Lucas Brasilino (16:39)
Re: sql subqueries problem Mathieu Arnold (15:36)
Re: bulk imports with sequence Tom Lane (14:54)
Re: sql subqueries problem Stephan Szabo (14:43)
Event recurrence - in database or in application code ???? Darrin Domoney (13:16)
Re: bulk imports with sequence Dan Langille (12:01)
bulk imports with sequence Aaron Held (11:55)
How to prevent recursion Falk Nisius (08:07)
Re: sql subqueries problem Mathieu Arnold (06:15)
Re: how to refer to tables in another database( or schema as Stephan Szabo (02:56)
Re: how to refer to tables in another database( or schema as oracle refers to) Graeme Merrall (02:48)
Re: Modify column type Christopher Kings-Lynne (01:56)
Re: how to refer to tables in another database( or schema as oracle refers to) Christopher Kings-Lynne (01:35)
19 August 2002
Re: [ADMIN] Urgent - SQL Unique constraint error (long) Darrin Domoney (19:29)
Re: Urgent - SQL Unique constraint error (long) Stephan Szabo (18:56)
Re: [NOVICE] Urgent - SQL Unique constraint error (long) Darrin Domoney (18:29)
Re: Urgent - SQL Unique constraint error (long) Darrin Domoney (18:25)
Re: Urgent - SQL Unique constraint error (long) Stephan Szabo (17:41)
Urgent - SQL Unique constraint error (long) Darrin Domoney (17:35)
Re: need assistance with multi-row matching expression Mark Stosberg (17:13)
Re: need assistance with multi-row matching expression Nick Fankhauser (16:56)
Re: sql subqueries problem Stephan Szabo (16:45)
Modify column type Scott David Walter (16:45)
sql subqueries problem Mathieu Arnold (16:17)
Re: recursive function returning "setof" Christopher Kings-Lynne (15:53)
Re: recursive function returning "setof" Fritz Lehmann-Grube (15:21)
need assistance with multi-row matching expression Mark Stosberg (15:21)
Re: recursive function returning "setof" Christopher Kings-Lynne (14:52)
recursive function returning "setof" Fritz Lehmann-Grube (13:18)
Re: performance comparison: DISTINCT and GROUP BY Christopher Kings-Lynne (12:26)
performance comparison: DISTINCT and GROUP BY Devrim GUNDUZ (11:22)
Re: Ordering with GROUPs Julian Scarfe (08:01)
Re: Few Queries Sugandha Shah (07:27)
Re: Need Help for select Andre Schubert (05:31)
18 August 2002
Re: Unexplained SQL behavior Tom Lane (18:25)
Re: Ordering with GROUPs Bruno Wolff III (12:38)
Ordering with GROUPs Julian Scarfe (11:49)
Re: Unexplained SQL behavior Tom Lane (01:55)
Unexplained SQL behavior JOE (01:07)
17 August 2002