Search

Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-sql - August 2002

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

Prev | Next

2002-08-01

• Re: Case Statement Otto Hirr (00:10)
• Re: FW: Case Statement Stephan Szabo (00:23)
• Re: negative queries puzzle Christopher Kings-Lynne (01:51)
• Re: negative queries puzzle Ludwig Lim (01:51)
• Re: License Christopher Kings-Lynne (06:46)
• Re: Please Help me Christopher Kings-Lynne (06:49)
• How to disable rules?? friedrich nietzsche (09:28)
• Function problems, cache lookup failed Archibald Zimonyi (09:47)
• Random resultset retrieving -> performance bottleneck Cédric Dufour (11:35)
• Re: determine if a table exists Christoph Haller (12:42)
• Re: Function problems, cache lookup failed Tom Lane (14:01)
• Re: Please Help me Michelle Murrain (14:16)
• Re: Please Help me Chad Thompson (14:32)
• Re: Please Help me Michelle Murrain (14:48)
• Re: License Roberto Mello (14:51)
• Re: Please Help me Chad Thompson (14:56)
• Re: Please Help me Jochem van Dieten (15:16)
• Please Help me Waheed Rahuman (17:10)
• Fw: ! MaksimRomanov (17:32)
• Fw: Server Performance and Scalability Killers MaksimRomanov (17:35)
• License Waheed Rahuman (17:41)
• Re: negative queries puzzle Gunther Schadow (18:07)
• type conversion / casting doc Kevin Brannen (18:33)
• determine if a table exists Joseph Syjuco (22:08)

2002-08-02

• Re: Please Help me Christopher Kings-Lynne (01:13)
• Re: Returning PK of first insert for second insert use. Cédric Dufour (Cogito Ergo Soft) (12:59)
• Re: How to optimize SQL query ? Cédric Dufour (Cogito Ergo Soft) (13:17)
• Re: Group And Sort After Union Tom Lane (13:47)
• Re: How to optimize SQL query ? Tom Lane (13:49)
• Re: total newbie question: windows download (binary) Henshall, Stuart - WCP (14:01)
• Re: How to optimize SQL query ? Cédric Dufour (Cogito Ergo Soft) (14:06)
• Re: Random resultset retrieving -> performance bottleneck Stephan Szabo (14:12)
• possible bug in \df+ Rajesh Kumar Mallah. (14:17)
• Seeking advice regarding a design problem Wei Weng (16:16)
• Re: Seeking advice regarding a design problem Wei Weng (16:21)
• Ltree usage.. Rajesh Kumar Mallah. (16:33)
• Re: Ltree usage.. Oleg Bartunov (17:00)
• Aggregates and Indexes Adam Erickson (18:20)
• Re: Seeking advice regarding a design problem Stephan Szabo (18:24)
• Re: Seeking advice regarding a design problem Wei Weng (18:41)
• Re: Seeking advice regarding a design problem Stephan Szabo (19:35)
• Re: Aggregates and Indexes Josh Berkus (20:20)
• Re: Aggregates and Indexes Tom Lane (20:43)
• What about this? Wei Weng (21:40)
• Re: What about this? Josh Berkus (23:14)
• Add Primary Key to a Table Tom Haddon (23:16)
• Re: Add Primary Key to a Table Josh Berkus (23:19)
• Re: Add Primary Key to a Table Tom Haddon (23:20)
• Re: What about this? Tom Lane (23:52)

2002-08-03

• Re: Aggregates and Indexes Ron Johnson (00:27)
• Re: [SQL] Aggregates and Indexes Bruce Momjian (01:36)
• Re: Ltree usage.. Rajesh Kumar Mallah. (05:26)
• Re: Random resultset retrieving -> performance bottleneck Christopher Kings-Lynne (10:09)
• Re: What about this? Christopher Kings-Lynne (10:42)
• Re: Random resultset retrieving -> performance bottleneck Cédric Dufour (13:24)
• Re: [SQL] Aggregates and Indexes Josh Berkus (16:40)
• Triggers for inserting on VIEWS Marc SCHAEFER (18:04)
• Re: RES: The best book Joshua D. Drake (18:32)
• Re: Triggers for inserting on VIEWS Josh Berkus (18:33)
• Re: Triggers for inserting on VIEWS Tom Lane (18:34)
• STATISTICS? Josh Berkus (19:26)
• Re: STATISTICS? mallah (19:58)
• Re: Triggers for inserting on VIEWS Marc SCHAEFER (20:14)
• VACUUM not doing its job? Kristian Eide (20:53)
• Bug with dump/restore when using UNION and ORDER BY in views Kristian Eide (21:11)
• Re: VACUUM not doing its job? Ken Corey (22:14)
• Re: VACUUM not doing its job? Kristian Eide (22:40)
• Re: VACUUM not doing its job? Sander Steffann (22:59)
• Re: VACUUM not doing its job? Joe Conway (23:02)
• Re: VACUUM not doing its job? Kristian Eide (23:39)

