pgsql-sql since 2002-09-26 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. 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
Re: Large databases, performance Charles H. Woloszynski 14:26
Formatting current_time output Thomas Good 14:46
Re: Formatting current_time output Josh Berkus 15:03
epoch to date Roberto Mello 15:09
Re: Formatting current_time output Thomas Good 15:10
Re: Formatting current_time output Charles H. Woloszynski 15:22
Re: Formatting current_time output Karel Zak 15:28
Re: Formatting current_time output Achilleus Mantzios 15:28
Re: epoch to date Achilleus Mantzios 15:42
Re: Large databases, performance Shridhar Daithankar 15:50
Re: Large databases, performance Shridhar Daithankar 15:56
Re: Large databases, performance Robert Treat 15:57
drop constraint primary key Marie G. Tuite 16:06
Re: Large databases, performance Shridhar Daithankar 16:07
Re: [HACKERS] Large databases, performance Justin Clift 16:16
Re: Large databases, performance Shridhar Daithankar 16:17
Re: [HACKERS] Large databases, performance Greg Copeland 16:23
Re: Large databases, performance Robert Treat 16:26
Re: [HACKERS] Large databases, performance Shridhar Daithankar 16:30
Re: Large databases, performance Shridhar Daithankar 16:35
Re: Large databases, performance Manfred Koizar 16:44
Re: [HACKERS] Large databases, performance Hans-Jürgen Schönig 16:51
Re: [HACKERS] Large databases, performance Manfred Koizar 16:53
Re: drop constraint primary key Tom Lane 17:09
Re: Large databases, performance Ron Johnson 17:38
Rule creation Edoardo Causarano 19:34
Re: [SQL] [GENERAL] CURRENT_TIMESTAMP Bruce Momjian 20:18
Re: [HACKERS] Large databases, performance Ron Johnson 20:55
Re: [HACKERS] Large databases, performance Andrew Sullivan 21:09
use [PERF] instead of Jean-Luc Lachance 21:12
Re: [SQL] [GENERAL] CURRENT_TIMESTAMP Andrew Sullivan 22:03
Re: [SQL] [GENERAL] CURRENT_TIMESTAMP Bruce Momjian 22:15
Re: [SQL] [GENERAL] CURRENT_TIMESTAMP Tom Lane 23:09
Re: [SQL] [GENERAL] CURRENT_TIMESTAMP Andrew Sullivan 23:58

Oct. 4, 2002

Thread Author Time
Re: [SQL] [GENERAL] CURRENT_TIMESTAMP Bruce Momjian 00:41
order by x DESC, y ASC indexing problem Vincent-Olivier Arsenault 02:07
Re: order by x DESC, y ASC indexing problem Josh Berkus 02:30
Re: order by x DESC, y ASC indexing problem Bruno Wolff III 03:09
Re: order by x DESC, y ASC indexing problem Bruno Wolff III 03:12
Re: order by x DESC, y ASC indexing problem Tom Lane 03:14
Re: [SQL] [GENERAL] CURRENT_TIMESTAMP Oliver Elphick 05:03
Re: [SQL] [GENERAL] CURRENT_TIMESTAMP Tom Lane 05:20
Re: [HACKERS] Large databases, performance Shridhar Daithankar 08:00
Re: Can Postgres cache a table in memory? Achilleus Mantzios 13:14
Re: Can Postgres cache a table in memory? Richard Huxton 13:35
Re: rows in order Achilleus Mantzios 13:36
Re: rows in order Richard Huxton 13:37
Self Join? bens_nospam 14:05
Re: Can Postgres cache a table in memory? Tom Lane 14:14
Re: please help with converting a view in oracle into postgresql readably code Tom Lane 14:17
Re: Rule creation Tom Lane 14:24
Re: How slow is distinct - 2nd Tom Lane 14:44

Browse Archives

Prev | Next