pgsql-sql since 2002-11-19 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

Nov. 19, 2002

Thread	Author	Time
Re: Bug with sequence	Lee Harr	01:22
Re: Problems invoking psql. Help please.	Hugh Esco	04:44
Re: Press Release -- Just Waiting for Tom	Justin Clift	05:41
Re: Problems invoking psql. Help please.	Tom Lane	05:56
create index	[email protected]	06:44
[No subject]	sun yu	08:09
Re: Problems invoking psql. Help please.	Tomasz Myrta	08:25
Re: Problems invoking psql. Help please.	Luis Sousa	09:03
index usage for query	Tomas Berndtsson	09:10
Re: Proposal of hierarchical queries, a la Oracle	Evgen Potemkin	12:12
Re: index usage for query	Richard Huxton	12:25
Re: Proposal of hierarchical queries, a la Oracle	Evgen Potemkin	12:26
Re: Proposal of hierarchical queries, a la Oracle	Evgen Potemkin	12:45
Re: Proposal of hierarchical queries, a la Oracle	Oleg Bartunov	13:36
Re: create index	Tomasz Myrta	14:13
Re:	Tomasz Myrta	14:26
Re: slow group by query	Stephan Szabo	15:04
Re: slow group by query	Tom Lane	15:21
Re: how can I improve the speed of this query	Frank Bax	15:44
Re: Problems invoking psql. Help please.	Hugh Esco	15:56
Re: slow group by query	Ellen Cyran	16:08
Re: slow group by query	Ellen Cyran	16:26
Re: slow group by query	Tom Lane	16:54
SQL -select count-	Giannis	17:06
Re: Problems invoking psql. Help please.	Luis Sousa	17:20
Re: Proposal of hierarchical queries, a la Oracle	Joe Conway	17:27
Re: slow group by query	Ellen Cyran	17:47
Using VIEW to simplify code...	Chris Gamache	18:29
Re: Using VIEW to simplify code...	Tom Lane	19:47
Re: Using VIEW to simplify code...	Chris Gamache	21:37
Re: Using VIEW to simplify code...	Stephan Szabo	22:56
Re: Using VIEW to simplify code...	Tom Lane	23:15
Re: Using VIEW to simplify code...	Chris Gamache	23:40

Nov. 20, 2002

Thread	Author	Time
trying to learn plpqsql... so please forgive..	Michiel Lange	00:16
Re: Problems invoking psql. Help please.	jasiek	00:30
Re: Problems invoking psql. Help please.	Tomasz Myrta	00:47
Re: Problems invoking psql. Help please.	Hugh Esco	06:30
Re: Problems invoking psql. Help please.	Rudi Starcevic	06:40
Re: Problems invoking psql. Help please.	Hugh Esco	06:55
Re: Problems invoking psql. Help please.	Hugh Esco	06:59
Re: Problems invoking psql. Help please.	Tom Lane	07:13
Re: Problems invoking psql. Help please.	Michiel Lange	07:40
Re: Bug with sequence	Oliver Elphick	08:53
Re: Problems invoking psql. Help please.	Luis Sousa	09:38
Date trunc in UTC	Thrasher	09:44
Re: trying to learn plpqsql... so please forgive..	Luis Sousa	09:44
Re: trying to learn plpqsql... so please forgive..	Henshall, Stuart - Design & Print	09:48
Re: trying to learn plpqsql... so please forgive..	Johannes Lochmann	09:58
Re: Date trunc in UTC	Richard Huxton	10:24
Re: Date trunc in UTC	Thrasher	10:37
Re: Problems invoking psql. Help please.	Oliver Elphick	12:49
Re: Date trunc in UTC	Richard Huxton	13:06
Re: Problems invoking psql. Help please.	Hugh Esco	13:12
Re: Problems invoking psql. Help please.	Hugh Esco	13:52
Re: Problems invoking psql. Help please.	Hugh Esco	14:23
Re: Problems invoking psql. Help please.	Oliver Elphick	14:45
Re: Problems invoking psql. Help please.	Oliver Elphick	14:46
Re: Problems invoking psql. Help please.	Tom Lane	15:03
Re: Date trunc in UTC	Juan Fernandez	15:40
Re: trying to learn plpqsql... so please forgive..	Josh Berkus	16:49
Closing inactive connections OR user connections limits	Francisco Reyes	16:52
Re: Problems invoking psql. Help please.	Oliver Elphick	17:00
Re: Closing inactive connections OR user connections limits	Neil Conway	17:54
Re: Problems invoking psql. Help please.	Hugh Esco	18:29
Re: Closing inactive connections OR user connections limits	Medi Montaseri	18:35
Re: Closing inactive connections OR user connections limits	Francisco Reyes	18:36
Re: Closing inactive connections OR user connections limits 📎	Neil Conway	18:36
Re: Closing inactive connections OR user connections limits	Francisco Reyes	18:54
Re: Closing inactive connections OR user connections limits	Francisco Reyes	18:56
Re: Closing inactive connections OR user connections limits	Medi Montaseri	19:00
Drop NOT NULL constraint !!!	Ren Salomo	19:09
Re: [SQL] Drop NOT NULL constraint !!!	mallah	19:17
Re: Closing inactive connections OR user connections limits	scott.marlowe	19:32
Re: Trees: maintaining pathnames	Dan Langille	20:20
Re: Closing inactive connections OR user connections limits	Neil Conway	21:15
Re: Closing inactive connections OR user connections limits	Neil Conway	21:33
Re: Trees: maintaining pathnames	Joe Conway	21:57
Re: Closing inactive connections OR user connections	Oliver Elphick	22:02
Re: Closing inactive connections OR user connections limits	scott.marlowe	22:08
Re: Closing inactive connections OR user connections limits 📎	Neil Conway	22:11
Re: [GENERAL] Bug with sequence	Oliver Elphick	22:12
Re: trying to learn plpqsql... so please forgive..	Michiel Lange	22:14
Re: trying to learn plpqsql... so please forgive..	Josh Berkus	22:27
Re: Closing inactive connections OR user connections limits	Medi Montaseri	22:47
Re: Closing inactive connections OR user connections limits	scott.marlowe	23:12
Re: Closing inactive connections OR user connections	Brian Hirt	23:16
Re: [GENERAL] Bug with sequence	Rod Taylor	23:20
Re: Closing inactive connections OR user connections limits	Medi Montaseri	23:53

