pgsql-sql since 2002-02-20 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

Feb. 20, 2002

Thread	Author	Time
Re: CURRENT_TIMESTAMP breaking with 7.1->7.2 dump/import	Christopher Kings-Lynne	03:13
Re: Issues w/ 7.1 to 7.2 upgrade.	Josh Berkus	03:38
Re: comparision chart	Christopher Sawtell	05:43
Re: comparision chart	Johannes =?iso-8859-15?q?Gr=F8dem?=	08:36
Re: comparision chart	Christopher Kings-Lynne	08:59
combination of 'textcat' and 'interval' in 7.2.	Bhuvan A	12:02
Re: Issues w/ 7.1 to 7.2 upgrade.	Thomas Good	13:11
Changing a column constraint?	Henry Holland	13:21
Re: combination of 'textcat' and 'interval' in 7.2.	Peter Eisentraut	16:19
Re: comparision chart	clayton cottingham	17:28
Re: SQL For smarties	Graham Vickrage	18:55
Re: SQL For smarties	Stephan Szabo	19:15
Re: SQL For smarties	Jeff Eckermann	19:20
Re: SQL For smarties	Josh Berkus	20:16
Re: Dates and year 2000	Andy Marden	20:37
Matching columns in rows from two tables	Richard Emberson	21:51
Re: Dates and year 2000	Tom Lane	23:21
Re: comparision chart	Josh Berkus	23:32
Re: comparision chart	clayton cottingham	23:57

Feb. 21, 2002

Thread	Author	Time
Re: Dates and year 2000	Thomas Lockhart	01:54
Trying to convert a TIMESTAMP return value to TIME	Erik Norvelle	03:35
OT: duplicate emails...	Rajesh Kumar Mallah	07:33
Re: Dates and year 2000	Andy Marden	07:59
Changing column constraints?	Henry Holland	09:25
Re: Dates and year 2000	Andy Marden	09:27
Re: comparision chart	Troels Arvin	13:47
Re: Dates and year 2000	Thomas Lockhart	14:13
Re: comparision chart	Brian Knox	14:14
Help with many updates	Glenn MacGregor	16:31
Re: Money type and kylix	Josh Berkus	19:03
Re: Changing column constraints?	Josh Berkus	19:07
Re: current connections and queries	Hunter, Ray	19:30
Re: Changing column constraints?	Stephan Szabo	19:52
Finding matching columns from two tables	Richard Emberson	20:17
Re: Help with many updates	Oliver Elphick	21:09
Re: Trying to convert a TIMESTAMP return value to TIME	Erik Norvelle	21:13
Re: all tables in a DB\?	Jie Liang	21:21
Re: SQL: Are the "" around table & coloumnames necessary?	Oliver Elphick	21:39
Re: maximum of sums	Jean-Luc Lachance	21:55
Re: SQL query (general)	Jean-Luc Lachance	22:09
Permanent fatal errors	Josh Berkus	22:14
Finding matching columns from two tables	Richard Emberson	22:34

Feb. 22, 2002