2002-08-04

• Re: STATISTICS? Josh Berkus (00:31)
• Re: VACUUM not doing its job? Joe Conway (00:32)
• Re: [SQL] Aggregates and Indexes Bruce Momjian (00:43)
• Re: Bug with dump/restore when using UNION and ORDER BY in views Tom Lane (03:06)
• Re: Bug with dump/restore when using UNION and ORDER BY in views Christopher Kings-Lynne (05:24)
• Re: Bug with dump/restore when using UNION and ORDER BY in views Tom Lane (05:30)
• Re: Bug with dump/restore when using UNION and ORDER BY in views Bruce Momjian (05:54)
• Re: Bug with dump/restore when using UNION and ORDER BY in views Tom Lane (06:07)
• Re: VACUUM not doing its job? Jochem van Dieten (11:22)

2002-08-05

• Re: Group And Sort After Union Terry Yapt (09:55)
• Re: VACUUM not doing its job? Robert Treat (21:40)

2002-08-06

• Concatenate aggregate? Julian Scarfe (08:03)
• Re: Concatenate aggregate? Archibald Zimonyi (08:28)
• Re: Concatenate aggregate? Julian Scarfe (08:37)
• Table design question... Joerg Hessdoerfer (09:17)
• Re: Table design question... Joerg Hessdoerfer (10:35)
• Re: copy files to postgresql John Zhang (12:14)
• Multi table insert and passing sequence ids Norman Khine (12:55)
• Re: Table design question... Richard Huxton (12:59)
• Re: copy files to postgresql Jeff Eckermann (13:23)
• Re: copy files to postgresql Tom Lane (14:01)
• Re: Transitive Closure Bruno Wolff III (14:06)
• Re: Transitive Closure Dan Langille (14:59)
• problem fetching currval of sequence Charles Hauser (15:14)
• Re: Table design question... Joerg Hessdoerfer (15:24)
• Re: Transitive Closure Oleg Bartunov (15:28)
• SQL syntax frederic massot (15:29)
• Re: problem fetching currval of sequence Josh Berkus (15:45)
• Re: problem fetching currval of sequence Stephan Szabo (15:57)
• Re: problem fetching currval of sequence Tom Lane (16:16)
• Re: copy files to postgresql Jean-Luc Lachance (16:20)
• Re: problem fetching currval of sequence Tom Lane (16:25)
• Re: problem fetching currval of sequence Charles Hauser (16:43)
• Re: problem fetching currval of sequence Tom Lane (16:48)
• Re: SQL syntax Tod McQuillin (16:48)
• Re: Transitive Closure Bruno Wolff III (17:01)
• Re: SQL syntax Cedric Dufour (Cogito Ergo Soft) (17:10)
• Re: Transitive Closure Oleg Bartunov (17:34)
• Re: Multi table insert and passing sequence ids Richard Huxton (17:38)
• Re: SQL syntax Jean-Luc Lachance (17:38)
• Re: SQL syntax Jean-Luc Lachance (17:53)
• Re: problem fetching currval of sequence Josh Berkus (18:35)
• Re: problem fetching currval of sequence Tom Lane (20:18)
• Re: problem fetching currval of sequence Josh Berkus (20:37)
• Re: problem fetching currval of sequence Charles Hauser (20:53)
• Re: problem fetching currval of sequence Josh Berkus (21:26)
• control reaches end of trigger procedure without RETURN rramostalo (22:12)
• ALTER TABLE follow up Tom Haddon (22:41)

2002-08-07

• Re: ALTER TABLE follow up Christopher Kings-Lynne (02:02)
• Limit A Table To 1 Row cnliou (03:29)
• Re: SQL syntax Tom Lane (03:31)
• Re: Limit A Table To 1 Row Bruno Wolff III (03:42)
• Re: SQL syntax Bruno Wolff III (03:47)
• Re: Limit A Table To 1 Row Josh Berkus (03:52)
• looking to speed up SELECT ... LEFT JOIN query Trey Ackerman (05:03)
• Effective usage without unique key -- suggestion Bhuvan A (08:27)
• Re: Limit A Table To 1 Row Richard Huxton (08:30)
• Views/queries and optimal indexes usage (cf. planner) Cédric Dufour (11:49)
• Re: control reaches end of trigger procedure without RETURN Jeff Eckermann (13:35)
• Table is modified? Yuri Gordienko (14:29)
• running psql in a cron job Wei Weng (14:51)
• Re: running psql in a cron job Wei Weng (15:01)
• Re: running psql in a cron job Wei Weng (17:07)
• manipulating the POINT data type Floyd Shackelford (17:16)
• Re: running psql in a cron job Ignacio Coloma (18:02)
• Re: ALTER TABLE follow up Tom Haddon (18:30)
• getting oid of an INSERT automatically John Brothers (18:39)
• Re: running psql in a cron job Ross J. Reedstrom (18:54)
• Altering live databases Gregory Brauer (21:45)