Nov. 21, 2002

Thread	Author	Time
Re: Closing inactive connections OR user connections limits	scott.marlowe	00:00
Re: Closing inactive connections OR user connections limits	scott.marlowe	00:09
Re: [GENERAL] Bug with sequence	Justin Clift	02:40
Re: [GENERAL] Bug with sequence	Neil Conway	03:44
Re: [GENERAL] Bug with sequence	Justin Clift	03:46
Re: [GENERAL] Bug with sequence	Tom Lane	04:11
Re: [GENERAL] Bug with sequence	Justin Clift	05:03
select for update	Justin Georgeson	05:20
why the difference?	Rajesh Kumar Mallah.	06:47
Re: Drop NOT NULL constraint !!!	Mario Weilguni	06:53
can i decrease the query time?	[email protected]	07:03
Re: why the difference?	Jakub Ouhrabka	08:42
Re: Date trunc in UTC	Richard Huxton	10:15
importing a 7.2 db with contrib/tsearch to 7.3	Andreas Joseph Krogh	10:55
Re: Drop NOT NULL constraint !!!	Ludwig Lim	11:01
Re: importing a 7.2 db with contrib/tsearch to 7.3	Achilleus Mantzios	11:13
psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars	Achilleus Mantzios	11:38
Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars	Ian Barwick	14:11
retrieving specific info. from one column and locating it in another	MARC BEDOIS	14:11
help optimise this ?	Peter Galbavy	14:22
Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars	Achilleus Mantzios	14:27
Re: why the difference?	Tom Lane	14:47
Re: help optimise this ?	Henshall, Stuart - Design & Print	14:51
Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars	Achilleus Mantzios	14:59
Re: Date trunc in UTC	Tom Lane	15:26
Re: help optimise this ?	Tom Lane	15:46
Re: help optimise this ?	Peter Galbavy	15:49
Re: [GENERAL] Bug with sequence	Thomas O'Connell	18:53
Re: [HACKERS] [GENERAL] Bug with sequence	Bruce Momjian	19:11
Re: [GENERAL] Bug with sequence	Bruce Momjian	19:14
Re: [HACKERS] [GENERAL] Bug with sequence	Rod Taylor	19:22
Re: [HACKERS] [GENERAL] Bug with sequence	Tom Lane	19:30
Re: [HACKERS] [GENERAL] Bug with sequence	scott.marlowe	20:09
Re: [HACKERS] [GENERAL] Bug with sequence	Rod Taylor	20:23
Re: [HACKERS] [GENERAL] Bug with sequence	scott.marlowe	21:52
Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars	Manuel Sugawara	22:38
Dropping Ref. Integrity	Rudi Starcevic	23:25

Nov. 22, 2002

