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

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
Re: Calculating with the time Guy Fraser 21:13
join/case jtx 23:03
Re: join/case Dmitry Tkach 23:53

May 31, 2003

Thread Author Time
Re: join/case Stephan Szabo 00:04
Re: [PERFORM] Yet Another (Simple) Case of Index not used Bruce Momjian 02:31
Re: join/case Bruno Wolff III 13:08

June 1, 2003

Thread Author Time
generic return for functions Danny Su 04:02
Re: generic return for functions Avi Schwartz 05:09
Re: generic return for functions Joe Conway 05:30
Re: Upgrade 7.2.3 -> 7.3 or more Rod Taylor 12:03
Re: generic return for functions Rod Taylor 12:21
Re: generic return for functions Avi Schwartz 15:21
Re: generic return for functions Tom Lane 15:46
Re: generic return for functions Avi Schwartz 16:15
Re: PostgreSQL and industry Josh Berkus 18:35
Re: generic return for functions Josh Berkus 18:45

June 2, 2003

Thread Author Time
SQL problem: bank account Erik G. Burrows 05:30
Re: SQL problem: bank account Andrew J. Kopciuch 06:13
Re: SQL problem: bank account Sean Chittenden 06:21
Re: SQL problem: bank account listrec 07:49
Re: CASE returning multiple values (was SQL Help) Richard Huxton 07:51
Re: SQL problem: bank account Jonathan Gardner 13:20
Using & - operator Rado Petrik 13:34
Re: SQL problem: bank account Tom Lane 13:42
Re: SQL problem: bank account Dmitry Tkach 14:28
Re: Using & - operator Dmitry Tkach 14:31
Maintaining a counter up-to-date Samuel Tardieu 15:47
Re: SQL problem: bank account Jonathan Gardner 16:40
Re: SQL problem: bank account Erik G. Burrows 16:58
Re: Maintaining a counter up-to-date Richard Huxton 18:27
Re: Maintaining a counter up-to-date Samuel Tardieu 18:29
Change owner of function in 7.2.4? Josh Berkus 22:49

June 4, 2003

Thread Author Time
How to make a IN without a table... ? David Pradier 14:59

June 5, 2003

Thread Author Time
EXTERN JOIN with WHEN query javier garcia - CEBAS 10:55
To ListAdms: Is pgsql-sql operating? Achilleus Mantzios 11:39
simulating partial fkeys.. mallah 14:55
Changing owner of function -- best method? Josh Berkus 15:06
Re: To ListAdms: Is pgsql-sql operating? Josh Berkus 16:25
Re: To ListAdms: Is pgsql-sql operating? Chad Thompson 21:28
Domains and Joins chester c young 21:38

June 6, 2003

Thread Author Time
(long) What's the problem? David Olbersen 00:45
Re: To ListAdms: Is pgsql-sql operating? Joerg Hessdoerfer 08:30
Re: simulating partial fkeys.. [ATTN Developers please] 📎 Richard Huxton 10:42
Re: simulating partial fkeys.. Jan Wieck 11:35
Re: simulating partial fkeys.. Bruno Wolff III 12:20
Re: Changing owner of function -- best method? Tom Lane 13:52
Re: Changing owner of function -- best method? Dmitry Tkach 14:42
Creating Views with Column Names based on Distinct Row Data Damien Dougan 14:59
Re: Approved pgman 15:37
Re: simulating partial fkeys.. Josh Berkus 15:58
(long) What's the problem? David Olbersen 16:23
Elegant SQL solution: Chris Gamache 16:26
"Join" on delimeter aggregate query Michael A Nachbaur 17:03
Re: simulating partial fkeys.. [ATTN Developers please] Stephan Szabo 17:04
Using a RETURN NEXT 22:14

June 7, 2003

Thread Author Time
Re: Column limits in table/ views Rod Taylor 13:48
Re: EXTERN JOIN with WHEN query Mendola Gaetano 18:05
Re: Column limits in table/ views Gaetano Mendola 18:08
Re: "Join" on delimeter aggregate query Eivind Kvedalen 21:06
Re: (long) What's the problem? Rod Taylor 23:57

June 8, 2003

Thread Author Time
Re: "Join" on delimeter aggregate query Joe Conway 01:03
Re: Elegant SQL solution: Josh Berkus 01:54
Re: Elegant SQL solution: greg 01:58
Re: How to make a IN without a table... ? Bruno Wolff III 11:11
Re: "Join" on delimeter aggregate query Bruno Wolff III 11:37
Re: Elegant SQL solution: Ian Barwick 11:54
Re: Domains and Joins Rod Taylor 12:23
Re: (long) What's the problem? Jan Wieck 15:08
Re: Using a RETURN NEXT Joe Conway 22:33

June 9, 2003

Thread Author Time
Re: "Join" on delimeter aggregate query Tom Lane 01:05
Re: "Join" on delimeter aggregate query Eivind Kvedalen 08:35
Retype Rado Petrik 09:24
Re: Using a RETURN NEXT Mendola Gaetano 11:22
Coalesce/Join/Entries may not exist. James Taylor 12:00
Re: "Join" on delimeter aggregate query Tom Lane 14:06
Re: Creating Views with Column Names based on Distinct Frank Bax 14:13
left join in cursor Alexey Dashevsky 14:21
Re: Column limits in table/ views Tom Lane 14:22
find open transactions/locks in 7.2? george young 19:21
Re: "Join" on delimeter aggregate query Michael A Nachbaur 20:08
how to determine array size Forest Wilkinson 20:23

June 10, 2003

Thread Author Time
Re: Retype Richard Huxton 07:20
Re: Coalesce/Join/Entries may not exist. Rod Taylor 11:57
Re: how to determine array size Rod Taylor 12:04
Re: how to determine array size Achilleus Mantzios 12:32
Re: left join in cursor Tom Lane 13:35
Re: "Join" on delimeter aggregate query Bruno Wolff III 13:58
Re: trigger error Dmitry Tkach 15:57
trigger error Yudie 16:04
Re: trigger error Mendola Gaetano 16:27
Re: how to determine array size Forest Wilkinson 17:45
Re: how to determine array size Rod Taylor 19:30
Re: Using a RETURN NEXT 21:01

June 11, 2003

Thread Author Time
Record size Hilary Forbes 08:35
Re: find open transactions/locks in 7.2? Christoph Haller 11:00
Re: Record size Tom Lane 13:11
Re: Record size Josh Berkus 16:18
Re: Creating Views with Column Names based on Distinct Guy Fraser 17:01

June 12, 2003

Thread Author Time
How to make a IN without a table... ? David Pradier 09:19
subselects - which is faster? Cedar Cox 10:20
Re: How to make a IN without a table... ? Christoph Haller 11:16
multiple index search with postgres7.1.3 on solaris 8 Marco Vezzoli 11:21
(no subject) A. Van Hook 11:28
Re: How to make a IN without a table... ? Bruno Wolff III 11:49
Re: How to make a IN without a table... ? David Pradier 11:50
Re: multiple index search with postgres7.1.3 on solaris 8 Bruno Wolff III 12:07
Re: How to make a IN without a table... ? Bruno Wolff III 12:09
Re: How to make a IN without a table... ? Christoph Haller 12:10
Some Questions Ludwig Lim 12:18
Re: How to make a IN without a table... ? David Pradier 12:21
Re: How to make a IN without a table... ? David Pradier 12:24
Re: multiple index search with postgres7.1.3 on solaris 8 Marco Vezzoli 12:29
Re: How to make a IN without a table... ? Christoph Haller 12:37

Browse Archives

Prev | Next