pgsql-sql since 2002-02-25 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next

Feb. 25, 2002

Thread Author Time
returning a record from a function? Jon Obuchowski 03:33
Re: returning a record from a function? Tom Lane 03:49
processing faster with plpgsql by passing in more data Dan Langille 05:30
Re: PLPGSQL func. defn. for returning resultset? Roberto Mello 14:55
Re: returning a record from a function? Roberto Mello 14:59
About referential integrity. BOURIAUD 15:01
[CHALLANGE] Add seconds to a date panjas51 16:16
Database Setup Hunter, Ray 16:36
Re: Tom Lane 16:48
Sort problem Samuel J. Sutjiono 17:17
Re: About referential integrity. Josh Berkus 17:21
Re: About referential integrity. Oliver Elphick 17:46
Re: PLPGSQL func. defn. for returning resultset? Jan Wieck 19:09
Re: [GENERAL] Sort problem Samuel J. Sutjiono 19:12
Re: About referential integrity. Peter Eisentraut 19:15
Re: [SQL] Sort problem Bruce Momjian 19:46
Re: [SQL] Sort problem Samuel J. Sutjiono 19:52
Re: Sort problem Oliver Elphick 20:01
Re: [SQL] Sort problem Bruce Momjian 20:03
Re: Sort problem Jean-Luc Lachance 21:53
record iteration within SQL Dan Langille 22:08
Re: Sort problem Tom Lane 23:09
Re: record iteration within SQL Tom Lane 23:45
Re: record iteration within SQL Dan Langille 23:52

Feb. 26, 2002

Thread Author Time
Timestamp operator error Josh Berkus 04:10
Re: Timestamp operator error Tom Lane 04:28
Re: Timestamp operator error Josh Berkus 04:34
Re: Timestamp operator error Tom Lane 04:47
Re: Timestamp operator error Josh Berkus 05:03
Re: Timestamp operator error Tom Lane 05:10
Re: Timestamp operator error Josh Berkus 05:20
Re: Timestamp operator error Tom Lane 05:31
Re: Timestamp operator error Josh Berkus 05:42
Re: Timestamp operator error Josh Berkus 06:13
transaction abortion Kancha . 06:35
Re: [SQL] transaction abortion Christopher Kings-Lynne 06:47
Re: [SQL] transaction abortion Kancha . 07:43
Re: About referential integrity. David BOURIAUD 07:51
Re: [SQL] transaction abortion Kancha . 07:51
Re: On delete cascade! Erle Czar Mantos 07:53
Re: About referential integrity. Christopher Kings-Lynne 08:02
Re: [SQL] query optimistaion problems Bradley Baetz 08:09
Re: transaction abortion Martijn van Oosterhout 08:17
Re: test the existence of a database Erle Czar Mantos 08:20
Re: test the existence of a database Jerome Alet 08:40
Timestamp output Matteo Beccati 09:36
Re: Timestamp output Christopher Kings-Lynne 14:39
Removing duplicates Matthew Hagerty 15:10
Re: Removing duplicates Andrew Perrin 15:44
Re: Timestamp output Tom Lane 15:55
Re: Removing duplicates Jeff Self 16:19
Re: Removing duplicates Josh Berkus 16:39
Re: Sort problem Jean-Luc Lachance 16:41
Re: Removing duplicates Dan MacNeil 16:44
Re: Removing duplicates Matthew Hagerty 17:16
Re: Join Statements Andy Marden 17:20
Re: Removing duplicates Christof Glaser 17:26
Re: Timestamp output Andreas Joseph Krogh 17:56
Re: [CHALLANGE] Add seconds to a date Frank Bax 19:38
Re: About referential integrity. Stephan Szabo 19:52
sub SELECT Charles Hauser 20:42
Urgent, Many-to-many relationships.....HELP!!!! Dalton Shane 20:45
Re: About referential integrity. Josh Berkus 21:08
Re: About referential integrity. Stephan Szabo 22:30

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

Browse Archives

Prev | Next