Home > mailing lists

Mailing lists [pgsql-sql]

1 January 2003

19:46 Internal functions documented Daniel Bruce Lynes

2 January 2003

03:12 CREATE INDEX question Hans-Jürgen Schönig
03:12 Execution Plans and Casts Hans-Jürgen Schönig
03:13 Reference integrity question Evgen Potemkin
03:13 Re: Stuck on SQL Query where a calculated value is used for a join. scottrarndt@aol.com (ScottRArndt)
03:14 Multiple counts Colin Fox
03:14 Doubts porting from Oracle to postgresql Senthil
03:14 empty arrays
03:14 Slow self-join on a 100 million record table mdavies@ilstu.edu (Mark Davies)
03:14 Re: Slow self-join on a 100 million record table Andrew J. Kelly
03:15 bug? Minghann Ho
04:09 Re: empty arrays Tom Lane
04:10 Re: Slow self-join on a 100 million record table Tom Lane
04:16 Re: bug? Tom Lane
07:42 Re: Reference integrity question Stephan Szabo
11:26 PostgreSQL X Resin EE Pedro Igor
16:11 Re: Slow self-join on a 100 million record table Paul Thornett
17:08 Re: empty arrays Steve Crawford
23:17 Adding a Primary Key to an exisiting table Maly Kaing
23:17 NULLL comparison in multiple column unique index Brian Walker

3 January 2003

03:09 Re: Adding a Primary Key to an exisiting table Bhuvan A
11:09 Re: NULLL comparison in multiple column unique index Manfred Koizar
11:56 Query Pedro Igor
13:57 Re: Query Stephan Szabo
15:19 Compiling pl/pgsql functions? Daniel Bruce Lynes

4 January 2003

01:59 SQL to determine Tablenames, Primarykeys & Foreignkeys] Kevin Gordon
13:16 Re: Reference integrity question Stephan Szabo

5 January 2003

08:24 Deleting in order from a table pginfo
08:41 weighting (the results of) a query ? Peter Galbavy
10:18 Re: Deleting in order from a table Ludwig Lim

6 January 2003

08:12 Grant execute on functions; related objects permissions ? Cédric Dufour (public)
08:45 Re: Grant execute on functions; related objects permissions ? Tambet Matiisen
10:41 order by and aggregate Tomasz Myrta
11:38 Re: Grant execute on functions; related objects permissions ? Bruno Wolff III
11:41 Re: order by and aggregate Richard Huxton
12:05 Re: order by and aggregate Tomasz Myrta
12:14 Sorry, to many clients already cristi
13:59 Re: order by and aggregate dev@archonet.com
14:32 Re: order by and aggregate Tomasz Myrta
14:34 Re: order by and aggregate Tom Lane
14:37 Re: order by and aggregate Tom Lane
15:05 Re: order by and aggregate Tomasz Myrta
15:05 Re: order by and aggregate Tomasz Myrta
15:29 sub-select, view and sum() Gary Stainburn
16:20 Re: Sorry, to many clients already Robert Treat
16:31 Re: sub-select, view and sum() Stephan Szabo
20:30 Re: sub-select, view and sum() Gary Stainburn

7 January 2003

