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

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
Re: problem with sql D'Arcy J.M. Cain 10:35

June 2, 2002

Thread Author Time
alternate idioms for large "IN (...)" lists russm 06:10
Re: alternate idioms for large "IN (...)" lists Christopher Kings-Lynne 18:01

June 3, 2002

Thread Author Time
to_date() Paul 00:53
Re: Syntax error in plpgsql crashes backend Bruce Momjian 04:00
Re: alternate idioms for large "IN (...)" lists russm 06:45
How to update Andre Schubert 08:00
Re: How to update Manfred Koizar 13:08
Re: How to update Andre Schubert 13:46
Re: to_date() Kaare Rasmussen 16:04
Re: Syntax error in plpgsql crashes backend Joseph D. Barillari 18:02
passing a list to a function and returning a recordset Marie G. Tuite 21:14
passing a list to a function and returning a recordset Marie G. Tuite 21:43
Re: alternate idioms for large "IN (...)" lists Tom Lane 23:38

June 4, 2002

Thread Author Time
Postgres Function Problem Sandeep Chibber 06:52
Re: Postgres Function Problem Achilleus Mantzios 07:39
Is this a feature ? David BOURIAUD 08:18
new itoar function Achilleus Mantzios 08:18
Re: Is this a feature ? Achilleus Mantzios 08:32
Re: new itoar function Oleg Bartunov 10:10
Re: Is this a feature ? Jan Wieck 14:33
Re: Is this a feature ? Nick Fankhauser 14:38
Re: Is this a feature ? David BOURIAUD 14:55
Re: Is this a feature ? James Orr 15:14
Re: Is this a feature ? Joel Burton 17:26
Updating a table from another table Matthew Price 20:37
Re: Updating a table from another table Jean-Luc Lachance 21:38
Some problems with (my?) PlSQL Rui Pacheco 22:02
Re: Some problems with (my?) PlSQL Stephan Szabo 22:18
alter column - NOT NULL Tom Haddon 23:04
Re: Some problems with (my?) PlSQL Rui Pacheco 23:26

June 5, 2002

Thread Author Time
pgsql/doc/TODO.detail mmap Bruce Momjian - CVS 04:01
Postgres Function Proble Sandeep Chibber 04:13
Re: Further info : Very high load average but no cpu utilization Bruce Momjian 16:33
Indexing Metaphone? Josh Berkus 18:12
extract and variables in PL/pgSQL Roberto Mello 18:20
Re: Indexing Metaphone? Richard Poole 18:39
Getting PID of current logged user Roberto Mello 18:40
Re: Indexing Metaphone? Josh Berkus 18:53
Re: Indexing Metaphone? Stephan Szabo 19:15

June 6, 2002

Thread Author Time
Re: simple select statement inquiry Ludwig Lim 03:33
Indexing timestamps Andre Schubert 08:45
Re: PostgreSQL on AIX D'Arcy J.M. Cain 10:34
Re: how to reset serials Bruno Wolff III 11:48
Re: extract and variables in PL/pgSQL Jan Wieck 12:20
Re: PostgreSQL on AIX Travis Hoyt 12:47
simple select statement inquiry Joseph Syjuco 14:59
Re: Indexing timestamps Josh Berkus 16:02
Re: extract and variables in PL/pgSQL Roberto Mello 16:10
Re: simple select statement inquiry Joel Burton 16:49
Re: Indexing timestamps Stephan Szabo 17:01
TWO PROBLEMS Ricardo Javier Aranibar León 17:03
Re: Indexing timestamps Josh Berkus 17:41
Old documentation Wei Weng 20:17
Re: Old documentation Manfred Koizar 20:52
Re: Indexing timestamps Stephan Szabo 22:33

June 7, 2002

Thread Author Time
how to reset serials Joseph Syjuco 00:03
Re: how to reset serials Joseph Syjuco 00:51
Re: PL/pgSQL TODO Bruce Momjian 04:19
UPDATE ... FROM vs standard SQL Richard Huxton 10:33
Re: arrays as pgsql function parameters Achilleus Mantzios 11:23
Re: arrays as pgsql function parameters Achilleus Mantzios 13:33
select failure Ian Cass 13:44
Re: arrays as pgsql function parameters Joseph Syjuco 14:08
Re: UPDATE ... FROM vs standard SQL Jan Wieck 14:20
Re: [HACKERS] PostgreSQL on AIX Zeugswetter Andreas SB SD 14:23
Re: PL/pgSQL TODO Josh Berkus 15:14
Re: UPDATE ... FROM vs standard SQL Josh Berkus 15:20
Re: PL/pgSQL TODO Josh Berkus 15:21
Re: PL/pgSQL TODO 📎 Bruce Momjian 15:33
Re: PL/pgSQL TODO Josh Berkus 15:38
Re: arrays as pgsql function parameters Josh Berkus 15:53
Re: PL/pgSQL TODO 📎 Bruce Momjian 15:53
Re: UPDATE ... FROM vs standard SQL Richard Huxton 16:05
Re: UPDATE ... FROM vs standard SQL Stephan Szabo 16:38
Re: PL/pgSQL TODO Jan Wieck 18:10
Re: UPDATE ... FROM vs standard SQL Josh Berkus 18:50
Limiting database size Maurício Sessue Otta 19:11
Re: PL/pgSQL TODO Bruce Momjian 19:55
multiple primary keys and reference Matt 20:00
encryp pass Ricardo Javier Aranibar León 20:23
Re: passing a list to a function and returning a recordset Marie G. Tuite 20:32

Browse Archives

Prev | Next