pgsql-sql since 2003-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, 2003

Thread Author Time
Re: function prepared plan Tom Lane 02:45
MIN function problem with Postgres7.3 Prashanth - Kamath 03:01
Re: Can arrays reference primary keys in CREATE TABLE? Luis Sousa 09:10
Re: Can arrays reference primary keys in CREATE TABLE? Jan Wieck 10:56
Re: Testing castability of text to numeric Christoph Haller 12:51
Index Selection Problem phd9110 13:05
Re: Really simple SQL problem David W Noon 13:54
Re: function prepared plan Franco Bruno Borghesi 15:04
Re: function prepared plan Tom Lane 15:15
Re: function prepared plan Franco Bruno Borghesi 15:26
tablename as attribute in pgplsql Benoît Bournon 15:46
Re: Index Selection Problem Josh Berkus 16:12
numeric fields and null Don Park 18:40
numeric fields and null Don Park 20:17
Re: numeric fields and null Stephan Szabo 22:25
Re: numeric fields and null Guy Fraser 22:27
Re: numeric fields and null Franco Bruno Borghesi 22:40
Re: numeric fields and null Don Park 23:25

May 23, 2003

Thread Author Time
Re: numeric fields and null Rod Taylor 00:32
Re: tablename as attribute in pgplsql Rod Taylor 00:41
Re: Another sub-select problem... Rod Taylor 00:56
Re: Another sub-select problem... Joe Conway 01:10
Re: how to use an aggregate function Matthew Nuzum 01:14
Re: tablename as attribute in pgplsql Stephan Szabo 01:42
Re: Another sub-select problem... Stephan Szabo 01:47
Re: Referencing a column from another table in a different Stephan Szabo 01:48
Re: AS? Bruno Wolff III 01:48
Re: plpgsql recursion Rod Taylor 01:59
Re: numeric fields and null Alexey Dashevsky 05:51
language "plpgsql" does not exist Bruce Young 06:48
Re: Can arrays reference primary keys in CREATE TABLE? Oleg Bartunov 06:55
Re: see toast table Christoph Haller 07:25
Re: tablename as attribute in pgplsql Benoît Bournon 07:38
Re: language "plpgsql" does not exist Devrim GUNDUZ 09:43
Re: language "plpgsql" does not exist David Witham 09:45
Re: language "plpgsql" does not exist Richard Huxton 10:26
Re: Another sub-select problem... Christoph Haller 11:00
Re: language "plpgsql" does not exist Rod Taylor 11:10
Re: libpq program SELECT FOR UPDATE and TIMEOUT or CANCEL REQUEST Christoph Haller 11:16
Re: language "plpgsql" does not exist Oliver Elphick 11:18
Re: Inquiry From Form [pgsql] Christoph Haller 11:24
Re: language "plpgsql" does not exist Christoph Haller 11:28
Re: language "plpgsql" does not exist Victor Yegorov 11:32
Re: language "plpgsql" does not exist A.Bhuvaneswaran 12:27
Re: see toast table Jan Wieck 12:51
Re: see toast table Eric Anderson Vianet SAO 13:23
Re: language "plpgsql" does not exist Bruce Young 13:40
select lower('ÆØÅ ABC'); does not work as expected willy malth 14:33
Re: libpq program SELECT FOR UPDATE and TIMEOUT or CANCEL REQUEST Bruno Wolff III 15:08
pg_connect Johann Thoyer 15:12
Re: Can arrays reference primary keys in CREATE TABLE? Stephan Szabo 15:17
faster output from php and postgres Mukta Telang 15:39
Re: language "plpgsql" does not exist Achilleus Mantzios 15:43
Re: faster output from php and postgres scott.marlowe 16:04
Re: faster output from php and postgres Frank Bax 16:49
Re: faster output from php and postgres Lonnie VanZandt 17:26
Re: faster output from php and postgres scott.marlowe 17:53
Re: Can arrays reference primary keys in CREATE TABLE? Jan Wieck 18:09
Bad rowtype on PL/SQL Oracle -- does anyone know? Josh Berkus 18:15
Re: Inquiry From Form [pgsql] Achilleus Mantzios 18:29
Re: libpq program SELECT FOR UPDATE and TIMEOUT or CANCEL REQUEST Bruno Wolff III 20:32

