pgsql-sql since 2002-05-15 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

May 15, 2002

Thread Author Time
Re: order by <something wierd> Christopher Kings-Lynne 02:06
Re: date_part, how to use Christopher Kings-Lynne 02:07
Re: date_part, how to use Joel Burton 03:23
Re: date_part, how to use Christopher Kings-Lynne 03:31
some questions Ang Tun Chek 04:49
Re: CHECK CONSTRAINT blunder(s) 📎 Christopher Kings-Lynne 05:23
Re: some questions Christopher Kings-Lynne 09:22
Re: some questions Adam Witney 09:23
Re: Various PostgreSQL questions Marc SCHAEFER 10:00
Help on indexes Stephane DEWITTE 12:08
Re: some questions Roberto Mello 14:49
Re: Help on indexes Josh Berkus 15:19

May 16, 2002

Thread Author Time
Rules and Triggers Ludwig Lim 04:59
how to build this list ? juerg.rietmann 12:38
Re: Rules and Triggers Josh Berkus 15:12
trigger question Larry Rosenman 17:38
Re: trigger question Josh Berkus 17:49
Re: trigger question Larry Rosenman 17:51
Re: trigger question Josh Berkus 18:05
Re: trigger question Scott Shattuck 18:33
Constraint problem Josh Berkus 18:48
SQL over my head... Gregory Brauer 19:10
Re: Constraint problem Stephan Szabo 19:11
Re: Constraint problem Josh Berkus 19:12
Re: Constraint problem Josh Berkus 19:30
Re: SQL over my head... Joel Burton 20:14
Re: SQL over my head... Joel Burton 20:21
Re: SQL over my head... Gregory Brauer 20:39
Re: Constraint problem Stephan Szabo 20:39
Re: SQL over my head... Joel Burton 20:43
Re: Constraint problem Josh Berkus 20:49
How can I tell the performance difference? Josh Berkus 21:29
Re: SQL over my head... Gregory Brauer 21:54
Re: How can I tell the performance difference? Joe Conway 22:22

May 17, 2002

Thread Author Time
Re: Constraint problem Stephan Szabo 01:12
Re: Constraint problem Christopher Kings-Lynne 02:22
Re: Constraint problem Josh Berkus 04:40
Re: how to build this list ? Masaru Sugawara 16:51
Re: Rules and Triggers Jan Wieck 18:19
Re: Constraint problem Stephan Szabo 18:42
Rules and variables? Christian Rishoej 23:39
Re: Rules and variables? Josh Berkus 23:53

May 18, 2002

Thread Author Time
PL/pgSQL TODO Josh Berkus 00:19
Re: PL/pgSQL TODO Tom Lane 02:04
Casting timestamp Edipo E. F. Melo 23:54

May 19, 2002

Thread Author Time
Re: Casting timestamp Joel Burton 13:43
count(boolean) Dan MacNeil 14:16
Re: count(boolean) Joel Burton 14:58
A proposal for Interval Math Josh Berkus 20:36
Re: Casting timestamp Edipo E. F. Melo 20:43
Re: A proposal for Interval Math Oliver Elphick 20:58
Re: A proposal for Interval Math Josh Berkus 21:21

May 20, 2002

Thread Author Time
Re: A proposal for Interval Math Oliver Elphick 07:54
Using LASTOID in one query Eckhard Hoeffner 14:08
Re: Using LASTOID in one query Joel Burton 14:24
Re: count(boolean) Jean-Luc Lachance 15:08
Re: Using LASTOID in one query Masaru Sugawara 15:31
Re: A proposal for Interval Math Josh Berkus 16:03
Re: count(boolean) Jean-Luc Lachance 16:07
Re: Using LASTOID in one query Eckhard Hoeffner 16:10
Re: A proposal for Interval Math Oliver Elphick 18:35
[INIMSS] problem with user privileges Dino 18:36
Guarantee uniqueness of PGP key andre 20:17
Bug with Daylight Savings Time & Interval Josh Berkus 22:34

May 21, 2002

