pgsql-sql before 2001-12-03 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

Nov. 19, 2001

Thread Author Time
Re: [SQL] PL/pgSQL examples NOT involving functions Roland Roberts 03:57
Re: PL/pgSQL examples NOT involving functions Roland Roberts 04:00
Re: Foreign Key Constraint Deletion Order cnliou 07:17
Re: Optimization with dates Jean-Christophe Boggio 07:32
How to return more than one row of data from a function in PL/pgSQL dino ck 09:22
Re: Foreign Key Constraint Deletion Order Stephan Szabo 09:26
PqReadData() Gurudutt 10:42
Re: [SQL] PL/pgSQL examples NOT involving functions Aasmund Midttun Godal 13:51
How can I return more than one row of data from pl/pgsql Dino Cherian 13:57
Re: [OT?] permissions Peter Eisentraut 14:40
Re: PL/pgSQL examples NOT involving functions Roland Roberts 14:42
Re: persistent connections, AOLserver (Was: [SQL] maybe Offtopic : PostgreSQL & PHP ?) Roberto Mello 15:35
Re: [OT?] permissions Clayton Cottingham aka drfrog 17:20
Re: why does this query does not work?????? Josh Berkus 21:16
Re: why does this query does not work?????? Jeff Eckermann 21:42

Nov. 20, 2001

Thread Author Time
Re: Foreign Key Constraint Deletion Order cnliou 03:50
Re: Foreign Key Constraint Deletion Order Tom Lane 04:11
Re: [SQL] PL/pgSQL examples NOT involving functions Christopher Kings-Lynne 04:32
Re: How to use COPY in a function ? Tom Lane 04:40
Re: [DOCS] PL/pgSQL examples NOT involving functions Roland Roberts 05:00
Re: Foreign Key Constraint Deletion Order Stephan Szabo 08:07
Re: Foreign Key Constraint Deletion Order Stephan Szabo 08:09
Re: SELECT * FROM t where p or q; Stephan Szabo 08:10
When to connect and disconnect Connection Dino Cherian 10:10
Genetic algorithms Miguel Gonzalez 13:02
Rule Andriy Pyrozhenko 13:38
database cluster Jodi Kanter 13:39
Re: Rule Tom Lane 15:24
Re: Rule Andriy Pyrozhenko 15:31
Re: Genetic algorithms Bruce Momjian 15:33
Re: SELECT * FROM t where p or q; Tom Lane 15:40
Re: SELECT * FROM t where p or q; frbn 17:42
Re: SELECT * FROM t where p or q; Stephan Szabo 17:58
RULES Fábio Santana 23:56

Nov. 21, 2001

Thread Author Time
Re: SELECT * FROM t where p or q; Calvin Dodge 00:15
bug, I think Merrill Oveson 00:15
Re: Optimization with dates Calvin Dodge 00:28
Re: Postmaster will not start??? David Stanaway 02:07
Joins~ Gurudutt 08:37
Re: Joins~ Markus Bertheau 11:57
Re: RULES Patrick Welche 12:58
Stored Procedure Fernández Mariano 13:35
Re: ORDER BY question Masaru Sugawara 15:11
Re: [HACKERS] RULES Ross J. Reedstrom 15:57
Re: [HACKERS] RULES Stephan Szabo 16:43
Generate GUID in postgresql Wei Weng 23:46

Nov. 22, 2001

Thread Author Time
ldap support clayton cottingham 00:04
primary/foreigner keys Luis Miguel Campos 00:11
Re: PL/pgSQL examples NOT involving functions Andrew G. Hammond 01:09
Re: ORDER BY question Andrew G. Hammond 01:39
Porting Oracle Decode to Postgresql MindTerm 08:13
Re: Porting Oracle Decode to Postgresql Tod McQuillin 09:47
Re: Porting Oracle Decode to Postgresql MindTerm 09:54
Re: Porting Oracle Decode to Postgresql MindTerm 10:21
Re: Joins~ Gurudutt 10:40
How are working index with date ? Hervé Piedvache 11:57
"posttime" time DEFAULT now() Koen Antonissen 13:30
INDEXng date_trunc ... Marc G. Fournier 14:41
Re: ldap support Henshall, Stuart - WCP 15:20
Re: INDEXng date_trunc ... Brent Verner 15:29
Re: How are working index with date ? Stephan Szabo 17:01
Re: INDEXng date_trunc ... Tom Lane 17:29
Re: Generate GUID in postgresql Roberto Mello 21:01

Nov. 23, 2001

