pgsql-sql since 2002-09-09 00:00

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. 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
Re: cannot delete bug	Tom Lane	22:31
Re: How to select and result row number??	Tom Lane	22:43

Sept. 18, 2002

Thread	Author	Time
Re: Returning a reference to a cursor from a function	Richard Huxton	10:21
Re: Returning a reference to a cursor from a function	david williams	11:23
Creating a field that uses totals other fields?	Sloan Bowman	16:26
TSQL2 (Temporal SQL) support for Postgres	Ewan Grantham	18:45
Query to evaluate space used	Jeff Boes	19:56
Performance w/ multiple WHERE clauses	Aaron Held	21:17
Re: Performance w/ multiple WHERE clauses	Stephan Szabo	21:58

Sept. 19, 2002

Thread	Author	Time
Re: Index usage on date feild , differences in '>' and '>='	Stephan Szabo	06:37
Index usage on date feild , differences in '>' and '>=' and between	Rajesh Kumar Mallah.	06:38
Re: Index usage on date feild , differences in '>' and '>=' and between	Rajesh Kumar Mallah.	07:06
Re: Stripping white-space in SELECT statments	dima	11:08
Stripping white-space in SELECT statments	Thorbjörn Eriksson	11:20
Re: Stripping white-space in SELECT statments	Thorbjörn Eriksson	11:41
How To Get Bytea Data Instead Of Its Oid	CN LIOU	14:11
Re: Index usage on date feild , differences in '>' and '>='	Stephan Szabo	14:28
Re: Stripping white-space in SELECT statments	Tom Lane	14:31
Re: Stripping white-space in SELECT statments	Stephan Szabo	14:34
help w/ constructing a SELECT	Charles Hauser	14:41
Re: Stripping white-space in SELECT statments	Mathieu Arnold	14:41
Table Copy.	PostgreSQL Server	15:56
Re: How To Get Bytea Data Instead Of Its Oid	Tom Lane	16:46
Re: Stripping white-space in SELECT statments	Andreas Joseph Krogh	17:42
Re: Table Copy.	Michael Paesold	18:10
problem with query	Ricardo Javier Aranibar León	19:11
problem with query	Ricardo Javier Aranibar León	19:48
[No subject]	Ricardo Javier Aranibar León	20:30
using rownum as index-counter of nested table or varray	Damonte Natalia	21:04
Re: Table Copy.	Dmitry Tkach	22:48
Re: help w/ constructing a SELECT	Josh Berkus	23:40

Sept. 20, 2002

Thread	Author	Time
Query Freeze	alexandre :: aldeia digital	00:31
Re: Effective usage without unique key -- suggestion	Dima Tkach	01:15
Re: Table Copy.	Christopher Kings-Lynne	02:04
Two Permance Questions	CN LIOU	02:07

Browse Archives

Prev | Next