06:46 Re: Sorry, to many clients already Tambet Matiisen
08:46 SQL list table names alviN
09:03 Re: SQL list table names Adam Witney
09:31 7.3.1 index use / performance Achilleus Mantzios
09:45 Inherancing Nasair Junior da Silva
10:02 Re: Inherancing Adam Witney
10:11 Re: Inherancing Nasair Junior da Silva
10:13 Re: 7.3.1 index use / performance Achilleus Mantzios
10:21 Re: Inherancing Adam Witney
10:53 A problem about alter table jack
11:27 Re: A problem about alter table Tomasz Myrta
12:06 Re: A problem about alter table jack
12:25 Re: A problem about alter table Tomasz Myrta
12:33 Re: A problem about alter table Achilleus Mantzios
12:54 insert rule doesn't see id field Ron Peterson
12:57 Re: insert rule doesn't see id field Ron Peterson
13:07 Re: A problem about alter table Jeff Eckermann
13:27 Re: [PERFORM] 7.3.1 index use / performance Stephan Szabo
14:01 Re: insert rule doesn't see id field Tom Lane
14:04 Re: weighting (the results of) a query ? Peter Galbavy
14:15 Re: weighting (the results of) a query ? Tom Lane
14:19 Re: [PERFORM] 7.3.1 index use / performance Achilleus Mantzios
14:25 Re: weighting (the results of) a query ? Peter Galbavy
14:30 Re: [PERFORM] 7.3.1 index use / performance Tom Lane
14:34 Re: weighting (the results of) a query ? Tom Lane
14:45 Re: weighting (the results of) a query ? Peter Galbavy
14:56 Re: [PERFORM] 7.3.1 index use / performance Achilleus Mantzios
15:44 Re: [PERFORM] 7.3.1 index use / performance Tom Lane
15:47 7.3.1 function problem: ERROR: cache lookup failed for type 0 Achilleus Mantzios
16:22 Re: [GENERAL] 7.3.1 function problem: ERROR: cache lookup failed for type 0 Tom Lane
16:24 Re: [GENERAL] 7.3.1 function problem: ERROR: cache lookup failed Achilleus Mantzios
16:29 Re: [PERFORM] 7.3.1 index use / performance Achilleus Mantzios
16:40 Re: [PERFORM] 7.3.1 index use / performance Tom Lane
16:41 Re: [GENERAL] 7.3.1 function problem: ERROR: cache lookup failed Joe Conway
16:43 Re: [PERFORM] 7.3.1 index use / performance Achilleus Mantzios
16:45 Re: [PERFORM] 7.3.1 index use / performance Rod Taylor
17:26 Re: [PERFORM] 7.3.1 index use / performance Tom Lane
21:12 double precision to numeric overflow error Thomas O'Connell
21:37 Re: double precision to numeric overflow error Stephan Szabo

8 January 2003

01:01 Re: double precision to numeric overflow error Thomas O'Connell
02:15 Re: [GENERAL] double precision to numeric overflow error Tom Lane
03:36 Re: double precision to numeric overflow error Thomas O'Connell
07:36 Re: SQL list table names Alan Gutierrez
07:51 Re: SQL list table names Achilleus Mantzios
09:14 full join in view Tambet Matiisen
11:38 Re: full join in view Tomasz Myrta
11:45 Re: [PERFORM] 7.3.1 index use / performance Achilleus Mantzios
12:02 Search and Replace Randy D. McCracken
12:44 Re: Search and Replace Bruno Wolff III
12:47 to_date() confusion Richard Rowell
12:54 Re: to_date() confusion Bruno Wolff III
13:32 Re: Search and Replace Rajesh Kumar Mallah.
14:04 count(*) optimization Nikola Ivacic
14:12 Re: count(*) optimization Bruno Wolff III
14:15 Re: count(*) optimization Nikola Ivacic
14:18 Re: Search and Replace Ross J. Reedstrom
14:56 What benefits can I expect from schemas ? Bob Lapique
15:05 Re: count(*) optimization Nikola Ivacic
15:27 Re: What benefits can I expect from schemas ? Bruce Momjian
15:33 Re: [PERFORM] 7.3.1 index use / performance Tom Lane
15:44 Re: count(*) optimization Josh Berkus
16:13 Re: insert rule doesn't see id field Ron Peterson
18:19 Re: Search and Replace Randy D. McCracken

9 January 2003

00:20 Re: What benefits can I expect from schemas ? chester c young
00:26 Re: What benefits can I expect from schemas ? Bruce Momjian
02:24 Postgresql Bug List? Wei Weng
02:31 Re: Postgresql Bug List? Bruce Momjian
03:25 Re: Search and Replace Rajesh Kumar Mallah.
06:37 http://www.postgresql.org site problem Achilleus Mantzios
07:24 switching default integer datatype to int8 and "IN (...)" clause postgres@ied.com
08:30 Re: switching default integer datatype to int8 and "IN (...)" clause Andrew J. Kopciuch
08:40 Re: PostgreSQL X Resin EE Radu-Adrian Popescu
09:12 SQL function parse error ? Radu-Adrian Popescu
09:52 Re: SQL function parse error ? Tomasz Myrta
10:41 Re: SQL function parse error ? Radu-Adrian Popescu
11:19 Re: SQL function parse error ? Tomasz Myrta
12:18 Re: Postgresql Bug List? Robert Treat
12:48 Re: SQL function parse error ? Tom Lane
13:04 Re: SQL function parse error ? Radu-Adrian Popescu
13:20 Re: SQL function parse error ? Achilleus Mantzios
13:22 Re: SQL function parse error ? Radu-Adrian Popescu
13:37 Re: SQL function parse error ? Radu-Adrian Popescu
13:47 Re: SQL function parse error ? Stephan Szabo
13:57 Re: SQL function parse error ? Tom Lane
14:27 Re: SQL function parse error ? Radu-Adrian Popescu
15:00 Re: SQL function parse error ? Stephan Szabo
15:17 Re: SQL function parse error ? Tom Lane
15:35 Re: SQL function parse error ? Radu-Adrian Popescu
17:13 Re: insert rule doesn't see id field Ron Peterson
17:54 Re: insert rule doesn't see id field dev@archonet.com
18:44 Re: SQL function parse error ? Robert Treat
19:54 Re: insert rule doesn't see id field Ron Peterson
21:03 Re: Search and Replace Ross J. Reedstrom
22:15 Re: Search and Replace Randy D. McCracken
22:26 Re: [NOVICE] Search and Replace Bruno Wolff III
22:48 Getting sequence value after inserting many rows at a time Maurício Sessue Otta
23:13 Re: Getting sequence value after inserting many rows at a time Bruno Wolff III