Thread Author Time
Re: "posttime" time DEFAULT now() Christopher Kings-Lynne 01:42
Re: Question Christopher Kings-Lynne 01:45
Re: SELECT * FROM t where p or q; Christopher Kings-Lynne 01:48
Re: database cluster Christopher Kings-Lynne 01:49
Re: Question Andriy Pyrozhenko 07:14
Re: How to return more than one row of data from a function in PL/pgSQL Andrew G. Hammond 07:29
Re: Question Christopher Kings-Lynne 07:33
Re: Question Andriy Pyrozhenko 07:55
Re: Joins~ Markus Bertheau 07:55
Re: Joins~ - Thanks a lot~ Gurudutt 08:11
How to find missing values in a sequence ? Joe McGuckin 09:44
Re: How to return more than one row of data from a function in PL/pgSQL Dino Cherian 12:20
Re: How to return more than one row of data from a Johnny Jrgensen 12:49
Re: "posttime" time DEFAULT now() Koen Antonissen 12:56
Re: PL/pgSQL examples NOT involving functions Aasmund Midttun Godal 14:47
Re: PL/pgSQL examples NOT involving functions Aasmund Midttun Godal 14:47
Re: How to return more than one row of data from a MindTerm 16:27
Re: primary/foreigner keys Stephan Szabo 18:38

Nov. 24, 2001

Thread Author Time
Re: Question Andrew G. Hammond 09:39
Re: Stored Procedure Andrew G. Hammond 09:48
Re: How to return more than one row of data from a function in PL/pgSQL Andrew G. Hammond 09:55

Nov. 25, 2001

Thread Author Time
Automaticly delete related data Trond Arve Nordheim 02:10
Re: Automaticly delete related data Stephan Szabo 04:06
How to create function with unspecified number of input parameters ? MindTerm 04:25
Re: How to create function with unspecified number of input parameters ? Tom Lane 04:49
Re: How to create function with unspecified number of input parameters Bruce Momjian 05:29
Re: How to create function with unspecified number of input parameters ? Tom Lane 05:38
Re: Automaticly delete related data Andrew G. Hammond 10:06
Re: How to create function with unspecified number of input Aasmund Midttun Godal 19:39

Nov. 26, 2001

Thread Author Time
Permissions on views bug. Aasmund Midttun Godal 00:30
Sequence permission suggestion Aasmund Midttun Godal 00:55
Re: Sequence permission suggestion Tom Lane 01:19
Exception When Insert Followed By Delete In PL/PGSQL cnliou 01:40
Re: Exception When Insert Followed By Delete In PL/PGSQL Tom Lane 01:53
Re: Sequence permission suggestion Aasmund Midttun Godal 05:52
hu.po Kovacs Zoltan 08:18
count(*) - join question Nicole S. Weber 23:03

Nov. 27, 2001

Thread Author Time
Re: PL/pgSQL examples NOT involving functions Josh Berkus 01:23
Queue in SQL Gyorgy Molnar 14:11
Re: count(*) - join question Richard Poole 14:25
Re: PL/pgSQL examples NOT involving functions Aasmund Midttun Godal 19:53
Re: PL/pgSQL examples NOT involving functions Aasmund Midttun Godal 19:55
Re: PL/pgSQL examples NOT involving functions Aasmund Midttun Godal 19:59
Complex query help please Glenn MacGregor 22:23

Nov. 28, 2001

Thread Author Time
Re: PL/pgSQL examples NOT involving functions Josh Berkus 00:01
Re: Complex query help please Josh Berkus 00:24
Re: PL/pgSQL examples NOT involving functions Stephan Szabo 00:32
Re: PL/pgSQL examples NOT involving functions cnliou 00:34
Re: hu.po Roberto Mello 01:10
Re: How can I return more than one row of data from pl/pgsql Saira Somani 01:10
Re: PL/pgSQL examples NOT involving functions Tom Lane 04:47
PL/pgSQL loops? Johnny Jørgensen 12:25
View question Glenn MacGregor 14:07
Re: Queue in SQL Markus Bertheau 14:19
PL/pgSQL loops? Johnny Jørgensen 14:40
Return Opaque / Error in Function Knud Müller 15:28
Re: View question James Orr 15:38
Re: PL/pgSQL loops? Stephan Szabo 16:24
email address for questions wHarouny 16:27
Re: PL/pgSQL loops? Tom Lane 16:49
Re: PL/pgSQL loops? Carl van Tast 17:52
Re: Queue in SQL Andrew G. Hammond 21:20
Re: email address for questions Andrew G. Hammond 21:24
Re: email address for questions Josh Berkus 21:29
Check for table existence Michael Knudsen 21:47

Nov. 29, 2001

