pgsql-sql - September 2002

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

Sept. 2, 2002

Thread	Author	Time
Re: [SQL] Retrieving the new "nextval" for primary keys....	GB Clark	19:50
Re: Retrieving the new nextval...	GB Clark	19:57

Sept. 3, 2002

Thread	Author	Time
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	[email protected]	16:19
Update Help	[email protected]	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

Sept. 4, 2002

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

Sept. 5, 2002

Thread	Author	Time
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

Sept. 6, 2002

Thread	Author	Time
Hardware performance for large updates	Josh Berkus	00:41
Re: Hardware performance for large updates	Joe Conway	04:33
Slow Multi-joins performance		10:59
Re: Hardware performance for large updates	Josh Berkus	16:10

Sept. 7, 2002

Thread	Author	Time
Re: Hardware performance for large updates	Joe Conway	03:57

Sept. 9, 2002

Thread	Author	Time
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

Sept. 10, 2002

Thread	Author	Time
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

Sept. 11, 2002

Thread	Author	Time
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

Sept. 12, 2002

Thread	Author	Time
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

Sept. 13, 2002

Thread	Author	Time
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

Sept. 14, 2002

Thread	Author	Time
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

Sept. 15, 2002

Thread	Author	Time
Re: Timestamp Fractions Problem	Florian Mader	09:00
Re: Timestamp Fractions Problem	Tom Lane	14:51
Re: Slow Multi-joins performance [DEVELOPERS attn please]		21:34

Sept. 16, 2002

Thread	Author	Time
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

Sept. 17, 2002

Thread	Author	Time
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

Browse Archives

Prev | Next