10 January 2003

00:07 Re: insert rule doesn't see id field Ron Peterson
02:53 Re: insert rule doesn't see id field Tom Lane
07:08 Table Design Questions Chad L
07:11 Re: SQL function parse error ? Radu-Adrian Popescu
07:29 Re: insert rule doesn't see id field Radu-Adrian Popescu
07:32 Re: insert rule doesn't see id field Radu-Adrian Popescu
12:27 Re: SQL function parse error ? Robert Treat
12:48 Re: SQL function parse error ? Tom Lane
13:12 Re: Table Design Questions dev@archonet.com
14:27 Re: insert rule doesn't see id field Ron Peterson
15:32 Re: Table Design Questions Josh Berkus
16:46 Re: noupcol code cleanup Ron Peterson
20:14 function does not exist Dave A.
20:24 Re: function does not exist Ross J. Reedstrom
20:27 Re: function does not exist Josh Berkus

11 January 2003

16:33 Re: Getting sequence value after inserting many rows at a time Bruno Wolff III
22:04 Re: switching default integer datatype to int8 and "IN (...)" postgres@ied.com

12 January 2003

02:45 Re: [JDBC] Select * from users WHERE upper(lastName) = upper('Pringle') Tom Lane

13 January 2003

08:04 Unique indexes not unique? Jimmy Mäkelä
08:39 Re: Unique indexes not unique? Tomasz Myrta
08:55 Re: Unique indexes not unique? Jimmy Mäkelä
10:08 Re: Unique indexes not unique? Stephan Szabo
10:32 Re: Unique indexes not unique? dev@archonet.com
10:47 Crosstab-style query in pure SQL dev@archonet.com
13:33 Re: Unique indexes not unique? Tom Lane
13:58 Re: Unique indexes not unique? Stephan Szabo
14:12 Re: Unique indexes not unique? Tom Lane
15:26 Re: Crosstab-style query in pure SQL Josh Berkus
16:29 PgSQL 7.3: /opt/pgsql/bin/postgres: Execute permission denied. Zengfa Gao
16:29 Postgresql Bug List? Wei Weng
16:29 Returning row or rows from function? David Durst
16:34 to_date confusion Richard Rowell
16:34 Re: Inherancing Daniel Schuchardt
16:42 Re: to_date confusion Josh Berkus
16:44 Re: Returning row or rows from function? Stephan Szabo
16:46 Re: Returning row or rows from function? Tomasz Myrta
16:46 Re: to_date confusion Stephan Szabo
17:30 Re: Crosstab-style query in pure SQL dev@archonet.com
18:19 Re: PgSQL 7.3: /opt/pgsql/bin/postgres: Execute permission denied. Chris Travers
18:27 assigning values to array elements J Greenbaum
19:05 Re: assigning values to array elements Tom Lane
19:11 Re: assigning values to array elements J Greenbaum
19:20 query speed joining tables Christopher Smith
19:44 Re: query speed joining tables Josh Berkus
19:56 Re: query speed joining tables Christopher Smith
19:58 Re: query speed joining tables Tomasz Myrta
20:03 Re: query speed joining tables Christopher Smith
20:12 Re: insert rule doesn't see id field Ron Peterson
20:16 Re: insert rule doesn't see id field Tom Lane
20:19 Re: Postgresql Bug List? Bruce Momjian
22:47 Re: assigning values to array elements Bruce Momjian