May 24, 2003

Thread Author Time
Re: language "plpgsql" does not exist PeterKorman 00:43
Re: language "plpgsql" does not exist A.Bhuvaneswaran 04:44
Re: [SQL] noupcol code cleanup Bruce Momjian 04:45
Re: faster output from php and postgres Chadwick Rolfs 15:50
Re: faster output from php and postgres Chadwick Rolfs 17:02
Re: see toast table Jan Wieck 21:11
Re: faster output from php and postgres Bruno Wolff III 22:00

May 25, 2003

Thread Author Time
Re: faster output from php and postgres Frank Bax 02:01
Re: select lower('ÆØÅ ABC'); does not work as expected Tom Lane 03:07
Re: pg_connect Markus Bertheau 15:20
Re: tablename as attribute in pgplsql Stephan Szabo 16:07
Re: select lower('ÆØÅ ABC'); does Markus Bertheau 18:22
date interpolation Rob Wood 21:44
Quick question regarding indexes and NULLs in 7.3.3 -> 7.4 Josh Berkus 22:11
Re: Quick question regarding indexes and NULLs in 7.3.3 -> 7.4 Tom Lane 22:59

May 26, 2003

Thread Author Time
Re: date interpolation Rod Taylor 02:37
Using UPPER and TRIM (INDEX usage) Mintoo Lall 02:48
timestamp field - select error alexandre :: aldeia digital 12:44
Many-to-Many relation Mukta Telang 12:46
How to delete multiple rows from multiple joined tables Michael Mattox 13:48
Re: Many-to-Many relation Peter Childs 13:55
Re: How to delete multiple rows from multiple joined tables Tom Lane 16:55
Re: timestamp field - select error Tom Lane 18:08
Re: timestamp field - select error alexandre :: aldeia digital 19:17
Re: timestamp field - select error Tom Lane 20:18

May 27, 2003

Thread Author Time
postgresql and the industry DIB Walid 08:28
Re: Using UPPER and TRIM (INDEX usage) Christoph Haller 08:55
How can I use a name of table in attribute of function, I try PREPARE ... Benoît Bournon 11:53
Upgrade 7.2.3 -> 7.3 or more Benoît Bournon 12:44
Re: Many-to-Many relation Bruno Wolff III 13:07
discover a toast table name Eric Anderson Vianet SAO 13:23
Re: discover a toast table name Tom Lane 14:20
[Fwd: SQL book] Jodi Kanter 14:28
Perl Book Jodi Kanter 14:30
Help required on update query Vikas 14:37
alter column witdh Eric Anderson Vianet SAO 14:38
Re: Perl Book Andrew Perrin 14:40
PostgreSQL and industry walid.dib 14:55
Re: [Fwd: SQL book] Thomas Good 15:06
Re: alter column witdh Christoph Haller 15:07
Re: [SQL] Perl Book Wei Weng 15:11
Re: alter column witdh Frank Bax 15:17
Re: discover a toast table name Eric Anderson Vianet SAO 15:34
little doubt Eric Anderson Vianet SAO 15:37
Re: [Fwd: SQL book] Josh Berkus 15:53
Re: Perl Book Jeremy Buchmann 16:04
Re: [Fwd: SQL book] Josh Berkus 16:06
Re: little doubt Josh Berkus 16:12
Re: faster output from php and postgres Chadwick Rolfs 16:34
Re: little doubt Richard Huxton 16:44
Re: [SQL] faster output from php and postgres Richard Huxton 18:19
Re: [PHP] faster output from php and postgres Chadwick Rolfs 18:27
Re: faster output from php and postgres Rod Taylor 18:54
Re: [SQL] faster output from php and postgres Jean-Luc Lachance 19:35
Re: Many-to-Many relation Mukta A. Telang 20:03
Re: [SQL] faster output from php and postgres Chadwick Rolfs 20:29
Getting rid of accents.. mallah 20:55
Re: Getting rid of accents.. Randall Lucas 21:48
Re: Getting rid of accents.. Randall Lucas 21:52
Re: Getting rid of accents.. Ian Barwick 22:15
Empty queries guaranteed to work? Forest Wilkinson 22:53
Re: Getting rid of accents.. mallah 23:57

