pgsql-sql since 2002-09-12 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. 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
Re: Query Freeze	Tom Lane	02:59
Null not equal to '' (empty)	Ajit Aranha	06:09
check source of trigger	wit	08:25
Date/Time types	Seb	08:54
Re: check source of trigger	Richard Huxton	09:23
Re:	Richard Huxton	10:35
timestamp parse error	Tomas Lehuta	12:30
Re: Query Freeze	alexandre :: aldeia digital	13:39
Re: Performance w/ multiple WHERE clauses	Aaron Held	14:09
Re: timestamp parse error	Stephan Szabo	14:38
query concat	Ricardo Javier Aranibar León	14:46
Re: query concat	Andreas Schmitz	15:06
Re: query concat	Stephan Szabo	15:09
Re: timestamp parse error	Tom Lane	15:19
Monitoring a Query	Aaron Held	15:34
Re: Monitoring a Query	Bruce Momjian	16:18
Re: Monitoring a Query	Bruce Momjian	16:19
Re: help w/ constructing a SELECT	Josh Berkus	16:38
Getting acces to MVCC version number	Jean-Luc Lachance	18:22
Re: Two Permance Questions	CoL	18:42
Re: Monitoring a Query	Bruce Momjian	18:56
Re: Monitoring a Query	Aaron Held	19:13
Re: Monitoring a Query	Neil Conway	19:54
Re: Getting acces to MVCC version number	Tom Lane	21:23
Re: Performance w/ multiple WHERE clauses	Josh Berkus	21:55

Sept. 21, 2002

Thread	Author	Time
Appending to an array[] feild...[ ltree ]	Rajesh Kumar Mallah.	04:45

Sept. 22, 2002

Thread	Author	Time
Is there a better way than this to get the start and end of a month?	David Stanaway	05:32

Sept. 23, 2002

Thread	Author	Time
Re: Monitoring a Query	Bruce Momjian	01:51
Re: Monitoring a Query	Aaron Held	13:24
Re: Performance w/ multiple WHERE clauses	Aaron Held	13:31
Re: [GENERAL] Monitoring a Query	Roberto Mello	13:47
Re: Stripping white-space in SELECT statments	Tom Lane	14:26
Re: Stripping white-space in SELECT statments	Thorbjörn Eriksson	14:28
Re: [SQL] Monitoring a Query	Aaron Held	14:31
Re: [SQL] Monitoring a Query	Bruce Momjian	14:48
Re: [SQL] Monitoring a Query	Bruce Momjian	14:49
Re: [SQL] Monitoring a Query	Tom Lane	15:03
Re: [SQL] Monitoring a Query	Bruce Momjian	15:06
Re: Getting acces to MVCC version number	Jean-Luc Lachance	15:47
Getting current transaction id	Michael Paesold	16:03
Re: [SQL] Monitoring a Query	Manfred Koizar	17:01
Re: [SQL] Monitoring a Query	Tom Lane	17:05
Re: [SQL] CURRENT_TIMESTAMP	Manfred Koizar	19:02
Re: [GENERAL] CURRENT_TIMESTAMP	Josh Berkus	20:36
Re: [GENERAL] CURRENT_TIMESTAMP	Bruce Momjian	20:41
Re: [GENERAL] CURRENT_TIMESTAMP	Josh Berkus	20:49
Re: [GENERAL] CURRENT_TIMESTAMP	Bruce Momjian	20:53
Re: [GENERAL] CURRENT_TIMESTAMP	Tom Lane	20:55
Re: [GENERAL] Monitoring a Query	Roberto Mello	22:01
HELP w/ SQL -- distinct select with non distinct fields?	RVL	22:23
Re: HELP w/ SQL -- distinct select with non distinct fields?	John Gilson	23:46

Sept. 24, 2002

Thread	Author	Time
Re: [GENERAL] CURRENT_TIMESTAMP	Bruce Momjian	00:11
Re: [SQL] Monitoring a Query	Bruce Momjian	00:27
Re: [GENERAL] CURRENT_TIMESTAMP	Tom Lane	00:32
Re: [GENERAL] CURRENT_TIMESTAMP	Bruce Momjian	00:37

Browse Archives

Prev | Next