14 January 2003

05:08 Re: query speed joining tables Tomasz Myrta
07:04 Re: full join in view Tambet Matiisen
07:48 Re: full join in view Tomasz Myrta
09:02 Data between different databases Pedro Igor
12:27 Re: full join in view Tambet Matiisen
12:47 database broken ? mdc@keko.com.ar
13:59 Re: database broken ? Tom Lane
18:06 Re: full join in view jasiek@klaster.net

15 January 2003

07:25 Re: full join in view Tambet Matiisen
08:26 Performance of request of type WHERE ... IN ( ... ) Th Templ
08:49 Re: Performance of request of type WHERE ... IN ( ... ) Achilleus Mantzios
09:39 index on to_char(created, 'YYYY') doesn't work Andreas Joseph Krogh
09:54 Re: index on to_char(created, 'YYYY') doesn't work Andreas Joseph Krogh
10:03 Re: index on to_char(created, 'YYYY') doesn't work Achilleus Mantzios
10:13 Re: index on to_char(created, 'YYYY') doesn't work Andreas Joseph Krogh
11:58 sort by relevance sector119@mail.ru
12:31 Oracle outer join porting question Marko Asplund
12:38 Re: Oracle outer join porting question Dan Langille
12:42 Re: Oracle outer join porting question Tambet Matiisen
13:03 Re: index on to_char(created, 'YYYY') doesn't work Achilleus Mantzios
13:09 Re: Oracle outer join porting question Dan Langille
13:19 Re: index on to_char(created, 'YYYY') doesn't work Andreas Joseph Krogh
14:18 Re: index on to_char(created, 'YYYY') doesn't work Achilleus Mantzios
14:20 Re: index on to_char(created, 'YYYY') doesn't work Tom Lane
15:40 Re: Performance of request of type WHERE ... IN ( ... ) Josh Berkus
15:55 Re: index on to_char(created, 'YYYY') doesn't work Steve Crawford
16:15 RFC: A brief guide to nulls dev@archonet.com
16:34 Re: index on to_char(created, 'YYYY') doesn't work Andreas Joseph Krogh
16:43 Re: query speed joining tables Josh Berkus
17:04 Re: index on to_char(created, 'YYYY') doesn't work Josh Berkus
17:12 Re: sort by relevance Oleg Bartunov
17:16 lost on self joins Matthew Nuzum
17:28 Re: query speed joining tables Vernon Wu
17:32 Re: A brief guide to nulls Otto Hirr
18:08 Re: RFC: A brief guide to nulls Andrew Perrin
18:34 Re: query speed joining tables Josh Berkus
18:37 Re: RFC: A brief guide to nulls Josh Berkus
18:38 Re: sub-select with aggregate Tom Lane
18:48 Re: RFC: A brief guide to nulls Antti Haapala
18:53 Re: lost on self joins Tomasz Myrta
19:00 Re: sort by relevance Ross J. Reedstrom
19:12 Re: lost on self joins Matthew Nuzum
19:22 Re: RFC: A brief guide to nulls Bruno Wolff III
19:48 Re: lost on self joins Bruno Wolff III
21:52 Re: RFC: A brief guide to nulls Antti Haapala
21:57 Re: lost on self joins Ross J. Reedstrom
23:56 joining from multiple tables Joseph Shraibman
23:58 show data from two tables together Matthew Nuzum

16 January 2003

00:02 Re: RFC: A brief guide to nulls Peter Eisentraut
00:21 Re: joining from multiple tables Stephan Szabo
00:22 Re: RFC: A brief guide to nulls Ludwig Lim
01:35 Re: show data from two tables together Stephan Szabo
01:46 Re: show data from two tables together Matthew Nuzum
02:20 Re: RFC: A brief guide to nulls Tom Lane
04:10 pg_dump problem Rudi Starcevic
04:30 Re: sort by relevance sector119@mail.ru
05:09 Re: sort by relevance Rajesh Kumar Mallah.
07:07 Re: RFC: A brief guide to nulls dev@archonet.com
07:11 Re: RFC: A brief guide to nulls dev@archonet.com
07:55 Re: lost on self joins Tomasz Myrta
07:59 Re: RFC: A brief guide to nulls (noarchive) Ries van Twisk
09:32 Re: Oracle outer join porting question Marko Asplund
09:34 Re: pg_dump problem Tomasz Myrta
10:06 Implementing automatic updating of primary keys... Rajesh Kumar Mallah.
10:37 Re: Implementing automatic updating of primary keys... Tomasz Myrta
12:23 Re: Implementing automatic updating of primary keys... Rajesh Kumar Mallah.
14:23 Function unkown Pedro Igor
15:35 Re: RFC: A brief guide to nulls Otto Hirr
15:39 pg_restore cannot restore an index Jie Liang
15:46 Re: query speed joining tables Josh Berkus
16:27 Re: pg_restore cannot restore an index Bruce Momjian
16:44 Re: pg_restore cannot restore an index Tom Lane
20:37 Re: pg_restore cannot restore an index Jie Liang
21:30 Re: query speed joining tables Vernon Wu
21:43 Re: query speed joining tables Josh Berkus