Thread	Author	Time
Re: Casting pairs of floating point variables as a point in plpgsql	Tom Lane	00:18
Re: Permanent fatal errors	Tom Lane	01:01
Re: Trying to convert a TIMESTAMP return value to TIME	Tom Lane	02:07
Date Problem	pauLSiew	02:39
Re: all tables in a DB\?	Christopher Kings-Lynne	03:10
Re: create index on function - why?	Christopher Kings-Lynne	03:13
Re: Array slice subscripts (was Re: [SQL] plpgsql function	Bruce Momjian	03:55
Re: Array slice subscripts (was Re: [SQL] plpgsql function with more than one array argument)	Tom Lane	04:14
Re: SQL: Are the "" around table & coloumnames necessary?	pauLSiew	06:50
Can someone help me with this function? 📎	Christopher Kings-Lynne	08:51
Re: Can someone help me with this function?	Christopher Kings-Lynne	09:02
Re: Array slice subscripts (was Re: [SQL] plpgsql function	Andre Holzner	09:17
quotes nightmare!	Graham Vickrage	13:18
How does Index Scan get used	Samuel J. Sutjiono	14:46
Page Management	Samuel J. Sutjiono	15:13
Re: Postgres vs. Mysql	Roberto Mello	15:55
Re: Page Management	Wei Weng	15:58
Re: comparision chart	Roberto Mello	16:00
Re: quotes nightmare!	Stephan Szabo	16:11
Re: How does Index Scan get used	Stephan Szabo	16:13
Re: quotes nightmare!	Roberto Mello	16:28
Re: Date Problem	Josh Berkus	16:51
Regular Expression for 'and' instead of 'or'	Samuel J. Sutjiono	17:04
Re: Page Management	Nick Fankhauser	17:13
How do I return more than one value in a postgresql pl/pgsql procedure?	Mark Nielsen	17:56
Re: How does Index Scan get used	Oliver Elphick	18:08
Re: Regular Expression for 'and' instead of 'or'	Fernando Schapachnik	18:15
Re: [SQL] Regular Expression for 'and' instead of 'or'	Samuel J. Sutjiono	18:34
Re: [SQL] Regular Expression for 'and' instead of 'or'	Fernando Schapachnik	18:46
Re: How does Index Scan get used	Oliver Elphick	19:32
Re: How does Index Scan get used	Frank Bax	20:13
Re: Regular Expression for 'and' instead of 'or'	Tom Lane	20:20
Re: [SQL] Regular Expression for 'and' instead of 'or'	Peter Eisentraut	20:45
Re: Regular Expression for 'and' instead of 'or'	Medi Montaseri	21:26
Bench Test	Hunter, Ray	21:53
Re: comparision chart	Mark kirkwood	23:47

Feb. 23, 2002

Thread	Author	Time
Re: How does Index Scan get used	Tom Lane	00:11
Re: [SQL] Transient Disk Usage Higher In 7.2 ?	Mark kirkwood	00:29
Re: How does Index Scan get used	Oliver Elphick	00:56
Re: Matching columns in rows from two tables	Masaru Sugawara	06:18
Re: Regular Expression for 'and' instead of 'or'	Rajesh Kumar Mallah	06:25
should I use postgresql arrays...	Rajesh Kumar Mallah	06:37
Re: Finding matching columns from two tables	Masaru Sugawara	08:41
[No subject]	Bradley Baetz	10:21
Re: should I use postgresql arrays...	Peter Eisentraut	17:21
Re: Bench Test	Tom Lane	18:49
Re: How do I return more than one value in a postgresql pl/pgsql procedure?	Roberto Mello	19:03
How to insert zeros into a bytea column?	Iklódi Lajos	20:16
More open source database comparison...	Benoit Menendez	20:20
Re: How to insert zeros into a bytea column?	Joe Conway	21:04
Re: should I use postgresql arrays...	Christopher Sawtell	21:32
Re: More open source database comparison...	Christopher Sawtell	21:45

Feb. 24, 2002

Thread	Author	Time
callable statement support	Henry	07:44
Re: Matching columns in rows from two tables	Masaru Sugawara	14:59
PLPGSQL func. defn. for returning resultset?	Otis Gospodnetic	20:18

Feb. 25, 2002

Thread	Author	Time
returning a record from a function?	Jon Obuchowski	03:33
Re: returning a record from a function?	Tom Lane	03:49
processing faster with plpgsql by passing in more data	Dan Langille	05:30
Re: PLPGSQL func. defn. for returning resultset?	Roberto Mello	14:55
Re: returning a record from a function?	Roberto Mello	14:59
About referential integrity.	BOURIAUD	15:01
[CHALLANGE] Add seconds to a date	panjas51	16:16
Database Setup	Hunter, Ray	16:36
Re:	Tom Lane	16:48
Sort problem	Samuel J. Sutjiono	17:17
Re: About referential integrity.	Josh Berkus	17:21
Re: About referential integrity.	Oliver Elphick	17:46
Re: PLPGSQL func. defn. for returning resultset?	Jan Wieck	19:09
Re: [GENERAL] Sort problem	Samuel J. Sutjiono	19:12
Re: About referential integrity.	Peter Eisentraut	19:15
Re: [SQL] Sort problem	Bruce Momjian	19:46
Re: [SQL] Sort problem	Samuel J. Sutjiono	19:52
Re: Sort problem	Oliver Elphick	20:01
Re: [SQL] Sort problem	Bruce Momjian	20:03
Re: Sort problem	Jean-Luc Lachance	21:53
record iteration within SQL	Dan Langille	22:08
Re: Sort problem	Tom Lane	23:09
Re: record iteration within SQL	Tom Lane	23:45
Re: record iteration within SQL	Dan Langille	23:52

Feb. 26, 2002

Thread	Author	Time
Timestamp operator error	Josh Berkus	04:10
Re: Timestamp operator error	Tom Lane	04:28
Re: Timestamp operator error	Josh Berkus	04:34
Re: Timestamp operator error	Tom Lane	04:47
Re: Timestamp operator error	Josh Berkus	05:03
Re: Timestamp operator error	Tom Lane	05:10
Re: Timestamp operator error	Josh Berkus	05:20
Re: Timestamp operator error	Tom Lane	05:31
Re: Timestamp operator error	Josh Berkus	05:42
Re: Timestamp operator error	Josh Berkus	06:13
transaction abortion	Kancha .	06:35
Re: [SQL] transaction abortion	Christopher Kings-Lynne	06:47
Re: [SQL] transaction abortion	Kancha .	07:43
Re: About referential integrity.	David BOURIAUD	07:51
Re: [SQL] transaction abortion	Kancha .	07:51
Re: On delete cascade!	Erle Czar Mantos	07:53
Re: About referential integrity.	Christopher Kings-Lynne	08:02
Re: [SQL] query optimistaion problems	Bradley Baetz	08:09
Re: transaction abortion	Martijn van Oosterhout	08:17
Re: test the existence of a database	Erle Czar Mantos	08:20
Re: test the existence of a database	Jerome Alet	08:40
Timestamp output	Matteo Beccati	09:36
Re: Timestamp output	Christopher Kings-Lynne	14:39
Removing duplicates	Matthew Hagerty	15:10
Re: Removing duplicates	Andrew Perrin	15:44
Re: Timestamp output	Tom Lane	15:55
Re: Removing duplicates	Jeff Self	16:19
Re: Removing duplicates	Josh Berkus	16:39
Re: Sort problem	Jean-Luc Lachance	16:41
Re: Removing duplicates	Dan MacNeil	16:44
Re: Removing duplicates	Matthew Hagerty	17:16
Re: Join Statements	Andy Marden	17:20
Re: Removing duplicates	Christof Glaser	17:26
Re: Timestamp output	Andreas Joseph Krogh	17:56
Re: [CHALLANGE] Add seconds to a date	Frank Bax	19:38
Re: About referential integrity.	Stephan Szabo	19:52
sub SELECT	Charles Hauser	20:42
Urgent, Many-to-many relationships.....HELP!!!!	Dalton Shane	20:45
Re: About referential integrity.	Josh Berkus	21:08
Re: About referential integrity.	Stephan Szabo	22:30

Feb. 27, 2002

Thread	Author	Time
Re: Timestamp output	Christopher Kings-Lynne	03:17
Left Outer Join Question	Edward Murray	04:18
Re: Removing duplicates	OV	04:52
Re: Left Outer Join Question	Christopher Kings-Lynne	05:23
Re: Timestamp output	Tom Lane	05:48
Bad design or SQL statment quandary	grep	05:53
Re: Left Outer Join Question	Tom Lane	05:55
Re: Left Outer Join Question	Edward Murray	05:59
Re: Left Outer Join Question	Christopher Kings-Lynne	06:04
Re: Left Outer Join Question	Edward Murray	06:09
Re: Left Outer Join Question	Stephan Szabo	06:55
Err. compiling func. with SET TRANS...	otisg	07:33
INSERT requires SERIAL column?	otisg	07:38
Re: INSERT requires SERIAL column?	Christopher Kings-Lynne	07:50
Re: Err. compiling func. with SET TRANS...	Christopher Kings-Lynne	07:54
Re: INSERT requires SERIAL column?	D'Arcy J.M. Cain	08:51
Re: Bad design or SQL statment quandary	Bruno Wolff III	13:21
Large Objects	Hunter, Ray	13:45
implementation of a many-to-many relationship	Dalton Shane	14:06
Re: Err. compiling func. with SET TRANS...	otisg	14:18
Re: implementation of a many-to-many relationship	Stephan Szabo	15:11
Re: implementation of a many-to-many relationship	Dan Langille	15:15
System Messages	Samuel J. Sutjiono	15:39
Re: implementation of a many-to-many relationship	Josh Berkus	16:25
Re: implementation of a many-to-many relationship	Jeff Self	18:04
Re: implementation of a many-to-many relationship	Dan Langille	18:07
How slow is DISTINCT?	Wei Weng	18:27
Re: System Messages	Gregory Wood	19:14
Re: Large Objects	postgresql	21:07
Re: How slow is DISTINCT?	Dan Langille	21:30
Re: How slow is DISTINCT?	Josh Berkus	21:45
Re: How slow is DISTINCT?	Josh Berkus	22:54
Re: How slow is DISTINCT?	Wei Weng	22:57
Re: How slow is DISTINCT?	Wei Weng	23:20

Feb. 28, 2002

Thread	Author	Time
Re: Large Objects	Christopher Kings-Lynne	01:05
Re: Large Objects	Erle Czar Mantos	02:36
backward SQL query	Jan Oravec	11:34
Re: backward SQL query	Karel Zak	11:55
Re: How slow is DISTINCT?	TimothyReaves	13:45

Browse Archives

Prev | Next