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

Feb. 27, 2002

Thread Author Time
Re: Timestamp output Christopher Kings-Lynne 03:17
Left Outer Join Question Edward Murray 04:18
Re: Removing duplicates OV 04:52
Re: Left Outer Join Question Christopher Kings-Lynne 05:23
Re: Timestamp output Tom Lane 05:48
Bad design or SQL statment quandary grep 05:53
Re: Left Outer Join Question Tom Lane 05:55
Re: Left Outer Join Question Edward Murray 05:59
Re: Left Outer Join Question Christopher Kings-Lynne 06:04
Re: Left Outer Join Question Edward Murray 06:09
Re: Left Outer Join Question Stephan Szabo 06:55
Err. compiling func. with SET TRANS... otisg 07:33
INSERT requires SERIAL column? otisg 07:38
Re: INSERT requires SERIAL column? Christopher Kings-Lynne 07:50
Re: Err. compiling func. with SET TRANS... Christopher Kings-Lynne 07:54
Re: INSERT requires SERIAL column? D'Arcy J.M. Cain 08:51
Re: Bad design or SQL statment quandary Bruno Wolff III 13:21
Large Objects Hunter, Ray 13:45
implementation of a many-to-many relationship Dalton Shane 14:06
Re: Err. compiling func. with SET TRANS... otisg 14:18
Re: implementation of a many-to-many relationship Stephan Szabo 15:11
Re: implementation of a many-to-many relationship Dan Langille 15:15
System Messages Samuel J. Sutjiono 15:39
Re: implementation of a many-to-many relationship Josh Berkus 16:25
Re: implementation of a many-to-many relationship Jeff Self 18:04
Re: implementation of a many-to-many relationship Dan Langille 18:07
How slow is DISTINCT? Wei Weng 18:27
Re: System Messages Gregory Wood 19:14
Re: Large Objects postgresql 21:07
Re: How slow is DISTINCT? Dan Langille 21:30
Re: How slow is DISTINCT? Josh Berkus 21:45
Re: How slow is DISTINCT? Josh Berkus 22:54
Re: How slow is DISTINCT? Wei Weng 22:57
Re: How slow is DISTINCT? Wei Weng 23:20

Feb. 28, 2002

Thread Author Time
Re: Large Objects Christopher Kings-Lynne 01:05
Re: Large Objects Erle Czar Mantos 02:36
backward SQL query Jan Oravec 11:34
Re: backward SQL query Karel Zak 11:55
Re: How slow is DISTINCT? TimothyReaves 13:45
Stored procedures returning TEXT Céline Rivière 14:44
Re: backward SQL query Rajesh Kumar Mallah 15:41
CREATE FUNCTION and LANGUAGE 'C' Céline Rivière 15:44
GROUPing by expressions, and subSELECTs Shane Wright 18:29
LIKE with no wildcards problem John J. Allison 18:54
Re: LIKE with no wildcards problem Josh Berkus 19:28
Re: LIKE with no wildcards problem Ian Barwick 19:36
Re: LIKE with no wildcards problem Ross J. Reedstrom 19:46
Can't get rid of constraint Matthew Price 21:00
Re: Can't get rid of constraint Stephan Szabo 21:27
Re: GROUPing by expressions, and subSELECTs Tom Lane 21:40
Re: Left Outer Join Question Andy Marden 21:44
Re: Large Objects Alexander Steinert 22:56

March 1, 2002

Thread Author Time
Re: [SQL] Timestamp output Barry Lind 02:32
Re: SQL statement : list table details Marc Polatschek 09:54
Re: GROUPing by expressions, and subSELECTs Shane Wright 12:18
Re: Urgent, Many-to-many relationships.....HELP!!!! Dan Langille 14:23
About persistent connections... David BOURIAUD 14:54
About persistent connections... David BOURIAUD 15:29
Re: About persistent connections... Gary Stainburn 16:06
LIMIT and OFFSET Samuel J. Sutjiono 16:24
Re: About persistent connections... Josh Berkus 17:36
Re: sub SELECT Josh Berkus 17:42
sequential joins Oleg Lebedev 20:21
Re: sequential joins Josh Berkus 20:28
Re: sequential joins Oleg Lebedev 22:46
Re: sequential joins 📎 Josh Berkus 23:13
Re: sequential joins Tom Lane 23:43
Re: sequential joins Oleg Lebedev 23:47

March 2, 2002

Thread Author Time
arrays in stored procedures Dalton Shane 16:42
using LIMIT only on primary table Dan Langille 22:35
Re: [SQL] using LIMIT only on primary table daq 23:20
Re: using LIMIT only on primary table Tom Lane 23:22
Re: using LIMIT only on primary table Dan Langille 23:40