Thread Author Time
Re: [SQL] Guarantee uniqueness of PGP key Joel Burton 00:21
Re: MacOS X Shared Buffers (SHMMAX)? Steve Lane 01:59
MacOS X Shared Buffers (SHMMAX)? Command Prompt, Inc. 02:25
Re: Guarantee uniqueness of PGP key D. Duccini 02:37
Re: [SQL] Bug with Daylight Savings Time & Interval Tom Lane 02:47
Re: MacOS X Shared Buffers (SHMMAX)? Tom Lane 03:09
Re: [SQL] Bug with Daylight Savings Time & Interval Josh Berkus 05:57
drop constraint problem Wolfgang.Fuertbauer 07:12
constraints for ensuring relationships Markus Wagner 10:08
Re: Guarantee uniqueness of PGP key Bruno Wolff III 11:54
Re: Guarantee uniqueness of PGP key andre 11:56
Re: drop constraint problem Joel Burton 13:10
Re: constraints for ensuring relationships Stephan Szabo 14:43
Re: [SQL] Bug with Daylight Savings Time & Interval Thomas Lockhart 15:24
Re: [SQL] Bug with Daylight Savings Time & Interval Josh Berkus 16:05
Re: [SQL] Bug with Daylight Savings Time & Interval Thomas Lockhart 16:19
Re: A proposal for Interval Math Josh Berkus 16:30
Turning column into row tille 20:42

May 22, 2002

Thread Author Time
Re: drop constraint problem Christopher Kings-Lynne 02:59
Turning column into row Tille, Andreas 07:35
Re: Turning column into row Oliver Elphick 09:56
Re: Turning column into row Tille, Andreas 10:28
Re: Turning column into row Gabriel Dovalo Carril 11:17
Compatibility Issue of CREATE RULE in 7.2 Bhuvan A 12:16
Compatibility Issue of CREATE RULE in 7.2 Bhuvan A 12:24
Re: Turning column into row Wm. G. Urquhart 12:40
Re: Turning column into row Tille, Andreas 12:48
Re: Turning column into row Joel Burton 13:11
Re: Turning column into row Joel Burton 13:14
Re: Turning column into row Tille, Andreas 13:25
Re: Compatibility Issue of CREATE RULE in 7.2 Tom Lane 13:55
Re: Bug with ORDER BY expression [ ASC | DESC ] ? Tom Lane 13:56
Re: Turning column into row Wm. G. Urquhart 14:00
Re: Turning column into row (More...) Wm. G. Urquhart 14:06
Re: Turning column into row Tille, Andreas 14:36
Re: [SQL] Bug with Daylight Savings Time & Interval Oliver Elphick 14:45
Bug with ORDER BY expression [ ASC | DESC ] ? Christoph Haller 15:17
Re: Bug with ORDER BY expression [ ASC | DESC ] ? Christoph Haller 16:01
Re: Turning column into row Wm. G. Urquhart 16:13
Re: MacOS X Shared Buffers (SHMMAX)? Gregory Seidman 17:02
Re: MacOS X Shared Buffers (SHMMAX)? Tom Lane 17:20
Speeding up SELECT MAX(),... GROUP BY ... ? Christoph Haller 17:25
Re: MacOS X Shared Buffers (SHMMAX)? Command Prompt, Inc. 17:30
Re: MacOS X Shared Buffers (SHMMAX)? Command Prompt, Inc. 18:57
Re: Speeding up SELECT MAX(),... GROUP BY ... ? Josh Berkus 23:48

May 23, 2002

Thread Author Time
Compatibility Issue of CREATE RULE in 7.2 Bhuvan A 05:57
Re: Further info : Very high load average but no cpu utilization ? Denis 08:18
Re: Turning column into row Tille, Andreas 09:24
Functions with dynamic queries Gabriel Dovalo Carril 10:34
[No subject] rhema 11:27
Re: Turning column into row Joel Burton 12:56
Re: Further info : Very high load average but no cpu utilization ? Rajesh Kumar Mallah. 13:26
Re: Rajesh Kumar Mallah. 13:41
Re: Functions with dynamic queries Rajesh Kumar Mallah. 13:44
Re: MacOS X Shared Buffers (SHMMAX)? Nigel J. Andrews 14:09
Re: MacOS X Shared Buffers (SHMMAX)? Tom Lane 14:49
Re: Bruno Wolff III 15:24
Re: Functions with dynamic queries Gabriel Dovalo Carril 20:48
Re: Functions with dynamic queries Jeff Eckermann 22:40
Re: Functions with dynamic queries Jeff Eckermann 22:43
Re: Functions with dynamic queries Gabriel Dovalo Carril 23:37

May 24, 2002

Thread Author Time
Re: Functions with dynamic queries Gabriel Dovalo Carril 08:24
Re: Functions with dynamic queries Rajesh Kumar Mallah. 11:53
Re: Functions with dynamic queries Jeff Eckermann 13:51
Efficiency question: VARCHAR with empty string vs NULL Doug Fields 17:20
Trees in SQL Gregory Brauer 18:08
Re: Trees in SQL Gregory Brauer 18:34
Re: Trees in SQL Douglas Trainor 18:41
Re: Efficiency question: VARCHAR with empty string vs NULL Tom Lane 18:54
Re: Efficiency question: VARCHAR with empty string Doug Fields 19:10
Re: Trees in SQL Ron Peterson 19:28
Re: Trees in SQL Oleg Bartunov 20:46