Thread	Author	Time
connectby questions	Dan Langille	06:18
Re: Date trunc in UTC	Thrasher	09:11
escape single quote in INSERT command	Hunter	13:00
Re: connectby questions	Dan Langille	13:00
calculating interval	praveen vejandla	14:26
Re: calculating interval	Dan Langille	14:36
Re: Date trunc in UTC	Tom Lane	15:10
Re: calculating interval	Jean-Luc Lachance	16:26
Re: calculating interval	Jeff Boes	18:34
Re: escape single quote in INSERT command	Jeff Boes	18:38
join question	Nathan Young	19:44
Re: escape single quote in INSERT command	mark carew	21:50
Re: escape single quote in INSERT command	mark carew	21:52
Re: Trees: maintaining pathnames	Dan Langille	21:55
Re: Trees: maintaining pathnames	Dan Langille	22:17
Re: Trees: maintaining pathnames	Josh Berkus	22:37

Nov. 23, 2002

Thread	Author	Time
LIMIT and/or GROUP BY help!	Arcadius A.	12:33
SQL query help!	Arcadius A.	22:09

Nov. 24, 2002

Thread	Author	Time
copy from command - quotes and header lines	Kenneth Evans	17:21

Nov. 25, 2002

Thread	Author	Time
How does postgres handle non literal string values	javaholic	12:57
Question on SQL and pg_-tables	Tilo Schwarz	16:21
Re: Question on SQL and pg_-tables	Tom Lane	18:32
changing the size of a column without dump/restore	Michael Richards	18:57
Re: celko nested set functions	greg	20:22

Nov. 26, 2002

Thread	Author	Time
subselect instead of a view...	Dan Langille	03:15
Re: subselect instead of a view...	Dan Langille	05:07
celko nested set functions -- tree move	Martin Crundall	05:13
Re: subselect instead of a view...	Tom Lane	05:29
How to recover Data	Padmanab Sridhar	06:14
PL/SQL trouble	Ferruccio Zamuner	08:56
Are sub-select error suppressed?	patrick	09:43
Re: Are sub-select error suppressed?	Richard Huxton	10:41
Re: PL/SQL trouble	Richard Huxton	10:51
Re: PL/SQL trouble	Christoph Haller	11:55
Inheritance in SQL99 ?	Albrecht Berger	12:55
help on sql query	Zuev Dmitry	13:14
[SQL/BUGS] (possible) inconsistent behaviour of timestamp?	Rison, Stuart	13:54
Two TIMESTAMPs in one pl/sql function	Rison, Stuart	13:54
Re: How does postgres handle non literal string values	Henshall, Stuart - Design & Print	15:12
Re: subselect instead of a view...	Dan Langille	15:17
Re: Two TIMESTAMPs in one pl/sql function	Richard Huxton	15:24
Re: help on sql query	Richard Huxton	15:26
Re: [GENERAL] Bug with sequence	Peter Gulutzan	15:30
Re: How does postgres handle non literal string values	Richard Huxton	15:35
Re: SQL -select count-	Richard Huxton	15:36
Re: Are sub-select error suppressed?	Stephan Szabo	15:52
Re: can i decrease the query time?	Stephan Szabo	15:53
Re: How to recover Data	mallah	15:59
Re: celko nested set functions -- tree move	Robert Treat	16:00
Re: select for update	Stephan Szabo	16:00
Re: How does postgres handle non literal string values	Charles H. Woloszynski	16:05
Re: join question	Stephan Szabo	16:11
Re: Are sub-select error suppressed?	dev	17:04
Re: How does postgres handle non literal string values	Rob Hills	17:18
Re: Are sub-select error suppressed?	Stephan Szabo	17:22
Re: escape single quote in INSERT command	Thomas Good	18:23
Re: escape single quote in INSERT command	mallah	18:31
Re: escape single quote in INSERT command	Thomas Good	18:41
Re: escape single quote in INSERT command	Dan Langille	18:47
Re: celko nested set functions -- tree move	Martin Crundall	18:59
Casting Money To Numeric	Thomas Good	19:19
Re: copy from command - quotes and header lines	Peter Eisentraut	23:52

Nov. 27, 2002

Thread	Author	Time
Re: [SQL] [SQL/BUGS] (possible) inconsistent behaviour of timestamp?	Tom Lane	02:14
Re: SQL -select count-	Achilleus Mantzios	08:00
Re: SQL query help!	Luis Sousa	10:05
Re: Question on SQL and pg_-tables	Tilo Schwarz	10:13
Function and insert	Laurent Patureau	11:05
FreeBSD, Linux: select, select count(*) performance	Achilleus Mantzios	12:23
Big query problem	Tomas Berndtsson	12:46
Re: Casting Money To Numeric	D'Arcy J.M. Cain	12:51
Re: Function and insert	Richard Huxton	15:35
Re: FreeBSD, Linux: select, select count(*) performance	Tom Lane	16:15
Re: [GENERAL] FreeBSD, Linux: select, select count(*) performance	Oleg Bartunov	16:29
Re: FreeBSD, Linux: select, select count(*) performance	Achilleus Mantzios	16:35
Re: FreeBSD, Linux: select, select count(*) performance	Tom Lane	16:56

Browse Archives

Prev | Next