March 3, 2002

Thread Author Time
Index doesn't appear to be working. John Oakes 00:28
Re: using LIMIT only on primary table Masaru Sugawara 06:00
Re: Index doesn't appear to be working. Stephan Szabo 07:50
Re: Index doesn't appear to be working. Bruce Momjian 16:02
Re: Index doesn't appear to be working. Wei Weng 16:58
Re: Index doesn't appear to be working. Bruce Momjian 18:26
Re: Index doesn't appear to be working. Bruce Momjian 18:36
Re: Index doesn't appear to be working. Frank Bax 18:41
- Finding records in sequence John Oakes 19:27
Re: - Finding records in sequence Josh Berkus 20:55

March 4, 2002

Thread Author Time
thinking about versioning my database schema Janning Vygen 07:10
Re: About persistent connections... David BOURIAUD 07:49
Re: [SQL] thinking about versioning my database schema Dan Langille 07:51
confusing inheritance Andreas F. 11:46
Re: thinking about versioning my database schema Roberto Mello 13:09
Re: thinking about versioning my database schema Janning Vygen 13:49
Changing sequence cache Matthew Price 18:02
Re: Changing sequence cache Dan Langille 18:32
PL/pgsql 📎 Ismail Bouabdallah 18:32
Uniqueness of rule, constraint, and trigger names Tom Lane 19:24
Re: Uniqueness of rule, constraint, and trigger names Dan Langille 20:04
PL/pgSQL Syntax Problem Hubert Palme 20:34
Re: Uniqueness of rule, constraint, and trigger names Tom Lane 20:38
Re: Uniqueness of rule, constraint, and trigger names Tim Barnard 20:41
Re: Uniqueness of rule, constraint, and trigger names Dan Langille 20:43
Re: Uniqueness of rule, constraint, and trigger names Tom Lane 20:47
Re: Uniqueness of rule, constraint, and trigger names Dan Langille 20:50
Re: [HACKERS] Uniqueness of rule, constraint, and trigger names Rod Taylor 21:40
Re: Uniqueness of rule, constraint, and trigger names Stephan Szabo 22:13
Re: Uniqueness of rule, constraint, and trigger names Tom Lane 22:18
Re: Uniqueness of rule, constraint, and trigger names Stephan Szabo 22:51
Re: CREATE FUNCTION and LANGUAGE 'C' Tom Lane 22:58
Re: [INTERFACES] PL/pgSQL Syntax Problem Tom Lane 23:03
Re: Uniqueness of rule, constraint, and trigger names Josh Berkus 23:05
Re: Changing sequence cache Tom Lane 23:16

March 5, 2002

Thread Author Time
Re: [SQL] Timestamp output Thomas O'Dowd 02:13
Re: Uniqueness of rule, constraint, and trigger names Christopher Kings-Lynne 02:36
Re: Changing sequence cache Andrew G. Hammond 06:51
Re: thinking about versioning my database schema Matteo Beccati 08:13
simple problem Daniel Ordobas Bortolas 11:44
function error: ERROR:   fmgr_info: function 56664: cache lookup failed 📎 Ismail Bouabdallah 14:32
ERROR: fmgr_info: function 56664: cache lookup failed 📎 Ismail Bouabdallah 14:44
Re: PL/pgSQL Syntax Problem Ashley Clark 15:49
getting pid of backend Kovacs Zoltan 17:52
Re: getting pid of backend Josh Berkus 18:21
Re: PL/pgSQL Syntax Problem Hubert Palme 20:33
Re: getting pid of backend Kovacs Zoltan 22:49
Re: getting pid of backend Bruce Momjian 23:34
Re: getting pid of backend Tom Lane 23:37

March 6, 2002

Thread Author Time
Re: getting pid of backend Laszlo Tibor 10:46
inserting arrays from plpgsql. Bhuvan A 13:54
assigning values to arrays in plpgsql Bhuvan A 14:13
simple problem Daniel Ordobas Bortolas 15:08
SELECT currval within a transaction Frank Joerdens 17:01
Re: simple problem Stephan Szabo 18:20
Re: SELECT currval within a transaction Stephan Szabo 19:23
where not exists Llew 19:27
createlang pltclu <databasename> W. McCloud 19:31
Re: simple problem Hano de la Rouviere 19:34
Re: simple problem Tom Lane 20:06
Re: simple problem PG Explorer 20:13
Fun with SQL Josh Berkus 20:19
Re: where not exists Josh Berkus 20:25
Re: where not exists Jie Liang 20:29
Re: where not exists Llew 20:54
\d+ and \dd Thomas Good 20:56
Re: where not exists Llew 21:14
Re: \d+ and \dd Greg Sabino Mullane 22:49

