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

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

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
Re: [SQL] CURRENT_TIMESTAMP	Martijn van Oosterhout	01:19
Re: [GENERAL] CURRENT_TIMESTAMP	Josh Berkus	01:53
Re: [GENERAL] CURRENT_TIMESTAMP	Bruce Momjian	02:01
Re: [SQL] Monitoring a Query	Alvaro Herrera	02:11
Re: Performance w/ multiple WHERE clauses	Josh Berkus	02:14
Re: [GENERAL] CURRENT_TIMESTAMP	John Hasler	02:20
Re: [GENERAL] CURRENT_TIMESTAMP	Bruce Momjian	03:17
Re: [SQL] Monitoring a Query	Bruce Momjian	03:18
Re: [GENERAL] CURRENT_TIMESTAMP	Tom Lane	03:35
Re: [GENERAL] CURRENT_TIMESTAMP	Bruce Momjian	03:37
Re: [GENERAL] CURRENT_TIMESTAMP	Tom Lane	03:44
Re: [GENERAL] CURRENT_TIMESTAMP	Bruce Momjian	03:52
database abstraction -> functions	Jeroen Olthof	07:45
Re: [SQL] CURRENT_TIMESTAMP	Manfred Koizar	08:33
Re: [GENERAL] CURRENT_TIMESTAMP	Manfred Koizar	09:16
Re: [GENERAL] CURRENT_TIMESTAMP	Manfred Koizar	09:37
Re: [GENERAL] CURRENT_TIMESTAMP	Manfred Koizar	09:44
Re: [GENERAL] CURRENT_TIMESTAMP	Haller Christoph	11:44
Re: [GENERAL] CURRENT_TIMESTAMP	Christoph Haller	12:08
Re: [GENERAL] CURRENT_TIMESTAMP	Tom Lane	13:26
Re: arrays (was untitled)	Stephan Szabo	13:51
Re: select case problem	Matteo Beccati	14:20
Re: [SQL] CURRENT_TIMESTAMP	Roland Roberts	14:55
Re: [GENERAL] CURRENT_TIMESTAMP	Josh Berkus	15:05
Re: [GENERAL] CURRENT_TIMESTAMP	Ross J. Reedstrom	15:07
Re: [GENERAL] CURRENT_TIMESTAMP	Ross J. Reedstrom	15:10
Re: [GENERAL] CURRENT_TIMESTAMP	Ross J. Reedstrom	15:19
Re: [GENERAL] CURRENT_TIMESTAMP	John Hasler	15:27
Re: [GENERAL] CURRENT_TIMESTAMP	Tom Lane	16:00
lastoid from sql	CoL	16:03
Re: lastoid from sql	CoL	16:18
select case problem	Joseph Syjuco	21:45
Re: [SQL] CURRENT_TIMESTAMP	Roland Roberts	21:48
Re: [SQL] CURRENT_TIMESTAMP	Bruce Momjian	21:56

Sept. 25, 2002

Thread	Author	Time
Timestamp Error - 7.2	Keith Gray	01:06
Re: Dublicates pairs in a table.	Kevin Houle	01:10
Re: [SQL] CURRENT_TIMESTAMP	Manfred Koizar	06:54
function return multiply rows	Jeroen Olthof	07:17
Re: database abstraction -> functions	Dmitry Tkach	14:03
Re: Is there a better way than this to get the start and end of a month?	Dmitry Tkach	14:28
Re: Is there a better way than this to get the start and end of a month?	Dmitry Tkach	14:39
Re: Timestamp Error - 7.2	Josh Berkus	16:13
Is it possible to use lo_write in SQL?	Boulgakov Andrei	16:18
Re: Getting current transaction id	Tom Lane	17:12
SQL formatter?	Andrew Perrin	17:44
PL/pgsql	Gustavo Tadao Okida	19:38
Re: SQL formatter?	Philip Hallstrom	20:19
Re: Getting current transaction id	Michael Paesold	20:21

Sept. 26, 2002

