pgsql-sql - June 2003

Discussion for users on SQL related matters.

Search the Archives

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

Browse Archives

Prev | Next

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
Re: How to make a IN without a table... ? David Pradier 12:49
Re: (no subject) Tom Lane 13:42
control structures in plpgsql Robert Treat 14:13
help Tony Simbine 14:15
Re: control structures in plpgsql Stephan Szabo 14:24
Re: Some Questions Stephan Szabo 14:33
Re: control structures in plpgsql Robert Treat 14:44
Re: (no subject) Achilleus Mantzios 16:55
Re: help Josh Berkus 17:10

June 13, 2003

Thread Author Time
question on rules weigelt 01:26
Re: question on rules Tom Lane 01:57
Re: question on rules Tomasz Myrta 06:00
date question javier garcia - CEBAS 11:44
trigger : emulate "instead of" with before ? Albrecht Berger 11:50
"No such attribute or function 'oid'" javier garcia - CEBAS 11:59
Re: trigger : emulate "instead of" with before ? Matthew Nuzum 13:09
Re: trigger : emulate "instead of" with before ? Jeff Eckermann 13:50
Re: trigger : emulate "instead of" with before ? Tom Lane 13:57
create tables within functions Demidem Mohamed Amine 15:07
Re: create tables within functions Stephan Szabo 15:22
Re: question on rules Jan Wieck 16:30
Re: create tables within functions chester c young 19:15
rpm scripts Craig Jensen 19:45
Re: subselects - which is faster? scott.marlowe 21:00
Re: How to make a IN without a table... ? scott.marlowe 21:04

June 14, 2003

Thread Author Time
UNION & LIMIT & ORDER BY Emmanuel Engelhart 17:01
WHERE of an AGGREGATE ... The Hermit Hacker 23:31
Re: WHERE of an AGGREGATE ... deststar 23:58

June 15, 2003

Thread Author Time
Re: WHERE of an AGGREGATE ... The Hermit Hacker 00:39
Where of an aggregate vali 08:01
Ordering in an aggregate -- points to paths Julian Scarfe 15:13
Re: Ordering in an aggregate -- points to paths Tom Lane 15:49
Re: Ordering in an aggregate -- points to paths Julian Scarfe 16:48

June 16, 2003

Thread Author Time
Re: How to make a IN without a table... ? David Pradier 07:27
Let join syntax Nicolas JOUANIN 10:34
Re: Let join syntax Manfred Koizar 10:57
casting interval to time Tomasz Myrta 13:51
Re: Let join syntax Tom Lane 14:31
Re: Let join syntax Manfred Koizar 14:39
Re: casting interval to time Tom Lane 14:53
[pgmail] - I have problems with pgmail BenLaKnet 14:55
Re: casting interval to time Tomasz Myrta 15:00
Re: casting interval to time Tom Lane 15:17
Re: [pgmail] - I have problems with pgmail Tom Lane 15:37
Re: casting interval to time Antti Haapala 15:56
Re: casting interval to time Tomasz Myrta 16:00
Let join syntax Nicolas JOUANIN 16:41
Re: date question Bruno Wolff III 17:24
Re: [SQL] "No such attribute or function 'oid'" Tomasz Myrta 17:28
Re: casting interval to time Tom Lane 17:51
Re: casting interval to time Tom Lane 19:02
Re: UNION & LIMIT & ORDER BY Guillaume LELARGE 19:37
set decimal point in SQL Bu, Ning 22:02
Our FLOAT(p) precision does not conform to spec Tom Lane 22:15
unique keys on inherited classes weigelt 22:20
Re: [HACKERS] Our FLOAT(p) precision does not conform to spec Bruce Momjian 23:35

June 17, 2003

Thread Author Time
Re: Our FLOAT(p) precision does not conform to spec Richard Hall 01:01
Trouble porting a Oracle PL/SQL procedure to PL/pgSQL Tony G. Harris 01:57
Re: Trouble porting a Oracle PL/SQL procedure to PL/pgSQL Stephan Szabo 02:17
select date range? ko 02:56
Re: select date range? Josh Berkus 03:28
Re: select date range? Ramil G. Sagum 03:43
Can the frontend get notifications from the postgres server? Anagha Joshi 04:39
Re: Trouble porting a Oracle PL/SQL procedure to PL/pgSQL Tom Lane 04:42
Re: Can the frontend get notifications from the postgres server? weigelt 05:28
Re: Can the frontend get notifications from the postgres A.Bhuvaneswaran 06:37
Re: [HACKERS] Our FLOAT(p) precision does not conform to spec Shridhar Daithankar 07:05
Re: Can the frontend get notifications from the postgres server? weigelt 08:01
Request for advice: Table design Mattias Kregert 08:35
Re: Request for advice: Table design Thomas Kellerer 08:48
Blobs with perl cristi 09:00
Re: Request for advice: Table design Jason Godden 09:06
maxconnection zhuj 09:22
Catching DML exceptions in PL/pgSQL 📎 Radu-Adrian Popescu 09:25
Re: Catching DML exceptions in PL/pgSQL Tomasz Myrta 09:44
Re: Catching DML exceptions in PL/pgSQL Radu-Adrian Popescu 09:50
Re: Catching DML exceptions in PL/pgSQL Joe Conway 09:56
Re: Catching DML exceptions in PL/pgSQL Radu-Adrian Popescu 10:49
Re: help Tony Simbine 11:28
Re: select date range? scott.marlowe 12:02
Re: Can the frontend get notifications from the postgres scott.marlowe 12:08
Notification Anagha Joshi 12:13
yet pg_toast reindex Eric Anderson Vianet SAO 12:23
Re: Can the frontend get notifications from the postgres A.Bhuvaneswaran 12:27
Re: Can the frontend get notifications from the postgres server? weigelt 12:38
Re: Can the frontend get notifications from the postgres server? weigelt 12:40
Re: Request for advice: Table design Andrew Perrin 13:37
Re: [HACKERS] Our FLOAT(p) precision does not conform to spec Tom Lane 14:29
Re: Blobs with perl Jonathan Gardner 14:30
Re: yet pg_toast reindex Tom Lane 14:55
CREATE table1 FROM table2 Rado Petrik 15:20
Re: CREATE table1 FROM table2 Devrim GUNDUZ 15:31
Re: Request for advice: Table design Mike Mascari 15:32

Browse Archives

Prev | Next