March 7, 2002

Thread Author Time
Coalesce Get Duplicate Record 📎 Lonh SENG 09:30
How to grant a privilege on all tables or views or both of a database to someone? 📎 Eric Du 10:37
Re: \d+ and \dd Thomas Good 13:48
subquery involving 'now' jmycr 14:08
Re: confusing inheritance Stephan Szabo 15:49
Re: PL/pgSQL Syntax Problem daq 16:18
Re: How to grant a privilege on all tables or views or both of a database to someone? Paul Ogden 18:55
7.0.3 pg_dump -> segmentation fault! george young 20:17
Re: 7.0.3 pg_dump -> segmentation fault! Stephan Szabo 20:27
Re: psql question Josh Berkus 20:30
Re: How to grant a privilege on all tables or views or both of a database to someone? Andrew G. Hammond 20:40
Fw: Re: 7.0.3 pg_dump -> segmentation fault! george young 20:44
Re: How to grant a privilege on all tables or views or both of a database to someone? Paul Ogden 21:01
Bad Query?? Extremely slow response Patrick Hatcher 21:46
ALTER CONSTRAINT FOREIGN KEY Charles Hauser 21:53
Re: Fw: Re: 7.0.3 pg_dump -> segmentation fault! Tom Lane 22:24

March 8, 2002

Thread Author Time
Re: [NOVICE] Bad Query?? Extremely slow response Josh Berkus 01:28
Re: ERROR (Bug?) in RULE processing ? Bruce Momjian 01:29
Re: psql question Christopher Kings-Lynne 02:31
URGENT! VIRUS ALERT Carlo Florendo 06:57
Re: PL/pgSQL Syntax Problem rolf.ostvik 09:40
Re: Bad Query?? Extremely slow response Andrew McMillan 11:35
Help reqd: Copying char to date rjb26 11:38
REFERENCES Andre Schubert 12:28
Re: Help reqd: Copying char to date rjb26 13:26
'now' problem jmycr 14:13
problem with RECORD in a stored procedure Dalton Shane 15:06
Re: problem with RECORD in a stored procedure Stephan Szabo 16:16
Re: problem with RECORD in a stored procedure daq 17:53
Support for "nested sets" and PHP (Re: Recursive select) knut.suebert 18:38
Re: PL/pgsql PG Explorer 19:54
New user - creating function question TimothyReaves 20:16

March 9, 2002

Thread Author Time
Retrieving a ' in an SQL statement? Jdou12345 07:51
Line Numbering in SELRCT Output Hubert Palme 23:48

March 10, 2002

Thread Author Time
Re: Line Numbering in SELRCT Output Paul 15:33
Referential integrity implementation - bug or user error? msn 22:19

March 11, 2002

Thread Author Time
Re: Uniqueness of rule, constraint, and trigger names Peter Eisentraut 01:33
Re: Uniqueness of rule, constraint, and trigger names Thomas Lockhart 01:37
Case (in)sensitivity Roberto Mello 05:02
Re: Case (in)sensitivity Christopher Kings-Lynne 05:04
Re: Case (in)sensitivity Peter Eisentraut 05:18
Re: Case (in)sensitivity Joel Burton 07:28
Operator ~ on type aclitem in pgsql 7.2 karin probost 08:30
Re: PL/pgsql adm 10:39
Re: where not exists Dag Arne Matre 10:54
Timestamp with time zone problem Aguinaldo Fagundes Junior 14:37
Calling a trigger from a trigger Mike Finn 18:19
Pg_dump Hunter, Ray 19:45
Re: Pg_dump knut.suebert 21:37
Re: Line Numbering in SELRCT Output Hubert Palme 22:55

March 12, 2002

Thread Author Time
Re: Referential integrity implementation - bug or user error? Lee Harr 01:18
SELECT FOR UPDATE feblec 01:31
Re: SELECT FOR UPDATE Florian Weimer 09:18
GRANT problem ? GRIMOIS Eric 10:16
Re: GRANT problem ? PGMailList 11:58
Re: GRANT problem ? D'Arcy J.M. Cain 11:59
in-date news items Gary Stainburn 12:17
Re: in-date news items Ian Barwick 13:25
Re: in-date news items Gary Stainburn 17:19

Browse Archives

Prev | Next