Thread Author Time
Re: PL/pgSQL loops? Roberto Mello 01:32
Re: Queue in SQL Christopher Kings-Lynne 01:41
Re: PL/pgSQL loops? Johnny Jrgensen 02:05
distinct() vs distinct on () Haywood J'Bleauxmie 03:14
Re: PL/pgSQL loops? Stephan Szabo 03:53
Re: distinct() vs distinct on () Tom Lane 05:02
Re: PL/pgSQL loops? Tom Lane 06:08
Re: Return Opaque / Error in Function Tom Lane 06:15
date_part vs extract Markus Bertheau 08:45
Re: date_part vs extract Brent Verner 09:48
Fixing faulty dates - select on day part of a date field Gary Stainburn 11:31
Re: Fixing faulty dates - select on day part of a date field Markus Bertheau 12:06
Re: Fixing faulty dates - select on day part of a date field Patrik Kudo 12:13
Re: Fixing faulty dates - select on day part of a date field Gary Stainburn 14:00
Re: Check for table existence Alexander Steinert 14:17
Re: Fixing faulty dates - select on day part of a date field Markus Bertheau 14:36
Need help with a college SQL exam question... [email protected] 15:54
Re: Check for table existence Haller Christoph 15:58
Re: PL/pgSQL loops? Stephan Szabo 16:09
need some help understanding sloq query Esger Abbink 16:56
Re: PL/pgSQL loops? Tom Lane 17:02
Can I CONSTRAIN a particular value to be UNIQUE? Tony Reina 19:01
Re: date_part vs extract Peter Eisentraut 19:04
Re: date_part vs extract Bruce Momjian 19:14
Re: Can I CONSTRAIN a particular value to be UNIQUE? Stephan Szabo 19:59
Re: Can I CONSTRAIN a particular value to be UNIQUE? Tom Lane 20:38
Re: Can I CONSTRAIN a particular value to be UNIQUE? G. Anthony Reina 20:48
Re: Can I CONSTRAIN a particular value to be UNIQUE? G. Anthony Reina 21:05
Re: Can I CONSTRAIN a particular value to be UNIQUE? Tom Lane 21:11
Database Replicatio via triggers Peter 21:47
Re: CREATE RULE ON UPDATE/DELETE Bruce Momjian 22:17
Re: PL/pgSQL loops? Tom Lane 23:13
An easy question about creating a primary key Ligia Pimentel 23:22
contracting tables Peter T. Brown 23:50

Nov. 30, 2001

Thread Author Time
Re: Fixing faulty dates - select on day part of a date field Christopher Kings-Lynne 01:34
Re: Can I CONSTRAIN a particular value to be UNIQUE? Christopher Kings-Lynne 01:54
Re: Check for table existence Roberto Mello 02:05
Selecting from a dynamic name Jason Kwok 02:43
Re: Selecting from a dynamic name Christopher Kings-Lynne 03:37
Re: contracting tables Markus Bertheau 07:53
Re: contracting tables Christopher Kings-Lynne 08:51
Re: Fixing faulty dates - select on day part of a date field Gary Stainburn 09:19
Re: PL/pgSQL loops? Stephan Szabo 09:29
Logging Duncan Adams (DNS) 09:39
Re: [NOVICE] Logging Markus Bertheau 10:08
Any available solution to port CONNECT BY of oracle to postgresql MindTerm 10:20
Re: persistent connections, AOLserver (Was: maybe Offtopic : PostgreSQL & PHP ?) Steve Brett 10:23
Re: [NOVICE] Logging Duncan Adams (DNS) 12:39
variables in procedures Martín Marqués 13:43
Re: Logging Brett W. McCoy 15:04
Re: contracting tables Jeff Eckermann 15:38
Re: contracting tables Jeff Eckermann 15:45
Re: contracting tables Randal L. Schwartz 16:39
Re: variables in procedures Josh Berkus 17:09
Re: Any available solution to port CONNECT BY of oracle to postgresql Roberto Mello 17:33
Re: variables in procedures Stephan Szabo 17:34
Re: contracting tables Peter T. Brown 17:46
need some help understanding slow query (followup) Esger Abbink 19:20

Dec. 1, 2001

Thread Author Time
Re: contracting tables Tom Lane 05:21
Error in executing plpgsql function ananth 06:23
update returns 1, but no changes have been made James Thornton 09:44

Dec. 2, 2001

Thread Author Time
Unexpected Return from Function Anthony Bouvier 02:00
Re: Unexpected Return from Function Stephan Szabo 02:23
Re: problems with single quotes.. Horst Herb 07:44
Re: problems with single quotes.. Stephan Szabo 07:48
Re: problems with single quotes.. Joe Conway 14:52
Re: problems with single quotes.. Tom Lane 15:00
Re: Unexpected Return from Function Anthony Bouvier 20:43
Re: problems with single quotes.. postgresql 21:48
Re: contracting tables Roberto Mello 22:20
Re: problems with single quotes.. Stephan Szabo 22:21
Re: problems with single quotes.. Roberto Mello 22:25

Browse Archives

Prev | Next