pgsql-sql since 2002-02-18 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. 18, 2002

Thread	Author	Time
Function to split pg_trigger.tgargs	Christopher Kings-Lynne	05:35
all tables in a DB\?	D'laila Pereira	07:51
Sequence in the rules	Luis Sousa	12:10
Re: Function to split pg_trigger.tgargs	Rod Taylor	12:40
SQL: Are the "" around table & coloumnames necessary?	Mikey	12:43
Need to change the size of a field	suresh	13:30
Re: Need to change the size of a field	Nick Fankhauser	13:56
Re: Need to change the size of a field	postgresql	14:23
table locking	Shane Wright	14:39
Re: table locking	Bruce Momjian	15:16
Re: table locking	Shane Wright	15:22
Re: Sequence in the rules	Tom Lane	15:33
Re: table locking	Bruce Momjian	15:34
Re: table locking	Shane Wright	15:42
Re: table locking	Tom Lane	15:42
Re: table locking	Shane Wright	15:46
Re: table locking	Shane Wright	16:37
Re: Need to change the size of a field	Stephan Szabo	18:24
Why is my index not used	Kristian Eide	18:54
Casting pairs of floating point variables as a point in plpgsql	Irv Shapiro	19:02
Re: all tables in a DB\?	Rolf Hug	20:28
Re: Why is my index not used	Chris Ruprecht	20:59
Re: Why is my index not used	Tom Lane	21:04

Feb. 19, 2002

Thread	Author	Time
Re: obtaining row number of select	Christopher Kings-Lynne	01:26
maximum of sums	Rob	05:54
Transient Disk Usage Higher In 7.2 ?	Mark kirkwood	08:37
Re: [SQL] Transient Disk Usage Higher In 7.2 ?	Christopher Kings-Lynne	09:03
Re: maximum of sums	ThomasR	09:58
SELECT with LEFT OUTER JOIN ON 📎	Laurent Patureau	10:00
Re: SELECT with LEFT OUTER JOIN ON	Luis Sousa	11:06
Re: SELECT with LEFT OUTER JOIN ON	Luis Sousa	12:20
Re: Join Statements	Henshall, Stuart - WCP	13:05
SQL query (general)	D'laila Pereira	13:57
Re: Transient Disk Usage Higher In 7.2 ?	Tom Lane	14:54
inheritance and foreign key	Kancha .	15:17
Postgres vs. Mysql	Hunter, Ray	16:03
Init startup script	Hunter, Ray	16:22
Re: Postgres vs. Mysql	Frank Joerdens	16:40
Re: SQL For smarties	Rajesh Kumar Mallah	16:48
Re: [SQL] inheritance and foreign key	Stephan Szabo	16:53
Re: Postgres vs. Mysql	Marius Andreiana	17:14
Problem with self-join updates...	Benoit Menendez	18:32
Dates and year 2000	Andy Marden	18:41
Re: Problem with self-join updates...	Tom Lane	19:06
Re: Problem with self-join updates...	Benoit Menendez	19:35
Issues w/ 7.1 to 7.2 upgrade.	Diehl, Jeffrey	20:59
CURRENT_TIMESTAMP breaking with 7.1->7.2 dump/import	Mark Stosberg	22:04
Re: SQL reference card 📎	Bruce Momjian	22:29
Re: CURRENT_TIMESTAMP breaking with 7.1->7.2 dump/import	Mark Stosberg	22:47
comparision chart	clayton cottingham	23:39

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

Browse Archives

Prev | Next