pgsql-sql since 2002-05-27 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 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
Re: Limiting database size Tulio Oliveira 21:06
Re: Limiting database size Josh Berkus 21:42
arrays as pgsql function parameters Joseph Syjuco 23:57

June 8, 2002

Thread Author Time
Re: Indexing timestamps Bruce Momjian 02:48
Re: PostgreSQL on AIX Bruce Momjian 02:51
Re: PostgreSQL on AIX Bruce Momjian 02:51
Re: [HACKERS] PostgreSQL on AIX Bruce Momjian 02:53
Re: Indexing timestamps Stephan Szabo 04:15

June 9, 2002

Thread Author Time
Q: will GROUP BY make use of an index to return tuples early? Gunther Schadow 17:07
Support for distributed queries with semijoins could be possible, if ... Gunther Schadow 17:43
Re: select failure Gunther Schadow 18:10
Re: Q: will GROUP BY make use of an index to return tuples early? Tom Lane 18:57
Re: select failure Ian Cass 18:58
Re: Support for distributed queries with semijoins could be possible, if ... Tom Lane 19:00
Re: select failure Tom Lane 19:28
Re: select failure Gunther Schadow 20:01
Re: select failure Ian Cass 20:13

June 10, 2002

Thread Author Time
Rule to fill in value on column on insert Bradley Kieser 08:25
Re: Rule to fill in value on column on insert Christopher Kings-Lynne 08:44
VIEWs and FOREIGN keys Achilleus Mantzios 12:09
Re: Rule to fill in value on column on insert Tom Lane 13:22
Efficient DELETE Strategies Christoph Haller 13:42
Re: arrays as pgsql function parameters Joseph Syjuco 13:51
Re: Efficient DELETE Strategies Tom Lane 13:56
Re: multiple primary keys and reference Achilleus Mantzios 14:40
Re: multiple primary keys and reference Stephan Szabo 15:58
Re: [SQL] VIEWs and FOREIGN keys Stephan Szabo 16:10
Re: Efficient DELETE Strategies Bruce Momjian 16:48
Re: [SQL] VIEWs and FOREIGN keys Jan Wieck 17:20
Re: [HACKERS] Efficient DELETE Strategies Hannu Krosing 17:33
Re: [HACKERS] Efficient DELETE Strategies Bruce Momjian 18:33
Re: [SQL] VIEWs and FOREIGN keys terry 18:49
Re: [SQL] VIEWs and FOREIGN keys Jan Wieck 19:19
Re: [SQL] VIEWs and FOREIGN keys terry 19:43
Re: Temporary table weirdness Bruce Momjian 19:50
Re: Efficient DELETE Strategies Manfred Koizar 20:23
Re: [HACKERS] Efficient DELETE Strategies Tom Lane 20:34
Re: [SQL] VIEWs and FOREIGN keys Tom Lane 20:38
Re: Efficient DELETE Strategies Tom Lane 21:07
Re: Efficient DELETE Strategies Josh Berkus 22:41
Re: [HACKERS] Efficient DELETE Strategies Dann Corbit 23:08

June 11, 2002

Thread Author Time
Re: [HACKERS] Efficient DELETE Strategies Barry Lind 00:25
Re: [HACKERS] Efficient DELETE Strategies Bruce Momjian 02:53
Re: [HACKERS] Efficient DELETE Strategies Christopher Kings-Lynne 03:18
Re: [SQL] VIEWs and FOREIGN keys Achilleus Mantzios 06:44
Re: [HACKERS] Efficient DELETE Strategies Hannu Krosing 10:02
Re: Efficient DELETE Strategies Christoph Haller 11:18
Re: Efficient DELETE Strategies Tom Lane 14:28
Unicode and escaping single quotes Olaf Frączyk 15:19
inheritance problems Matt 16:19
Select * (but exclude columns) Adam 18:21
How to remove contraint Vernon Wu 19:57
Timestamp problem kumar 20:40
temporary tables Marie G. Tuite 23:07
Domains Andy Pearce 23:31
Re: temporary tables Bruce Momjian 23:33
make a unique index for foreign keys? Beth Gatewood 23:48

June 12, 2002

Thread Author Time
Re: make a unique index for foreign keys? Josh Berkus 00:24
Re: Unicode and escaping single quotes Tatsuo Ishii 06:01
Re: Unicode and escaping single quotes Olaf Frączyk 07:28
General trigger function GRIMOIS Eric 07:48

Browse Archives

Prev | Next