May 28, 2003

Thread Author Time
Re: [Fwd: SQL book] Ries van Twisk 06:54
Re: tablename as attribute in pgplsql Benoît Bournon 07:58
Re: plpgsql recursion Luis Sousa 09:03
Inheritance and Referencial Integrity Stuart 10:03
[No subject] Peter Lavender 11:28
Re: Getting rid of accents.. Jean-Luc Lachance 14:05
Re: Perl Book Robert Treat 18:24
schema-qualified permission problem Charlie Toohey 19:58
recursive srf Matthew Nuzum 21:30
Re: schema-qualified permission problem Tom Lane 23:47

May 29, 2003

Thread Author Time
The problems about temporary tables in V7.3.2 jack 00:17
Re: The problems about temporary tables in V7.3.2 Tom Lane 01:11
unsubscribe Mona Shah 09:08
How to undelete deleted data Abdul Wahab Dahalan 09:37
How To Recover Deleted Data Abdul Wahab Dahalan 09:51
Re: How to undelete deleted data Bruno Wolff III 11:21
Returning Multiple Values from CASE statement? C F 16:05
Re: How To Recover Deleted Data Brian Knox 16:09
"record" datatype - plpgsql Brian Knox 16:11
CREATE TABLES AS looses constraints Tiaan Wessels 16:35
Rows UPDATEd? David Olbersen 17:00
Index scan never executed? Chad Thompson 17:19
Re: Index scan never executed? Stephan Szabo 17:58
Re: Index scan never executed? Morten Tryfoss 18:24
Re: Rows UPDATEd? (solved!) David Olbersen 18:27
Re: Index scan never executed? Tom Lane 18:46
Re: "record" datatype - plpgsql George Weaver 19:01
Re: [SQL] faster output from php and postgres (one resolution) Chadwick Rolfs 19:53
Re: CREATE TABLES AS looses constraints Josh Berkus 20:48
Re: "record" datatype - plpgsql George Weaver 21:29
Re: "record" datatype - plpgsql Stephan Szabo 22:05

May 30, 2003

Thread Author Time
please helpme ? andhie lala 04:52
please help me ??? andhie lala 05:02
Re: please helpme ? Richard Huxton 06:25
Re: "record" datatype - plpgsql Brian Knox 12:52
Re: "record" datatype - plpgsql Tom Lane 13:50
Re: "record" datatype - plpgsql Jr. 14:38
SQL Help C F 15:47
SELECT statement within libpq David Klugmann 16:02
Re: SQL Help Bruno Wolff III 16:30
Re: SQL Help Josh Berkus 16:37
Re: CASE returning multiple values (was SQL Help) Richard Huxton 16:40
Re: SQL Help Franco Bruno Borghesi 17:12
Re: "record" datatype - plpgsql Sean Chittenden 17:12
Re: CASE returning multiple values (was SQL Help) Tom Lane 17:51
Re: CASE returning multiple values (was SQL Help) C F 18:01
Calculating with the time Katka a Daniel Dunajsky 18:04
Re: Index scan never executed? Chad Thompson 19:01
Dynamic views/permissions Raj Mathur 19:31
Re: Dynamic views/permissions Ian Barwick 20:35