17 January 2003

01:35 cannot create function that uses variable table name Matthew Nuzum
02:42 Re: cannot create function that uses variable table name chester c young
02:44 Re: cannot create function that uses variable table name Stephan Szabo
07:48 Re: cannot create function that uses variable table name D'Arcy J.M. Cain
11:06 sum(time) problem Oliver Vecernik
11:13 Re: sum(time) problem Julian Scarfe
13:03 Re: sum(time) problem Tom Lane
13:05 RCF: 2nd draft: A brief guide to Nulls dev@archonet.com
18:08 "Best practice" advice Andrew Perrin
18:15 Re: "Best practice" advice Josh Berkus
18:45 Re: [GENERAL] double precision to numeric overflow error Jan Wieck
22:11 Can I do this? Wei Weng
22:37 Re: Can I do this? Josh Berkus
22:37 Re: Can I do this? Bruce Momjian

18 January 2003

04:16 Problem with COPY FROM Harry Yau

19 January 2003

11:33 Selecting a non-locked row. Kurt Roeckx
19:23 Re: Selecting a non-locked row. Josh Berkus
20:03 Re: Selecting a non-locked row. Kurt Roeckx
20:32 Re: Selecting a non-locked row. Josh Berkus
20:40 Group By Error Text Joseph Healy
20:44 Re: Group By Error Text Josh Berkus
23:35 Re: Selecting a non-locked row. D'Arcy J.M. Cain

20 January 2003

06:18 Re: Function unkown Tomasz Myrta
07:17 Re: pg_dump problem Bhuvan A
07:35 Re: Implementing automatic updating of primary keys... Bhuvan A
09:40 performance question Moritz Lennert
09:51 Re: Unique indexes not unique? Jimmy Mäkelä
13:12 Re: performance question Manfred Koizar
14:45 Re: performance question Moritz Lennert
15:10 Re: performance question Moritz Lennert
16:10 Re: performance question Josh Berkus
16:26 Re: performance question Manfred Koizar
16:50 Could someone help me fix my array_list function? Guy Fraser
17:34 Re: performance question Moritz Lennert
17:40 performance question Moritz Lennert
17:40 performance question Moritz Lennert
18:39 Re: performance question Tom Lane
19:05 Re: performance question Tomasz Myrta
20:20 Re: performance question Josh Berkus
21:29 Re: Could someone help me fix my array_list function? Joe Conway
22:39 Re: Could someone help me fix my array_list function? Michiel Lange
22:45 Re: performance question Moritz Lennert
23:10 Re: performance question Moritz Lennert

21 January 2003

00:25 Re: Could someone help me fix my array_list function? Joe Conway
01:34 Re: performance question Moritz Lennert
03:34 Re: performance question Vernon Wu
09:52 Speed depending of Join Order. Raúl Gutiérrez Sánchez
11:24 [OT] Unsubscribe does not work Andreas Tille
11:47 performance question Moritz Lennert
11:47 returning setof in plpgsql David Durst
12:04 Re: [OT] Unsubscribe does not work Bruno Wolff III
12:34 Re: [OT] Unsubscribe does not work Andreas Tille
12:57 Re: returning setof in plpgsql Gary Stainburn
13:10 Re: [OT] Unsubscribe does not work Tom Lane
13:14 Re: Speed depending of Join Order. Tom Lane
13:34 Re: returning setof in plpgsql Tom Lane
20:43 help Rudi Starcevic
20:49 Oops - help error. Rudi Starcevic

22 January 2003

