pgsql-sql since 2002-09-13 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. 13, 2002

Thread Author Time
Re: DISTINCT Christopher Kings-Lynne 02:30
DISTINCT Rudi Starcevic 02:31
Re: DISTINCT Rudi Starcevic 02:44
Re: DISTINCT ON Christopher Kings-Lynne 02:48
DISTINCT ON Rudi Starcevic 02:49
How can unique columns being case-insensitive be accomplished? Jrg 09:07
sql group by statement Albrecht Berger 10:29
Re: sql group by statement dima 10:33
Re: sql group by statement Albrecht Berger 10:39
Assignments in PL/pgSQL Michael Paesold 10:43
Table alias in DELETE statements Hanno Wiegard 12:10
Re: sql group by statement Manfred Koizar 12:16
Re: Table alias in DELETE statements Manfred Koizar 12:46
Re: DISTINCT ON Chad Thompson 14:35
Timestamp Fractions Problem Florian Mader 14:38
Timestamp Fractions Problem Florian Mader 14:49
Re: [SQL] Latitude / Longitude Jan Wieck 15:19
Re: sql group by statement Jean-Luc Lachance 15:39
Re: LIMIT within UNION? Andrew Perrin 15:45
Re: Assignments in PL/pgSQL Josh Berkus 17:51
Re: Assignments in PL/pgSQL Jan Wieck 18:04
Re: Assignments in PL/pgSQL Joe Conway 18:04
Re: Assignments in PL/pgSQL Josh Berkus 18:10
Want to test beta, but ... Josh Berkus 18:31
Re: Want to test beta, but ... Joe Conway 18:59
Re: Want to test beta, but ... Josh Berkus 19:04
How to select and result row number?? Yudie 19:17
does table names have a format and size jaya prakash 23:04
"Inverting" a table, OLAP-style pacquet 23:18

Sept. 14, 2002

Thread Author Time
Re: Timestamp Fractions Problem Tom Lane 03:35
Re: Table alias in DELETE statements Christopher Kings-Lynne 06:07
Re: sql group by statement Tom Lane 15:03
cross tab (pivtor table) sql shahbaz 22:53

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

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