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

Nov. 27, 2001

Thread Author Time
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

Dec. 3, 2001

Thread Author Time
Re: problems with single quotes.. postgresql 03:20
ODBC queries die; "Unexpected protocol character from backend" Steve Frampton 05:03
Re: problems with single quotes.. Stephan Szabo 05:23
Inline IF condition Tapan Trivedi 12:04
update with RE Vigny Christophe 13:37
Re: persistent connections, AOLserver (Was: maybe Offtopic : Stephan Szabo 19:07
Re: Need help with a college SQL exam question... Josh Berkus 19:13
Re: An easy question about creating a primary key Stephan Szabo 19:16
Re: An easy question about creating a primary key Josh Berkus 19:20
Re: Error in executing plpgsql function Tom Lane 19:23

Dec. 4, 2001

Thread Author Time
Re: An easy question about creating a primary key Christopher Kings-Lynne 01:36
Re: An easy question about creating a primary key Tom Lane 02:12
Re: [SQL] An easy question about creating a primary key Christopher Kings-Lynne 02:23
Re: [SQL] An easy question about creating a primary key Tom Lane 02:29
Re: [SQL] An easy question about creating a primary key Tom Lane 02:40
Re: [SQL] An easy question about creating a primary key Christopher Kings-Lynne 02:50
Re: [SQL] An easy question about creating a primary key Tom Lane 02:54
Re: creating a primary key Keith Gray 05:16
Re: Error in executing plpgsql function ananth 05:23
Re: need some help understanding sloq query Arian Prins 08:31
Re: Need help with a college SQL exam question... Arian Prins 08:54
problems with this wiew Manuel Trujillo 11:10
Re: update returns 1, but no changes have been made James Thornton 11:57
Re: update returns 1, but no changes have been made James Thornton 13:29
Re: Need help with a college SQL exam question... Roland Roberts 14:47
Re: need some help understanding sloq query Josh Berkus 17:09
Re: problems with this wiew Stephan Szabo 18:07
make query faster?? DI Hasenöhrl 20:58
Re: make query faster?? Stephan Szabo 21:26
Memory exhausted in AllocSetAlloc(269039) Jeff Barrett 21:36
Re: problems with this wiew Aasmund Midttun Godal 22:31
Re: Memory exhausted in AllocSetAlloc(269039) Tom Lane 22:43

Dec. 5, 2001

Thread Author Time
plpgsql before insert update delete kiyo taka 05:47
Re: make query faster?? DI Hasenöhrl 08:52
Any patch for delete and insert same row in a function ( transaction ) MindTerm 10:37
Fw: Creating Postgres DB from Remote Machine Dinesh Parikh 12:07
how to chane the type tinar 13:12
Cursor Variables Alex 14:56
Re: problems with this wiew Masaru Sugawara 15:07
Re: problems with this wiew Masaru Sugawara 15:16
Re: Memory exhausted in AllocSetAlloc(269039) Roberto Mello 15:55
Re: Memory exhausted in AllocSetAlloc(269039) Tom Lane 16:48
Re: Any patch for delete and insert same row in a function ( Stephan Szabo 18:14
Re: Any patch for delete and insert same row in a function ( transaction Bruce Momjian 18:16
Re: Any patch for delete and insert same row in a function ( transaction Bruce Momjian 18:17
Re: make query faster?? Stephan Szabo 18:28
Getting matching and non-matching results (long) Roberto Mello 19:37
INT OR VARCHAR Martín Marqués 20:41
Re: INT OR VARCHAR Aasmund Midttun Godal 21:03
Re: Getting matching and non-matching results (long) Stephan Szabo 21:07
Re: INT OR VARCHAR Martín Marqués 21:19
Re: PL/pgSQL examples NOT involving functions Jan Wieck 21:26
Re: PL/pgSQL examples NOT involving functions Jan Wieck 21:29
Re: Getting matching and non-matching results (long) Roberto Mello 21:54
Re: Getting matching and non-matching results (long) Stephan Szabo 22:05

Dec. 6, 2001

Thread Author Time
Select into Christopher Kings-Lynne 03:01
Re: Select into Bruce Momjian 04:10
Re: Select into Stephan Szabo 04:18
Re: need some help understanding sloq query Esger Abbink 13:34
Re: Inline IF condition Roberto Mello 15:48
Re: need some help understanding sloq query Stephan Szabo 16:25
Re: how to chane the type Stephan Szabo 16:31
Re: update returns 1, but no changes have been made Gregory Wood 18:24
type casting bpchar Joachim Trinkwitz 18:33
Re: update with RE 20:05
view rules Oleg Lebedev 20:17
Re: update returns 1, but no changes have been made Gregory Wood 20:37
Re: view rules Ross J. Reedstrom 21:32
Re: Select into Jean-Michel Chabanne 21:43
Re: view rules Oleg Lebedev 22:14
Re: Inline IF condition Keith Gray 22:42
Trigger for logging stuff... Larry Rosenman 23:02
Re: type casting bpchar Stephan Szabo 23:18
Trigger for logging stuff... Larry Rosenman 23:36

Dec. 7, 2001

Thread Author Time
Re: how to chane the type Christopher Kings-Lynne 01:45
Re: how to chane the type Stephan Szabo 02:05
Re: [SQL] how to change the type Christopher Kings-Lynne 02:09
Re: [SQL] how to change the type Stephan Szabo 02:41
Replacing "LIKE" with "=" sharmad 03:46
anyone can help? Melisa 06:05
Re: [SQL] how to change the type Tom Lane 15:36
Vacuum analyze decreases speed 📎 David M. Richter 15:39
Re: Vacuum analyze decreases speed Tom Lane 17:11
Just comments about math Edipo Elder Fernandes de Melo 17:34
DISCTINCT and literals - Unable to identify an ordering operator mcornell 18:40
serial sequences not automatically dropped mcornell 18:44
Variable Length Binary String (not large) Jonathan Nichols 21:14
Re: [SQL] how to change the type Stephan Szabo 21:41
How to rename a database? Ligia Pimentel 22:06

Dec. 8, 2001

Thread Author Time
Re: plpgsql before insert update delete Ian Barwick 03:01

Dec. 9, 2001

Thread Author Time
Poolman/mySQL transaction exception on connect Dominic Da Silva 20:29

Dec. 10, 2001

Thread Author Time
Re: [SQL] how to change the type Christopher Kings-Lynne 02:32
Can anybody help me with SQL? Richard Lockwood 08:42
Re: Trigger for logging stuff... Bruce Momjian 10:33
Re: Just comments about math Andrew G. Hammond 15:12
Re: anyone can help? Nick Fankhauser 18:10
Re: Can anybody help me with SQL? Andrew Bell 18:10
Re: anyone can help? Roberto Mello 19:08
Re: Poolman/mySQL transaction exception on connect Jason Earl 19:11
Re: anyone can help? Jason Earl 19:33
Re: Poolman/mySQL transaction exception on connect Josh Berkus 19:38
Re: Replacing "LIKE" with "=" Josh Berkus 19:43
postgresql v 7.1.3 error Ivan Manuel Andrade Muñoz 19:48
Re: serial sequences not automatically dropped Stephan Szabo 21:09
Re: [SQL] Can anybody help me with SQL? Stephan Szabo 21:33

Browse Archives

Prev | Next