06:54 optimal sql Michael Hostbaek
07:37 NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index David Durst
07:42 Re: optimal sql Achilleus Mantzios
07:53 Re: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index Ludwig Lim
08:02 Re: optimal sql Michael Paesold
08:14 Re: optimal sql Michael Hostbaek
08:46 Re: optimal sql Tomasz Myrta
08:49 Re: optimal sql Tomasz Myrta
08:49 Re: optimal sql Achilleus Mantzios
10:08 PostgreSQL + SSL Pedro Igor Craveiro e Silva
13:13 To use a VIEW or not to use a View..... Ries van Twisk
13:36 Re: To use a VIEW or not to use a View..... Bruno Wolff III
14:00 Re: To use a VIEW or not to use a View..... Jan Wieck
14:19 Re: To use a VIEW or not to use a View..... Tomasz Myrta
14:21 Re: To use a VIEW or not to use a View..... Stephan Szabo
14:52 Re: To use a VIEW or not to use a View..... Tomasz Myrta
15:33 Re: To use a VIEW or not to use a View..... Stephan Szabo
15:53 Re: To use a VIEW or not to use a View..... Jan Wieck
16:57 Re: To use a VIEW or not to use a View..... Tomasz Myrta
17:10 Re: To use a VIEW or not to use a View..... Tomasz Myrta
18:58 Re: Speed depending of Join Order. Tom Lane
19:50 Re: To use a VIEW or not to use a View..... Stephan Szabo
20:23 Re: To use a VIEW or not to use a View..... Tom Lane
20:32 Re: To use a VIEW or not to use a View..... Tomasz Myrta
23:21 Re: To use a VIEW or not to use a View..... Stephan Szabo
23:26 Re: To use a VIEW or not to use a View..... Stephan Szabo
23:30 Re: To use a VIEW or not to use a View..... Tom Lane
23:33 DBCC CheckIdent in a stored proc? smoghe@autodesk.com

23 January 2003

06:06 Re: To use a VIEW or not to use a View..... Ries van Twisk
07:54 Re: PostgreSQL + SSL Bhuvan A
07:57 Re: DBCC CheckIdent in a stored proc? Bhuvan A
08:53 Re: To use a VIEW or not to use a View..... Tomasz Myrta
08:57 calling function from rule Tambet Matiisen
12:16 Slow query Ricardo Javier Aranibar León
13:31 Re: Slow query Tomasz Myrta
13:42 Re: calling function from rule Tom Lane
14:19 Re: calling function from rule Tambet Matiisen
15:14 Re: To use a VIEW or not to use a View..... Stephan Szabo
15:16 Re: calling function from rule Tom Lane
15:39 Re: To use a VIEW or not to use a View..... Tom Lane
16:06 Re: To use a VIEW or not to use a View..... jasiek@klaster.net
17:09 Re: To use a VIEW or not to use a View..... Stephan Szabo
17:37 Re: CREATE VIEW ERROR Igor
18:26 SQL to list databases? Ben Siders
19:37 Re: [GENERAL] sort by relevance Björn Metzdorf
20:01 Re: cannot create function that uses variable table name Beth
20:19 Bruce Becker
21:17 Re: To use a VIEW or not to use a View..... Tom Lane
21:32 Re: SQL to list databases? Larry Rosenman
21:55 Re: SQL to list databases? Kristopher Yates
22:33 Rename database? Wei Weng
22:55 Re: SQL to list databases? Keith Keller
22:57 Re: SQL to list databases? Steve Crawford

24 January 2003

