Search

Peripheral Links

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

pgsql-sql - September 2002

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

Prev | Next

2002-09-02

• Re: [SQL] Retrieving the new "nextval" for primary keys.... GB Clark (19:50)
• Re: Retrieving the new nextval... GB Clark (19:57)

2002-09-03

• Re: union optimization in views Stephan Szabo (04:06)
• Re: UPDATE & LIMIT together? tp (08:37)
• Re: RFC822 Checker Hubert depesz Lubaczewski (08:41)
• convert sum (interval) to seconds Doppelganger (10:45)
• Re: convert sum (interval) to seconds Oliver Elphick (11:11)
• tree structures in sql - my point of view (with request of comment from joe celko) Hubert depesz Lubaczewski (13:22)
• Re: convert sum (interval) to seconds Tom Lane (13:37)
• Re: Why must the function that a trigger calls return Darren Ferguson (14:56)
• Update help Yudieg@hotmail.com (16:19)
• Update Help Yudie@axiontech.com (16:38)
• Re: Update Help Oliver Elphick (18:01)
• Outer Join with For Update alexandre :: aldeia digital (18:05)
• Re: tree structures in sql - my point of view (with request of comment from joe celko) Josh Berkus (18:17)
• Re: UPDATE & LIMIT together? Bruce Momjian (18:39)
• Re: tree structures in sql - my point of view (with request Oleg Bartunov (18:42)
• Re: Update Help Peter Eisentraut (18:55)
• Re: Outer Join with For Update Tom Lane (21:31)
• Re: tree structures in sql - my point of view (with request mallah (21:59)
• Re: tree structures in sql - my point of view (with request Bruce Momjian (22:07)

2002-09-04

• Re: tree structures in sql - my point of view (with request of comment from joe celko) knut.suebert (17:46)

2002-09-05

• Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Bruce Momjian (05:27)
• fumbling for join syntax Daniel Kelley (14:29)
• Re: fumbling for join syntax Josh Berkus (15:55)
• new calculated column andres javier garcia garcia (16:53)
• new calculated column andres javier garcia garcia (16:58)
• Re: Update help Ligia Pimentel (17:29)
• Re: new calculated column mallah (18:49)
• Character translation? Linn Kubler (22:15)

2002-09-06

• Hardware performance for large updates Josh Berkus (00:41)
• Re: Hardware performance for large updates Joe Conway (04:33)
• Slow Multi-joins performance jlparkinson (10:59)
• Re: Hardware performance for large updates Josh Berkus (16:10)

2002-09-07

• Re: Hardware performance for large updates Joe Conway (03:57)

2002-09-09

• Efficiency Question Colin Fox (00:13)
• the best way to get the topest 3 record in every group jack (00:21)
• Re: the best way to get the topest 3 record in every group dima (06:34)
• Cross tables Like% Jason Davis (07:20)
• Re: Character translation? Troy (07:47)
• Re: the best way to get the topest 3 record in every group jack (08:08)
• Database joins Jay (08:58)
• Re: the best way to get the topest 3 record in every group Viacheslav N Tararin (09:35)
• Re: the best way to get the topest 3 record in every group Viacheslav N Tararin (11:48)
• Re: the best way to get the topest 3 record in every group Viacheslav N Tararin (12:23)
• Re: Efficiency Question Bruno Wolff III (13:57)
• Re: new calculated column Viacheslav N Tararin (14:01)
• Re: Cross tables Like% Viacheslav N Tararin (14:05)
• Re: Character translation? Richard Huxton (14:50)
• Re: Slow Multi-joins performance [DEVELOPERS attn please] Richard Huxton (15:24)
• Re: Character translation? Stephan Szabo (15:37)
• Re: Database joins Stephan Szabo (15:44)
• Re: the best way to get the topest 3 record in every group Masaru Sugawara (16:23)
• Re: Slow Multi-joins performance [DEVELOPERS attn please] Ross J. Reedstrom (16:37)
• Changing Column Type Peter Atkins (16:49)
• Displaying current queries on the database? Sloan Bowman (17:34)
• Re: Displaying current queries on the database? mallah (17:52)
• stored procedures: sybase -> postgreSQL ? Charles Hauser (18:15)
• Re: Slow Multi-joins performance [DEVELOPERS attn please] Tom Lane (20:26)
• Re: stored procedures: sybase -> postgreSQL ? Reinoud van Leeuwen (21:02)
• How the R-Tree index works?. Andres Sommerhoff (21:51)

2002-09-10

• Transaction Newbie Michelle Murrain (02:37)
• Re: Transaction Newbie Christopher Kings-Lynne (02:52)
• Re: How the R-Tree index works?. Markus Gieppner (03:34)
• pgsql-performance mailing list / newsgroup created Marc G. Fournier (03:44)
• Help Bc. Šimko Juraj (08:29)
• POSIX-style regular expressions Goran Buzic (09:32)
• Re: POSIX-style regular expressions Josh Jore (13:35)
• Re: POSIX-style regular expressions Goran Buzic (13:51)
• Re: stored procedures: sybase -> postgreSQL ? Ross J. Reedstrom (14:49)
• Re: POSIX-style regular expressions Stephan Szabo (15:04)
• Re: POSIX-style regular expressions Ross J. Reedstrom (15:13)
• Re: POSIX-style regular expressions Tom Lane (15:15)
• Rules and Triggers Michael Paesold (18:52)
• Re: Rules and Triggers Adam Erickson (19:24)
• Re: Rules and Triggers Michael Paesold (19:45)
• Re: Changing Column Type Kevin Brannen (19:51)
• Year and month comparison Del Mistro, Enzo (20:16)
• Do the datatypes have set id/oid that are constant? Mark Worsdall (21:50)
• Re: Transaction Newbie Lee Harr (23:27)
• Re: Rules and Triggers Ross J. Reedstrom (23:28)

2002-09-11

• R-Tree, GiST or B-Tree? I will need it? Andres Sommerhoff (03:43)
• Re: Rules and Triggers Michael Paesold (07:28)
• Re: POSIX-style regular expressions Goran Buzic (12:21)
• writing a function to mimic mysql last_insert_id Beth Gatewood (17:23)
• Re: writing a function to mimic mysql last_insert_id Josh Berkus (17:30)
• Re: writing a function to mimic mysql last_insert_id Ross J. Reedstrom (17:32)
• Re: writing a function to mimic mysql last_insert_id Beth Gatewood (17:43)
• Re: writing a function to mimic mysql last_insert_id Josh Berkus (17:53)
• reset sequence Ricardo Javier Aranibar León (20:02)

2002-09-12

• Re: writing a function to mimic mysql last_insert_id Christopher Kings-Lynne (02:05)
• Re: writing a function to mimic mysql last_insert_id Chris (02:21)
• Re: writing a function to mimic mysql last_insert_id Beth Gatewood (02:37)
• Re: writing a function to mimic mysql last_insert_id Joe Conway (03:07)
• htdig & postgresql Rudi Starcevic (05:41)
• how to cast this ? juerg.rietmann (09:22)
• Re: how to cast this ? Oliver Elphick (09:45)
• still sorting and casting problems juerg.rietmann (10:01)
• Re: reset sequence Ludwig Lim (10:12)
• Re: reset sequence Michael Paesold (10:28)
• Re: Rules and Triggers: another question Michael Paesold (12:52)
• Select the max on a field Gaetano Mendola (13:09)
• Re: Select the max on a field Gaetano Mendola (13:15)
• Re: still sorting and casting problems Stephan Szabo (13:54)
• Re: still sorting and casting problems Jeff Eckermann (13:57)
• Re: Select the max on a field Stephan Szabo (14:02)
• Re: Select the max on a field Jeff Eckermann (14:03)
• Performance inside and outside view ( WAS Re: Select the max on a field ) Gaetano Mendola (14:31)
• Re: Performance inside and outside view ( WAS Re: Select the max on a field ) Tom Lane (14:50)
• Re: Performance inside and outside view ( WAS Re: Select the Stephan Szabo (15:22)
• Re: Performance inside and outside view ( WAS Re: Select the max on a field ) Gaetano Mendola (15:53)
• Table alias in DELETE statements Hanno Wiegard (15:57)
• Re: Performance inside and outside view ( WAS Re: Select the Stephan Szabo (16:05)
• Latitude / Longitude Tim Perdue (17:44)
• Re: [SQL] Latitude / Longitude Larry Rosenman (17:49)
• Returning a reference to a cursor from a function david williams (18:12)
• Re: Performance inside and outside view ( WAS Re: Select the Tom Lane (18:57)
• LIMIT within UNION? Andrew Perrin (19:11)
• Re: [SQL] Latitude / Longitude Jeff Hoffmann (19:19)
• Re: LIMIT within UNION? Tom Lane (19:34)
• Re: LIMIT within UNION? Roland Roberts (19:35)
• Re: LIMIT within UNION? Andrew Perrin (19:40)
• Re: LIMIT within UNION? Andrew Perrin (19:41)
• Re: [SQL] Latitude / Longitude Bruno Wolff III (19:46)
• Re: [SQL] Latitude / Longitude Tim Perdue (19:49)
• Re: LIMIT within UNION? Stephan Szabo (19:52)
• Re: LIMIT within UNION? Andrew Perrin (20:03)
• Re: LIMIT within UNION? Tom Lane (20:18)
• Re: LIMIT within UNION? Josh Berkus (20:20)
• Re: Latitude / Longitude Joe Conway (20:54)
• Re: [SQL] Latitude / Longitude James Orr (22:10)

2002-09-13

• Re: DISTINCT Christopher Kings-Lynne (02:30)
• DISTINCT Rudi Starcevic (02:31)
• Re: DISTINCT Rudi Starcevic (02:44)
• Re: DISTINCT ON Christopher Kings-Lynne (02:48)
• DISTINCT ON Rudi Starcevic (02:49)
• How can unique columns being case-insensitive be accomplished? Jrg (09:07)
• sql group by statement Albrecht Berger (10:29)
• Re: sql group by statement dima (10:33)
• Re: sql group by statement Albrecht Berger (10:39)
• Assignments in PL/pgSQL Michael Paesold (10:43)
• Table alias in DELETE statements Hanno Wiegard (12:10)
• Re: sql group by statement Manfred Koizar (12:16)
• Re: Table alias in DELETE statements Manfred Koizar (12:46)
• Re: DISTINCT ON Chad Thompson (14:35)
• Timestamp Fractions Problem Florian Mader (14:38)
• Timestamp Fractions Problem Florian Mader (14:49)
• Re: [SQL] Latitude / Longitude Jan Wieck (15:19)
• Re: sql group by statement Jean-Luc Lachance (15:39)
• Re: LIMIT within UNION? Andrew Perrin (15:45)
• Re: Assignments in PL/pgSQL Josh Berkus (17:51)
• Re: Assignments in PL/pgSQL Jan Wieck (18:04)
• Re: Assignments in PL/pgSQL Joe Conway (18:04)
• Re: Assignments in PL/pgSQL Josh Berkus (18:10)
• Want to test beta, but ... Josh Berkus (18:31)
• Re: Want to test beta, but ... Joe Conway (18:59)
• Re: Want to test beta, but ... Josh Berkus (19:04)
• How to select and result row number?? Yudie (19:17)
• does table names have a format and size jaya prakash (23:04)
• "Inverting" a table, OLAP-style pacquet (23:18)

2002-09-14

• Re: Timestamp Fractions Problem Tom Lane (03:35)
• Re: Table alias in DELETE statements Christopher Kings-Lynne (06:07)
• Re: sql group by statement Tom Lane (15:03)
• cross tab (pivtor table) sql shahbaz (22:53)

2002-09-15

• Re: Timestamp Fractions Problem Florian Mader (09:00)
• Re: Timestamp Fractions Problem Tom Lane (14:51)
• Re: Slow Multi-joins performance [DEVELOPERS attn please] jlparkinson (21:34)

2002-09-16

• Re: Table alias in DELETE statements Bruce Momjian (04:03)
• Rules and Triggers: another question Jerome Chochon (06:57)
• Re: Timestamp Fractions Problem Florian Mader (08:29)
• Re: Want to test beta, but ... Richard Huxton (08:31)
• Re: Want to test beta, but ... Christopher Kings-Lynne (08:53)
• Re: How can unique columns being case-insensitive be accomplished? Tom Lane (13:38)
• Re: does table names have a format and size Michael Paesold (13:46)
• Re: cross tab (pivtor table) sql Michael Paesold (13:58)
• Formatting zeroes Ludwig Lim (14:41)
• Dublicates pairs in a table. Ries van Twisk (14:51)
• Re: "Inverting" a table, OLAP-style Tom Lane (14:55)
• Re: does table names have a format and size Stephan Szabo (15:03)
• Re: Dublicates pairs in a table. Richard Huxton (15:08)
• Re: How can unique columns being case-insensitive be accomplished? Ross J. Reedstrom (15:09)
• Re: Formatting zeroes Josh Berkus (15:52)
• Re: POSIX-style regular expressions Bruce Momjian (15:55)
• Re: Do the datatypes have set id/oid that are constant? Bruce Momjian (17:02)
• please delete my email address from your list Ngan Duong (17:04)
• Re: Table alias in DELETE statements Bruce Momjian (19:50)

2002-09-17

• Re: does table names have a format and size Christopher Kings-Lynne (01:28)
• Re: How to select and result row number?? Bruce Momjian (03:12)
• Re: Formatting zeroes Bruce Momjian (05:33)
• Re: Dublicates pairs in a table. Ries van Twisk (06:36)
• Re: Dublicates pairs in a table. Richard Huxton (10:07)
• Re: How to select and result row number?? Roland Roberts (14:14)
• Join Question Robert J. Sanford, Jr. (14:17)
• Re: How to select and result row number?? Ross J. Reedstrom (14:46)
• Re: How to select and result row number?? Tom Lane (15:05)
• Re: Returning a reference to a cursor from a function Richard Huxton (15:29)
• cannot delete bug Kemin Zhou (21:35)
• Re: How to select and result row number?? Bruce Momjian (21:44)
• Re: How to select and result row number?? Tom Lane (22:13)
• Re: How to select and result row number?? Bruce Momjian (22:21)

Prev | Next