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

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Sept. 22, 2002

Thread Author Time
Is there a better way than this to get the start and end of a month? David Stanaway 05:32

Sept. 23, 2002

Thread Author Time
Re: Monitoring a Query Bruce Momjian 01:51
Re: Monitoring a Query Aaron Held 13:24
Re: Performance w/ multiple WHERE clauses Aaron Held 13:31
Re: [GENERAL] Monitoring a Query Roberto Mello 13:47
Re: Stripping white-space in SELECT statments Tom Lane 14:26
Re: Stripping white-space in SELECT statments Thorbjörn Eriksson 14:28
Re: [SQL] Monitoring a Query Aaron Held 14:31
Re: [SQL] Monitoring a Query Bruce Momjian 14:48
Re: [SQL] Monitoring a Query Bruce Momjian 14:49
Re: [SQL] Monitoring a Query Tom Lane 15:03
Re: [SQL] Monitoring a Query Bruce Momjian 15:06
Re: Getting acces to MVCC version number Jean-Luc Lachance 15:47
Getting current transaction id Michael Paesold 16:03
Re: [SQL] Monitoring a Query Manfred Koizar 17:01
Re: [SQL] Monitoring a Query Tom Lane 17:05
Re: [SQL] CURRENT_TIMESTAMP Manfred Koizar 19:02
Re: [GENERAL] CURRENT_TIMESTAMP Josh Berkus 20:36
Re: [GENERAL] CURRENT_TIMESTAMP Bruce Momjian 20:41
Re: [GENERAL] CURRENT_TIMESTAMP Josh Berkus 20:49
Re: [GENERAL] CURRENT_TIMESTAMP Bruce Momjian 20:53
Re: [GENERAL] CURRENT_TIMESTAMP Tom Lane 20:55
Re: [GENERAL] Monitoring a Query Roberto Mello 22:01
HELP w/ SQL -- distinct select with non distinct fields? RVL 22:23
Re: HELP w/ SQL -- distinct select with non distinct fields? John Gilson 23:46

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

Browse Archives

Prev | Next