00:02 Scheduling Events? David Durst
00:36 Re: cannot create function that uses variable table name Beth
02:22 plpgsql: debugging Oliver Vecernik
02:45 CAST from VARCHAR to INT Luke Pascoe
03:27 Re: SQL to list databases? Roberto Mello
03:59 Re: Scheduling Events? Roberto Mello
04:18 Re: CAST from VARCHAR to INT Bhuvan A
04:39 Re: CAST from VARCHAR to INT Tom Lane
05:25 Re: Scheduling Events? David Durst
05:32 quastions about primary key jack
05:48 Re: Scheduling Events? Achilleus Mantzios
06:14 Re: plpgsql: debugging Ludwig Lim
06:24 Race condition w/ FIFO Queue reappears! Chris Gamache
06:33 Re: Scheduling Events? David Durst
07:07 Re: calling function from rule Tambet Matiisen
08:01 Re: Scheduling Events? Achilleus Mantzios
08:34 Re: CAST from VARCHAR to INT daq
08:40 Re: quastions about primary key Tomasz Myrta
11:17 Re: Scheduling Events? Bruno Wolff III
13:15 Re: quastions about primary key Stephan Szabo
13:37 Re: Scheduling Events? Tom Lane
13:59 Re: CAST from VARCHAR to INT Tom Lane
14:15 Re: Scheduling Events? Wei Weng
17:10 Re: SQL to list databases? Guy Fraser
17:24 Re: Scheduling Events? Guy Fraser
17:43 Getting multiple rows in plpgsql function David Durst
17:43 Re: CAST from VARCHAR to INT Roberto Mello
19:17 Re: Scheduling Events? David Durst
20:57 Re: Getting multiple rows in plpgsql function Roberto Mello
21:20 Function for adding Money type David Durst
22:16 Re: Function for adding Money type Josh Berkus
22:58 Re: Function for adding Money type David Durst
23:42 Re: Getting multiple rows in plpgsql function Guy Fraser

26 January 2003

00:44 Re: quastions about primary key jack
01:54 Re: returning setof in plpgsql Bruce Momjian
02:10 Re: quastions about primary key Bruno Wolff III
06:06 ERROR: Cannot display a value of type RECORD David Durst
06:15 Re: ERROR: Cannot display a value of type RECORD David Durst
11:53 Re: Function for adding Money type D'Arcy J.M. Cain
12:06 Re: Function for adding Money type Thomas Good
14:03 Re: Function for adding Money type Oliver Elphick
17:52 Re: Scheduling Events? Matthew Nuzum
21:16 Re: PostgreSQL + SSL Bruce Momjian

27 January 2003

05:36 Re: [ADMIN] how sub queries and joins differs funcationally Ludwig Lim
16:41 Re: Rename database? Bruce Momjian
18:04 sequence question Marie G. Tuite
18:11 Re: CAST from VARCHAR to INT Luke Pascoe
18:15 Re: Function for adding Money type Bruce Momjian
18:18 Re: sequence question Rod Kreisler

28 January 2003

08:08 converting microsoft sql server 2000 sql-code for postgresql 7.2.1 william windels
08:55 Re: converting microsoft sql server 2000 sql-code for postgresql Bhuvan A
09:21 subselect return in where clause Michael Hostbaek
09:35 Re: converting microsoft sql server 2000 sql-code for postgresql 7.2.1 Geraint Jones
09:53 Re: converting microsoft sql server 2000 sql-code for postgresql 7.2.1 Rajesh Kumar Mallah.
11:30 import error Oliver Vecernik
11:40 Re: import error Achilleus Mantzios
11:44 Re: import error Achilleus Mantzios
12:12 Re: CR/LF conversion (was: import error) Oliver Vecernik
12:17 Re: CR/LF conversion (was: import error) Achilleus Mantzios
12:50 CSV import Oliver Vecernik
12:58 Re: CSV import Achilleus Mantzios
13:28 Re: import error Tom Lane
13:35 Re: CR/LF conversion (was: import error) Tom Lane
14:05 Re: subselect return in where clause Tom Lane
19:02 Cross-database references Pedro Igor Craveiro e Silva
20:23 Problem with query Ricardo Javier Aranibar León
21:36 Re: CSV import Guy Fraser
21:37 Re: converting microsoft sql server 2000 sql-code for postgresql Guy Fraser
22:02 Re: CSV import Jeff Eckermann
22:07 Re: converting microsoft sql server 2000 sql-code for postgresql 7.2.1 Jeff Eckermann
22:13 Re: Cross-database references Jason Turner

29 January 2003

