pgsql-sql since 2002-09-15 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Sept. 15, 2002

Thread Author Time
Re: Timestamp Fractions Problem Florian Mader 09:00
Re: Timestamp Fractions Problem Tom Lane 14:51
Re: Slow Multi-joins performance [DEVELOPERS attn please] 21:34

Sept. 16, 2002

Thread Author Time
Re: Table alias in DELETE statements Bruce Momjian 04:03
Rules and Triggers: another question Jerome Chochon 06:57
Re: Timestamp Fractions Problem Florian Mader 08:29
Re: Want to test beta, but ... Richard Huxton 08:31
Re: Want to test beta, but ... Christopher Kings-Lynne 08:53
Re: How can unique columns being case-insensitive be accomplished? Tom Lane 13:38
Re: does table names have a format and size Michael Paesold 13:46
Re: cross tab (pivtor table) sql Michael Paesold 13:58
Formatting zeroes Ludwig Lim 14:41
Dublicates pairs in a table. Ries van Twisk 14:51
Re: "Inverting" a table, OLAP-style Tom Lane 14:55
Re: does table names have a format and size Stephan Szabo 15:03
Re: Dublicates pairs in a table. Richard Huxton 15:08
Re: How can unique columns being case-insensitive be accomplished? Ross J. Reedstrom 15:09
Re: Formatting zeroes Josh Berkus 15:52
Re: POSIX-style regular expressions Bruce Momjian 15:55
Re: Do the datatypes have set id/oid that are constant? Bruce Momjian 17:02
please delete my email address from your list Ngan Duong 17:04
Re: Table alias in DELETE statements Bruce Momjian 19:50

Sept. 17, 2002

Thread Author Time
Re: does table names have a format and size Christopher Kings-Lynne 01:28
Re: How to select and result row number?? Bruce Momjian 03:12
Re: Formatting zeroes Bruce Momjian 05:33
Re: Dublicates pairs in a table. Ries van Twisk 06:36
Re: Dublicates pairs in a table. Richard Huxton 10:07
Re: How to select and result row number?? Roland Roberts 14:14
Join Question Robert J. Sanford, Jr. 14:17
Re: How to select and result row number?? Ross J. Reedstrom 14:46
Re: How to select and result row number?? Tom Lane 15:05
Re: Returning a reference to a cursor from a function Richard Huxton 15:29
cannot delete bug Kemin Zhou 21:35
Re: How to select and result row number?? Bruce Momjian 21:44
Re: How to select and result row number?? Tom Lane 22:13
Re: How to select and result row number?? Bruce Momjian 22:21
Re: cannot delete bug Tom Lane 22:31
Re: How to select and result row number?? Tom Lane 22:43

Sept. 18, 2002

Thread Author Time
Re: Returning a reference to a cursor from a function Richard Huxton 10:21
Re: Returning a reference to a cursor from a function david williams 11:23
Creating a field that uses totals other fields? Sloan Bowman 16:26
TSQL2 (Temporal SQL) support for Postgres Ewan Grantham 18:45
Query to evaluate space used Jeff Boes 19:56
Performance w/ multiple WHERE clauses Aaron Held 21:17
Re: Performance w/ multiple WHERE clauses Stephan Szabo 21:58

Sept. 19, 2002

Thread Author Time
Re: Index usage on date feild , differences in '>' and '>=' Stephan Szabo 06:37
Index usage on date feild , differences in '>' and '>=' and between Rajesh Kumar Mallah. 06:38
Re: Index usage on date feild , differences in '>' and '>=' and between Rajesh Kumar Mallah. 07:06
Re: Stripping white-space in SELECT statments dima 11:08
Stripping white-space in SELECT statments Thorbjörn Eriksson 11:20
Re: Stripping white-space in SELECT statments Thorbjörn Eriksson 11:41
How To Get Bytea Data Instead Of Its Oid CN LIOU 14:11
Re: Index usage on date feild , differences in '>' and '>=' Stephan Szabo 14:28
Re: Stripping white-space in SELECT statments Tom Lane 14:31
Re: Stripping white-space in SELECT statments Stephan Szabo 14:34
help w/ constructing a SELECT Charles Hauser 14:41
Re: Stripping white-space in SELECT statments Mathieu Arnold 14:41
Table Copy. PostgreSQL Server 15:56
Re: How To Get Bytea Data Instead Of Its Oid Tom Lane 16:46
Re: Stripping white-space in SELECT statments Andreas Joseph Krogh 17:42
Re: Table Copy. Michael Paesold 18:10
problem with query Ricardo Javier Aranibar León 19:11
problem with query Ricardo Javier Aranibar León 19:48
[No subject] Ricardo Javier Aranibar León 20:30
using rownum as index-counter of nested table or varray Damonte Natalia 21:04
Re: Table Copy. Dmitry Tkach 22:48
Re: help w/ constructing a SELECT Josh Berkus 23:40

Sept. 20, 2002

Thread Author Time
Query Freeze alexandre :: aldeia digital 00:31
Re: Effective usage without unique key -- suggestion Dima Tkach 01:15
Re: Table Copy. Christopher Kings-Lynne 02:04
Two Permance Questions CN LIOU 02:07
Re: Query Freeze Tom Lane 02:59
Null not equal to '' (empty) Ajit Aranha 06:09
check source of trigger wit 08:25
Date/Time types Seb 08:54
Re: check source of trigger Richard Huxton 09:23
Re: Richard Huxton 10:35
timestamp parse error Tomas Lehuta 12:30
Re: Query Freeze alexandre :: aldeia digital 13:39
Re: Performance w/ multiple WHERE clauses Aaron Held 14:09
Re: timestamp parse error Stephan Szabo 14:38
query concat Ricardo Javier Aranibar León 14:46
Re: query concat Andreas Schmitz 15:06
Re: query concat Stephan Szabo 15:09
Re: timestamp parse error Tom Lane 15:19
Monitoring a Query Aaron Held 15:34
Re: Monitoring a Query Bruce Momjian 16:18
Re: Monitoring a Query Bruce Momjian 16:19
Re: help w/ constructing a SELECT Josh Berkus 16:38
Getting acces to MVCC version number Jean-Luc Lachance 18:22
Re: Two Permance Questions CoL 18:42
Re: Monitoring a Query Bruce Momjian 18:56
Re: Monitoring a Query Aaron Held 19:13
Re: Monitoring a Query Neil Conway 19:54
Re: Getting acces to MVCC version number Tom Lane 21:23
Re: Performance w/ multiple WHERE clauses Josh Berkus 21:55

Sept. 21, 2002

Thread Author Time
Appending to an array[] feild...[ ltree ] Rajesh Kumar Mallah. 04:45

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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30