Thread	Author	Time
Tuning complicated query 📎	Ludwig Lim	09:57
start and end of the week	John Sebastian N. Mayordomo	10:56
Re: start and end of the week	Bruno Wolff III	13:26
Re: SQL formatter?	Andrew Perrin	15:49
Re: start and end of the week	Jean-Luc Lachance	15:55
Re: start and end of the week	Bruno Wolff III	16:20
Re: start and end of the week	Dmitry Tkach	16:29
None	Jordan Reiter	17:51
Case Sensitive "WHERE" Clauses?	Jordan Reiter	17:54
query problem "server sent binary data ... without prior row desc ription ..."	jonesbl	18:07
Re: check source of trigger	Rajesh Kumar Mallah.	18:13
Re: Case Sensitive "WHERE" Clauses?	Andrew Perrin	18:22
Preventing DELETEs	Rajesh Kumar Mallah.	19:00
Re: Preventing DELETEs	dima	19:00
Re: Preventing DELETEs	Robert Treat	19:09
Help tuning query	Kevin Traub	19:12
Re: Help tuning query	Dmitry Tkach	19:15
Re: Preventing DELETEs	Rajesh Kumar Mallah.	19:17
Re: Preventing DELETEs	Dmitry Tkach	19:17
Re: Preventing DELETEs	Rajesh Kumar Mallah.	19:23
Re: Preventing DELETEs	Rajesh Kumar Mallah.	19:50
Re: Case Sensitive "WHERE" Clauses?	Dan Langille	20:57
Re: Case Sensitive "WHERE" Clauses?	Dan Langille	21:08
Passing array to PL/SQL and looping	Peter Atkins	22:01
FW: query problem "server sent binary data ... without prior row description ..."	jonesbl	22:47
Re: Case Sensitive "WHERE" Clauses?	Ian Barwick	23:00
Re: FW: query problem "server sent binary data ... without	Stephan Szabo	23:01
Re: Case Sensitive "WHERE" Clauses?	Chris	23:14
Re: Case Sensitive "WHERE" Clauses?	Ian Barwick	23:33
Re: Case Sensitive "WHERE" Clauses?	Jochem van Dieten	23:41

Sept. 27, 2002

Thread	Author	Time
Re: Case Sensitive "WHERE" Clauses?	Jordan Reiter	00:17
Re: Passing array to PL/SQL and looping	Josh Berkus	01:20
Re: FW: query problem "server sent binary data ... without	Tom Lane	03:15
Re: Case Sensitive "WHERE" Clauses?	Tom Lane	03:19
Re: Case Sensitive "WHERE" Clauses?	Ian Barwick	07:25
Re: Case Sensitive "WHERE" Clauses?	Stephan Szabo	07:37
7.3 schemas	Andreas Joseph Krogh	11:42
Re: Null not equal to '' (empty)	Richard Huxton	12:36
Re: Null not equal to '' (empty)	Ries van Twisk	12:40
Re: Dublicates pairs in a table.	Richard Huxton	12:54
Re: 7.3 schemas	Mathieu Arnold	13:27
Re: Passing array to PL/SQL and looping	Greg Johnson	15:32
Re: Date/Time types	Josh Berkus	16:01
Re: Passing array to PL/SQL and looping	Josh Berkus	16:04
Re: Dublicates pairs in a table.	Stephan Szabo	16:09
Re: Null not equal to '' (empty)	Josh Berkus	16:16
Re: Dublicates pairs in a table.	Jean-Luc Lachance	16:17
Re: Dublicates pairs in a table.	Richard Huxton	16:37
Re: [SQL] function return multiply rows	Joe Conway	16:44
Re: Dublicates pairs in a table.	Jean-Luc Lachance	17:23
Re: [SQL] CURRENT_TIMESTAMP	Roland Roberts	17:29
Constraint problems	GB Clark	18:15
Re: Constraint problems	Stephan Szabo	18:29
PGSQL-Performance mailing list.	Josh Berkus	19:05
Re: Constraint problems	GB Clark	19:56
Re: PL/pgsql	Ian Barwick	20:16

Sept. 28, 2002

Thread	Author	Time
Re: Case Sensitive "WHERE" Clauses?	Kevin Houle	03:38
Re: [SQL] function return multiply rows	Alvaro Herrera	04:46
Re: Passing array to PL/SQL and looping	Ian Barwick	22:25

Sept. 29, 2002

Thread	Author	Time
Re: Passing array to PL/SQL and looping	Roland Roberts	00:27
Re: Passing array to PL/SQL and looping	Tom Lane	02:14
Re: Passing array to PL/SQL and looping	Tom Lane	02:18
Re: Passing array to PL/SQL and looping	Bruce Momjian	02:25
Re: SQL formatter?	Andrew G. Hammond	03:08
Re: [SQL] CURRENT_TIMESTAMP	Bruce Momjian	03:28
Re: [SQL] CURRENT_TIMESTAMP	Martijn van Oosterhout	03:47
Re: [SQL] CURRENT_TIMESTAMP	Bruce Momjian	03:51
Re: [SQL] CURRENT_TIMESTAMP	Martijn van Oosterhout	04:10
Re: [SQL] CURRENT_TIMESTAMP	Tom Lane	04:35
Re: [SQL] CURRENT_TIMESTAMP	Josh Berkus	19:43
Proposal for Clean-up of Conversion Functions	Josh Berkus	20:38
Re: [SQL] CURRENT_TIMESTAMP	Bruce Momjian	20:38
Re: [SQL] CURRENT_TIMESTAMP	Josh Berkus	20:47
Re: [SQL] CURRENT_TIMESTAMP	Bruce Momjian	21:27

Sept. 30, 2002