May 25, 2002

Thread Author Time
Re: Trees in SQL Christopher Kings-Lynne 00:04
Re: Functions with dynamic queries 📎 Gabriel Dovalo Carril 01:11

May 26, 2002

Thread Author Time
XSD to Postgresql SQL Julian Scarfe 10:00
XSD to Postgresql SQL Julian Scarfe 10:10
Re: Functions with dynamic queries Rajesh Kumar Mallah. 10:25
uinique identifier ||//::..-cwhisperer-..:://|| 10:53
Re: uinique identifier Stephan Szabo 15:52

May 27, 2002

Thread Author Time
Re: uinique identifier Christopher Kings-Lynne 01:35
Problem with the result set of postgres Sandeep Chibber 07:22
Re: Trees in SQL Achilleus Mantzios 12:00
Re: Trees in SQL Rajesh Kumar Mallah. 12:57
Some additional PostgreSQL questions Marc SCHAEFER 14:12
dynamic table names, determined by calling parameter Michael Beckstette 16:07
Re: Trees in SQL Christopher Kings-Lynne 18:24
Re: Some additional PostgreSQL questions Tom Lane 20:06
Re: Trees in SQL Josh Berkus 20:06
Triggers and System Tables. Stef Telford 22:46
Re: Problem with the result set of postgres Joe Conway 23:18

May 28, 2002

Thread Author Time
Re: Triggers and System Tables. Stephan Szabo 05:29
Re: Triggers and System Tables. Stef Telford 05:35
Re: Triggers and System Tables. Stephan Szabo 06:51
Re: Some additional PostgreSQL questions schaefer 07:40
Problem with the result set of postgres Sandeep Chibber 09:11
Re: Triggers and System Tables. Jan Wieck 14:35
Re: Some additional PostgreSQL questions Tom Lane 14:38
dynamic table names, determined by calling parameter Michael Beckstette 14:43
Creation of a table with dynamic name from inside a pgpsql function Michael Beckstette 15:53
Re: Functions with dynamic queries Jeff Eckermann 17:04
Re: Creation of a table with dynamic name from inside a pgpsql function Tom Lane 17:33
Re: Functions with dynamic queries Gabriel Dovalo Carril 18:24
query system tables to find columns unique constraint is constraining? Beth Gatewood 18:47
Re: query system tables to find columns unique constraint is constraining? Tom Lane 19:10
Re: query system tables to find columns unique constraint is constraining? Christopher Kings-Lynne 21:12

May 29, 2002

Thread Author Time
Can you help with this JOIN? Wei Weng 16:06
Re: Trees in SQL achill 16:19
Re: Can you help with this JOIN? Wei Weng 16:21
contrib/tree issues achill 16:35
Re: Can you help with this JOIN? Tom Lane 16:37
Re: Can you help with this JOIN? Stephan Szabo 17:18
Re: contrib/tree issues Oleg Bartunov 17:23
Re: contrib/tree issues Achilleus Mantzios 17:33
Re: contrib/tree issues Achilleus Mantzios 17:38
Re: contrib/tree issues Oleg Bartunov 20:06

May 30, 2002

Thread Author Time
question on JOIN and WHERE clause Wei Weng 17:07
Re: Can you help with this JOIN? Wei Weng 17:11
Re: Can you help with this JOIN? Wei Weng 17:16
Re: Can you help with this JOIN? Stephan Szabo 17:35
Re: Can you help with this JOIN? Tom Lane 17:41
Math Huh? Josh Berkus 23:29
Re: Math Huh? Larry Rosenman 23:42
Re: Math Huh? Tom Lane 23:43
Re: Math Huh? David Stanaway 23:48
Re: Math Huh? Josh Berkus 23:59

May 31, 2002

Thread Author Time
Re: Math Huh? Larry Rosenman 00:36
Postgres Function Call Problem Sandeep Chibber 05:22
Re: Math Huh? Achilleus Mantzios 06:36
contrib/intarray Achilleus Mantzios 08:18
Re: question on JOIN and WHERE clause Henshall, Stuart - WCP 08:50
Re: contrib/intarray Oleg Bartunov 11:10
http://www.postgresql.org/idocs/ PROBLEM! Achilleus Mantzios 12:36
Re: http://www.postgresql.org/idocs/ PROBLEM! Marc G. Fournier 14:57

June 1, 2002

Thread Author Time
problem with sql Ricardo Javier Aranibar León 00:32
Any way to handle exceptions in PL/pgSQL ? Jorg Janke 04:11
Re: Any way to handle exceptions in PL/pgSQL ? PG Explorer 10:01

Browse Archives

Prev | Next