2002-08-08

• Re: ALTER TABLE follow up Christopher Kings-Lynne (02:32)
• Re: Altering live databases Christopher Kings-Lynne (02:38)
• Re: Altering live databases Gregory Brauer (02:52)
• Re: Altering live databases Christopher Kings-Lynne (02:59)
• Re: Effective usage without unique key -- suggestion Richard Huxton (09:20)
• to_char and '=' weirdness Frank Joerdens (11:33)
• Re: to_char and '=' weirdness Ludwig Lim (11:48)
• Re: to_char and '=' weirdness Karel Zak (12:11)
• Re: to_char and '=' weirdness Frank Joerdens (12:46)
• Re: to_char and '=' weirdness Frank Joerdens (13:04)
• Re: getting oid of an INSERT automatically Oliver Elphick (13:28)
• Re: manipulating the POINT data type Tom Lane (13:35)
• Re: looking to speed up SELECT ... LEFT JOIN query Richard Huxton (14:24)
• Re: getting oid of an INSERT automatically John Brothers (19:18)
• Table Sorting and Limit Question Dawn Hollingsworth (20:10)

2002-08-09

• Re: Table Sorting and Limit Question Ludwig Lim (01:42)
• expressions operating on arrays h012 (04:38)
• Re: expressions operating on arrays Achilleus Mantzios (06:17)
• Re: expressions operating on arrays h012 (07:12)
• Re: expressions operating on arrays Oleg Bartunov (07:30)
• Re: expressions operating on arrays Tom Lane (13:53)
• Re: Table Sorting and Limit Question Dawn Hollingsworth (13:55)
• Re: expressions operating on arrays Oleg Bartunov (14:57)
• Re: expressions operating on arrays h012 (20:49)
• How to update record in a specified order Jean-Luc Lachance (21:21)
• Re: SQL syntax Jean-Luc Lachance (21:36)
• retrieving all rows from a "tree" in one select - how ? h012 (21:36)
• Re: How to update record in a specified order Josh Berkus (21:37)
• Re: How to update record in a specified order Jean-Luc Lachance (21:59)
• Re: How to update record in a specified order Dan Langille (22:02)
• Re: retrieving all rows from a "tree" in one select - how ? Adam Erickson (22:04)
• Re: How to update record in a specified order Josh Berkus (22:12)
• Re: retrieving all rows from a "tree" in one select - how ? Josh Berkus (22:15)
• Re: retrieving all rows from a "tree" in one select - how ? Oleg Bartunov (23:37)

2002-08-10

• getting ILIKE or ~* to use indexes.... Rajesh Kumar Mallah. (06:13)
• Re: getting ILIKE or ~* to use indexes.... Josh Berkus (18:10)
• update on a large table Aaron Held (21:01)
• Re: getting ILIKE or ~* to use indexes.... mallah (21:14)

2002-08-11

• slowing down too fast - why ? h012 (04:22)
• Re: slowing down too fast - why ? h012 (04:36)
• Re: slowing down too fast - why ? Tom Lane (14:43)
• Re: slowing down too fast - why ? h012 (18:10)
• Re: slowing down too fast - why ? Marc Spitzer (19:30)

2002-08-12

• Need Help for select Andre Schubert (13:06)
• Calling stored procedures in table constraint checks Florian Weimer (14:13)
• Re: Calling stored procedures in table constraint checks Tom Lane (15:11)
• Re: Need Help for select Ludwig Lim (15:11)
• Is this valid? Wei Weng (23:21)

2002-08-13

• Re: Is this valid? Robert Treat (00:10)
• Problems using UPDATE and SUM Brian Cawthon (00:31)
• Conversion Lonh SENG (03:14)
• Re: Conversion Christopher Kings-Lynne (03:32)
• 答复: [SQL] Is this valid? Wei Weng (03:52)
• Re: Is this valid? Weiping He (03:58)
• Function error Sugandha Shah (06:06)
• Re: Function error Janning Vygen (07:01)
• Re: Conversion Alexander M. Pravking (07:03)
• Re: Conversion Christopher Kings-Lynne (07:14)
• Re: Function error Sugandha Shah (07:28)
• Re: Function error Christopher Kings-Lynne (07:31)
• Re: Conversion Alexander M. Pravking (07:37)

Prev | Next