00:29 LONG - Question on dealing w/ numerics David Durst
00:55 Re: Cross-database references Roberto Mello
01:18 Re: converting microsoft sql server 2000 sql-code for postgresql Tom Lane
01:21 Re: CSV import Jean-Luc Lachance
01:31 Re: Problem with query Tom Lane
01:46 Re: Problem with query Josh Berkus
02:02 Re: LONG - Question on dealing w/ numerics Josh Berkus
02:08 Re: LONG - Question on dealing w/ numerics Josh Berkus
02:17 Re: CSV import Rodger Donaldson
02:55 Re: LONG - Question on dealing w/ numerics Tom Lane
03:16 checking data integrity in a recursive table Luke Pascoe
03:28 Re: double linked list 71062.1056@compuserve.com (--CELKO--)
03:36 Cross-table constraints Rodger Donaldson
03:42 double linked list jasche@gmx.de (Juergen)
03:43 Filter function Evgen Potemkin
03:49 Re: Scheduling Events? Ed L.
03:52 Re: converting microsoft sql server 2000 sql-code for postgresql Wei Weng
03:54 Re: double linked list DA Morgan
03:54 Re: Rename database? codeWarrior
04:00 Please include hier-patch in next PostgreSQL version Boris Klug
04:06 Re: SQL to list databases? Horst Herb
04:15 Creating tables from within functions Seethalakshmi VB
05:26 Re: CSV import Oliver Vecernik
05:35 Re: Cross-table constraints Stephan Szabo
05:51 Re: Cross-table constraints Stephan Szabo
06:35 Re: Cross-table constraints Rodger Donaldson
06:41 Re: Creating tables from within functions Stephan Szabo
06:57 USING INDEX Abdul Wahab Dahalan
07:18 Re: Cross-table constraints Bruno Wolff III
07:24 Re: LONG - Question on dealing w/ numerics David Durst
07:25 Re: converting microsoft sql server 2000 sql-code for postgresql Bruno Wolff III
07:26 Re: Filter function Tom Lane
08:05 Re: LONG - Question on dealing w/ numerics Tom Lane
08:18 plpgsql: return results of a dynamic query Moritz Lennert
08:42 Re: CSV import Gary Stainburn
11:00 Re: plpgsql: return results of a dynamic query Christoph Haller
11:18 Re: [HACKERS] Please include hier-patch in next PostgreSQL version Rod Taylor
11:24 Re: plpgsql: return results of a dynamic query Moritz Lennert
11:27 help: triggers Tony Simbine
13:57 Re: help: triggers Wei Weng
15:21 plpgsql: return results of a dynamic query Moritz Lennert
17:56 Inheritence and Integrity Neal Lindsay
18:19 Re: Inheritence and Integrity Stephan Szabo
18:39 Re: Inheritence and Integrity Neal Lindsay
18:49 Re: Inheritence and Integrity Stephan Szabo
19:24 Re: plpgsql: return results of a dynamic query Moritz Lennert

30 January 2003

04:27 Re: Inheritence and Integrity chester c young
06:20 Re: help: triggers Tony Simbine
07:43 Question about passing User defined types to functions David Durst
09:52 Delete 1 Record of 2 Duplicate Records val@webtribe.net
09:56 Re: Delete 1 Record of 2 Duplicate Records Achilleus Mantzios
11:11 Re: double linked list Christoph Haller
11:55 Function executing twice Thiago Conti
12:16 Re: double linked list Alan Gutierrez
12:26 Re: double linked list Christoph Haller
12:56 Re: Filter function Tom Lane
13:08 Re: Delete 1 Record of 2 Duplicate Records greg@turnstep.com
13:15 Re: Function executing twice Tambet Matiisen
13:29 Re: Question about passing User defined types to functions Christoph Haller
13:40 Re: Question about passing User defined types to functions Tom Lane
13:54 calculated expressions and index use Pavel Hlavnicka
14:17 Re: calculated expressions and index use Arjen van der Meijden
14:51 Re: calculated expressions and index use Tom Lane
20:29 Re: CSV import Chad Thompson
20:35 Re: CSV import Oliver Vecernik
20:39 Converting clarion Nasair Junior da Silva
20:43 Re: Converting clarion Oliver Vecernik
23:17 Re: Delete 1 Record of 2 Duplicate Records Tom Lane
23:19 How to rename and drop a column in pg7.3? Vernon Wu

31 January 2003

00:21 FW: Converting clarion Michael Weaver
00:59 Re: How to rename and drop a column in pg7.3?
03:34 design review, FreshPorts change Dan Langille
04:36 Re: checking data integrity in a recursive table Bruce Momjian
06:46 Re: calculated expressions and index use Pavel Hlavnicka
15:50 Postgres MD5 Function David Durst
16:09 Which version is this? Wei Weng
16:16 Re: CSV import Jean-Luc Lachance
16:17 Re: calculated expressions and index use Pavel Hlavnicka
16:24 Re: calculated expressions and index use Tom Lane
16:37 Re: Postgres MD5 Function Larry Rosenman
17:36 Re: Postgres MD5 Function Joe Conway
21:25 For each record in SELECT Luis Magaña