Thread	Author	Time
Re: [SQL] arrays	Mike Sosteric	00:12
Re: [SQL] CURRENT_TIMESTAMP	Tom Lane	03:53
Re: [SQL] CURRENT_TIMESTAMP	Tom Lane	04:36
Re: [SQL] arrays	Bruno Wolff III	12:29
Re: [SQL] arrays	Mike Sosteric	12:38
Re: [SQL] arrays	Achilleus Mantzios	13:18
Re: [SQL] arrays	Bruno Wolff III	13:57
Re: [SQL] arrays	Tom Lane	14:42
Re: [GENERAL] arrays	Josh Berkus	15:54
Re: [GENERAL] arrays	Dan Langille	15:59
Re: [GENERAL] arrays	Bruce Momjian	16:09
Re: [GENERAL] arrays	Dan Langille	16:10
Re: [SQL] CURRENT_TIMESTAMP	Bruce Momjian	16:20
Re: [GENERAL] arrays	Josh Berkus	16:30
converting Sybase RULE -> postgreSQL	Charles Hauser	17:02
Re: [GENERAL] arrays	Mike Sosteric	17:04
Re: [GENERAL] arrays	Josh Berkus	17:18
Unique constraint over null values	Thrasher	17:22
Re: [GENERAL] arrays	Mike Sosteric	17:24
Re: converting Sybase RULE -> postgreSQL	Josh Berkus	17:27
Re: [GENERAL] arrays	Josh Berkus	17:29
Re: Unique constraint over null values	Josh Berkus	17:33
Re: Unique constraint over null values	Thrasher	17:41
Re: Unique constraint over null values	Josh Berkus	17:50
Re: [SQL] CURRENT_TIMESTAMP	Tom Lane	17:59
Re: [GENERAL] arrays	Mike Sosteric	18:11
Re: [GENERAL] arrays	Josh Berkus	18:20
Re: [GENERAL] arrays	Mike Sosteric	18:24
rows in order	Camila Rocha	18:29
Re: [SQL] CURRENT_TIMESTAMP	Jean-Luc Lachance	18:37
Re: [SQL] CURRENT_TIMESTAMP	Jean-Luc Lachance	18:47
Re: [SQL] CURRENT_TIMESTAMP	Bruce Momjian	18:49
Re: [SQL] CURRENT_TIMESTAMP	Tom Lane	21:26

Oct. 1, 2002

Thread	Author	Time
Re: [SQL] arrays	Achilleus Mantzios	07:49
How slow is distinct - 2nd 📎	Michael Contzen	12:18
alter user does not changes password	Lucas Brasilino	14:46
Re: alter user does not changes password	dima	14:49
Re: alter user does not changes password	Tom Lane	14:52
Re: [GENERAL] arrays	Roland Roberts	17:43
Re: [SQL] arrays	Josh Berkus	17:52
Stored Procedures	bcschnei	18:16
Re: Stored Procedures	Roberto Mello	19:08

Oct. 2, 2002

Thread	Author	Time
please help with converting a view in oracle into postgresql readably code	Matthew Geddert	03:46
please help with converting a view in oracle into postgresql readably code	mgeddert	05:41
Re: please help with converting a view in oracle into postgresql readably code	Roberto Mello	06:12
split function for pl/pgsql	Frederic Logier	10:30
Re: PROBLEM SOLVED RE: please help with converting a view in oracle into postgresql readably code	Roberto Mello	13:25
Re: split function for pl/pgsql	Joe Conway	15:44
Re: Stored Procedures	david williams	15:47
Re: Stored Procedures	david williams	15:50
Re: Stored Procedures	Joe Conway	16:34
indexing on char vs varchar	Beth Gatewood	16:39
Re: split function for pl/pgsql	Frederic Logier	16:54
Re: indexing on char vs varchar	Bruce Momjian	17:06
Updating from select	Thrasher	17:11
Re: indexing on char vs varchar	Beth Gatewood	17:11
Re: Updating from select	Manfred Koizar	17:45
Re: Stored Procedures	bcschnei	17:53
Re: indexing on char vs varchar	Josh Berkus	17:55
Re: indexing on char vs varchar	Josh Berkus	17:56
Re: Stored Procedures	david williams	17:57
Re: indexing on char vs varchar	Beth Gatewood	18:01
Re: Stored Procedures	Joe Conway	18:09
schedule of v7.3	Jie Liang	19:06
celko nested set functions	Robert Treat	19:48
Re: schedule of v7.3	Bruce Momjian	21:24
Re: celko nested set functions	Josh Berkus	22:11

Oct. 3, 2002

Thread	Author	Time
Re: split function for pl/pgsql	Joe Conway	03:14
Re: Updating from select	Thrasher	08:18
Large databases, performance 📎	Shridhar Daithankar	12:36
Re: Large databases, performance	Charles H. Woloszynski	12:54
Re: Large databases, performance	Nigel J. Andrews	12:56
Re: Large databases, performance	Shridhar Daithankar	14:03
Can Postgres cache a table in memory?	Kevin Traub	14:03

Browse Archives

Prev | Next