Home > mailing lists

Mailing lists [pgsql-sql]

1 January 2002

19:08 Re: PostgreSQL SELECT error caldodge@fpcc.net (Calvin Dodge)

2 January 2002

14:45 Re: Tree structure index usage Josh Berkus
23:45 to_char adds leading space, intended? Aasmund Midttun Godal

3 January 2002

02:45 Re: to_char adds leading space, intended? rolf.ostvik@axxessit.no
08:44 Working with array value columns in PL/pgSQL triggers/functions Roland Roberts
08:46 left join and where aannddrree@libero.it (andrea)
09:11 change null to 0 in SQL script Karl Raven
09:11 Need help Shamik Majumder
09:14 Retrieving information from System Tables Dempsey Bullock
09:17 OUTER JOIN doesn't work on pgSQL 7.1.2 Alex Glikson
09:27 pltcl function -> plpgsql guard
09:29 Getting Hour From a Time in Different Time Zone Tom Kreiner
09:31 How to union tables and have a field with UNIQUE constraint? Katona Gabor
09:32 Conditional test rickd@open-works.com (Rick Dayao)
10:04 Re: change null to 0 in SQL script Markus Bertheau
10:15 Re: OUTER JOIN doesn't work on pgSQL 7.1.2 Tom Lane
10:46 Re: Getting Hour From a Time in Different Time Zone Tom Lane
11:01 Re: change null to 0 in SQL script Tibor Laszlo
11:31 Re: change null to 0 in SQL script Jason Earl
12:13 Re: Retrieving information from System Tables Bruce Momjian
12:15 Re: Conditional test Bruce Momjian
13:16 Re: How to union tables and have a field with UNIQUE constraint? Stephan Szabo
16:01 Re: How to union tables and have a field with UNIQUE constraint? Tom Lane
16:11 Re: pltcl function -> plpgsql Jan Wieck
16:51 Re: How to union tables and have a field with UNIQUE constraint? Stephan Szabo
18:31 top? Richard Rowell
18:31 Re: How to union tables and have a field with UNIQUE constraint? Tom Lane
18:51 Re: top? Stephan Szabo
21:16 Re: top? Christopher Kings-Lynne

4 January 2002

02:01 maintaining a field for every UPDATION. Bhuvan A
03:31 Re: maintaining a field for every UPDATION. Stephan Szabo
09:41 Re: top? SHELTON,MICHAEL (Non-HP-Boise,ex1)
10:12 Execute dynamically generated query??? Unnikrishnan Menon
10:22 Re: left join and where Masaru Sugawara
11:43 Telling how many records are joined Andrew Perrin
12:15 simple? join Frank Bax
14:32 Re: Telling how many records are joined Bill Cunningham

5 January 2002

15:45 Which date/paper pairs are NOT represented? Andrew Perrin

6 January 2002

00:22 Re: simple? join Peter Eisentraut

7 January 2002

12:24 Postgres vs. Redhat DB Hunter, Ray
13:14 Re: Which date/paper pairs are NOT represented? Peter Eisentraut
17:25 Re: simple? join Frank Bax
17:54 Re: simple? join Peter Eisentraut
18:44 Re: simple? join Tom Lane
18:54 SELECT * FROM xy WHERE name LIKE '%german special char' Albrecht Berger
19:24 Re: SELECT * FROM xy WHERE name LIKE '%german special char' Manuel Sugawara
19:44 Re: SELECT * FROM xy WHERE name LIKE '%german special char' Tom Lane
20:54 Re: simple? join Christopher Kings-Lynne
22:44 Re: simple? join Tom Lane
23:24 Porting Oracle Packages Unnikrishnan Menon

8 January 2002

11:55 Momjian "Support Functions" section: possible typo and question Terrence Brannon
12:24 Re: [GENERAL] Need help Jason Earl
14:24 Re: simple? join Frank Bax
14:55 Re: Momjian "Support Functions" section: possible typo and question Bruce Momjian
15:36 Re: Porting Oracle Packages Josh Berkus
17:15 Can't find compile-time options Josh Berkus
18:45 Re: Can't find compile-time options Peter Eisentraut
18:55 Re: Can't find compile-time options Tom Lane
19:14 Re: Can't find compile-time options Josh Berkus

9 January 2002

00:54 Re: Postgres vs. Redhat DB Marc G. Fournier
04:55 Re: [GENERAL] Need help Maarten.Boekhold@reuters.com
09:25 Nested loops and $13 Torbjörn Andersson
10:55 Re: Nested loops and $13 Tom Lane
11:05 problem with date and to_char postgresql
11:05 Re: Porting Oracle Packages Roberto Mello
11:05 Re: Nested loops and $13 Torbjörn Andersson
11:45 Re: Nested loops and $13 Torbjörn Andersson
19:25 Re: problem with date and to_char Josh Berkus
19:54 Re: problem with date and to_char Tom Lane
20:14 Re: problem with date and to_char Josh Berkus
20:24 converting an epoch to a timestamp Christopher Kings-Lynne
21:04 Re: converting an epoch to a timestamp Tom Lane

10 January 2002

09:15 Resources Gurudutt
10:55 Re: Resources Jason Earl
11:15 Re: Resources Stephan Szabo
11:26 Re: Resources Nick Fankhauser
15:35 Re: Resources Wei Weng
17:15 Re: Resources SHELTON,MICHAEL (Non-HP-Boise,ex1)
17:35 replication Peter T. Brown
18:15 Temporary tables SHELTON,MICHAEL (Non-HP-Boise,ex1)
18:15 Recall: Temporary tables SHELTON,MICHAEL (Non-HP-Boise,ex1)
18:55 Re: [ADMIN] replication David Stanaway

11 January 2002

08:15 Re: Resources Gurudutt
09:25 Re: Resources Isabelle Brette
09:55 Re: Resources Nick Fankhauser
11:25 Re: Resources Frank Bax
11:25 Re: Resources Nick Fankhauser
11:36 Re: Resources Frank Bax
11:55 Re: Resources jtp
12:05 Re: Resources Nick Fankhauser
12:25 Re: Temporary tables Peter T. Brown
12:55 Re: Resources Chester Carlton Young
13:55 Re: How to union tables and have a field with UNIQUE constraint? Katona Gabor
13:55 Re: change null to 0 in SQL script ThomasR
13:55 Re: SQL syntax help needed Chris Sypolt
13:55 Re: SQL syntax help needed Björn Lundin
13:55 Re: SQL syntax help needed Björn Lundin
14:05 Re: SQL syntax help needed Björn Lundin
14:15 who has lock on table/row Mir S Islam
14:15 Re: change null to 0 in SQL script Karl Raven
14:25 Re: Resources Frank Bax
16:25 Re: Resources Frank Bax
19:55 Re: How to union tables and have a field with UNIQUE constraint? Stephan Szabo

12 January 2002

08:55 triggered data change violation Murray Prior Hobbs
11:25 Re: triggered data change violation Tom Lane
17:55 Re: triggered data change violation Murray Prior Hobbs

13 January 2002

09:36 Problems with PL/PGSQL - functions Unnikrishnan Menon
11:25 Re: Problems with PL/PGSQL - functions Ross J. Reedstrom
12:05 Re: Problems with PL/PGSQL - functions Tom Lane
15:26 Problem with unique index Sharon Cowling
15:55 Re: Problem with unique index Tom Lane
15:56 Re: Problem with unique index Stephan Szabo
16:55 pg with different sql? pocm@rnl.ist.utl.pt (Paulo J. Matos)
17:36 Re: pg with different sql? Jean-Luc Lachance
17:46 Re: pg with different sql? Ian Barwick
17:55 Re: pg with different sql? Tom Lane
18:25 Re: pg with different sql? George Moga

14 January 2002

00:25 Re: Problems with PL/PGSQL - functions Unnikrishnan Menon
08:57 Commercial: New Book!! PostgreSQL book is released into the market Al Dev
09:06 SQL Joins tjennette@thomasnelson.com (Trace)
09:06 Re: Error trying to create a functional index. Steve Brett
09:06 Re: problems with single quotes.. Luis Miguel Castañeda
09:06 Re: Error trying to create a functional index. CoL
09:16 Re: create table with multiple unique fields elisabeth maniez
09:16 Re: Resources Tom Lane
09:16 Re: Conditional test steve boyle
09:16 Re: Postgres vs. Redhat DB Tom Lane
09:16 Uisng Procedures via JDBC Michaell Oxtoby
09:16 Meta Data/Schema/DDL Ty
09:16 nested inner join help Darryl M. Wolski
09:17 Re: SQL Joins steve boyle
09:26 Result sets from functions Kevin Zapico
09:26 Re: Error trying to create a functional index. CoL
09:26 Search The pg.pm Ali Gumus
09:26 Re: create table with multiple unique fields steve boyle
09:27 Re: Error trying to create a functional index. Jochem van Dieten
09:54 Re: who has lock on table/row Tom Lane
09:54 Re: Error trying to create a functional index. Jochem van Dieten
09:55 Re: Result sets from functions steve boyle
10:01 Re: Retrieving information from System Tables steve boyle
12:00 CREATE TABLE glitch -fix request for 7.2 Josh Berkus
14:14 Re: CREATE TABLE glitch -fix request for 7.2 Tom Lane
14:15 Long-running DELETE...WHERE... jboes@nexcerpt.com (Jeff Boes)
14:19 Re: CREATE TABLE glitch -fix request for 7.2 Bruce Momjian
16:39 Re: nested inner join help Josh Berkus
16:39 On delete cascade! pocm@rnl.ist.utl.pt (Paulo J. Matos)
16:49 Re: Uisng Procedures via JDBC Josh Berkus
16:49 Re: CREATE TABLE glitch -fix request for 7.2 Josh Berkus
16:59 Re: nested inner join help Tom Lane
17:09 Re: SQL Joins Tom Lane
17:09 Re: CREATE TABLE glitch -fix request for 7.2 Jason Earl
17:49 Re: Result sets from functions Jeff Eckermann
18:49 Re: nested inner join help Tom Lane
19:19 Re: On delete cascade! Stephan Szabo
20:29 Re: nested inner join help Josh Berkus
20:29 Re: Long-running DELETE...WHERE... Tom Lane
21:09 Re: Long-running DELETE...WHERE... Chester Carlton Young
22:59 Date Time calculation help Unnikrishnan Menon

15 January 2002

00:09 Re: Resources - Regular Expressions Gurudutt
01:39 Re: On delete cascade! Roberto Mello
01:59 Problem with the postgresql operator. KH Lim
05:49 Re: Problem with the postgresql operator. Oliver Elphick
06:59 Re: On delete cascade! Steve Boyle \(Roselink\)
07:59 Re: Date Time calculation help Steve Boyle \(Roselink\)
08:49 Hierarchical queries Paulo Rodrigues
10:09 Re: Resources - Regular Expressions Jeff Eckermann
11:49 Re: Hierarchical queries Wei Weng
11:49 Re: Hierarchical queries Paulo Rodrigues
11:59 Re: Hierarchical queries Josh Berkus
12:19 Re: Hierarchical queries Steve Boyle \(Roselink\)
14:29 Re: Long-running DELETE...WHERE... Frank Bax
14:29 Re: Problem with the postgresql operator. Josh Berkus

16 January 2002

00:09 Long-running DELETE jboes@nexcerpt.com (Jeff Boes)
00:29 Re: Long-running DELETE Stephan Szabo
00:49 Re: Long-running DELETE Tom Lane
02:19 psql bug: copy paste statements looses tab character Marius Andreiana
07:59 Count Total on a limited query? Koen Antonissen
08:39 Re: Long-running DELETE Jeff Boes
08:49 reforming query for 7.0.2 Markus Bertheau
09:59 limiting access to (through) views Glenn MacGregor
10:20 Re: limiting access to (through) views Stephan Szabo
10:30 Re: Long-running DELETE Stephan Szabo
10:39 Re: limiting access to (through) views Glenn MacGregor
10:39 Re: limiting access to (through) views Bruno Wolff III
10:49 Re: Count Total on a limited query? Wei Weng
10:59 Re: limiting access to (through) views Stephan Szabo
10:59 Re: psql bug: copy paste statements looses tab character Tom Lane
11:10 Re: limiting access to (through) views Glenn MacGregor
11:29 Re: psql bug: copy paste statements looses tab character Peter Eisentraut
11:29 Re: psql bug: copy paste statements looses tab character Peter Eisentraut
11:29 Re: reforming query for 7.0.2 Josh Berkus
14:49 Complex view question Glenn MacGregor
16:10 Re: Complex view question Glenn MacGregor
16:29 Re: Complex view question Josh Berkus
16:50 Re: Complex view question Glenn MacGregor
17:00 Re: Complex view question Josh Berkus

17 January 2002

00:59 Pattern Matching on Columns Bhuvan A
08:10 Re: reforming query for 7.0.2 Markus Bertheau
10:30 Re: Pattern Matching on Columns Jeff Eckermann
10:50 Union instead of Outer Join Unnikrishnan Menon
15:10 Re: Union instead of Outer Join Jeff Eckermann
15:20 Re: Union instead of Outer Join Bruno Wolff III
17:50 User Permissions Braum Meakes
18:20 Re: User Permissions SHELTON,MICHAEL (Non-HP-Boise,ex1)
18:30 Re: User Permissions Braum Meakes
18:40 Re: User Permissions Peter Eisentraut
18:49 Re: User Permissions chester c young
19:40 Re: User Permissions Tom Lane
19:40 Re: User Permissions Peter Eisentraut
20:00 UPDATE Query problem Josh Berkus
20:40 Re: UPDATE Query problem Tom Lane
20:40 Re: UPDATE Query problem Stephan Szabo
23:20 Re: User Permissions Jan Wieck
23:20 Re: UPDATE Query problem Tom Lane
23:20 Re: UPDATE Query problem Josh Berkus

18 January 2002

00:20 Re: UPDATE Query problem Josh Berkus
08:40 pltlc and pltlcu problems Murray Prior Hobbs
10:20 Re: pltlc and pltlcu problems Tom Lane
11:50 changing a definition in a dump file? postgresql
12:02 Re: changing a definition in a dump file? Stephan Szabo
14:01 psql bug: copy paste statements looses tab character Marius Andreiana
14:10 Re: Long-running DELETE...WHERE... Jochem van Dieten
14:30 pqFlush problem Glenn MacGregor
14:50 Re: Problem with the postgresql operator. GB Clark
15:00 Conditionally create table problem Wei Weng
15:30 Re: pltlc and pltlcu problems Murray Prior Hobbs
18:11 Re: UPDATE Query problem Josh Berkus
23:00 Re: pltlc and pltlcu problems Murray Prior Hobbs
23:30 Re: pltlc and pltlcu problems Tom Lane
23:40 oid in plpgsql trigger chester c young

19 January 2002

00:20 Re: oid in plpgsql trigger Tom Lane
02:50 Re: pltlc and pltlcu problems Murray Prior Hobbs
03:30 Re: pltlc and pltlcu problems Brent Verner
03:50 Re: pltlc and pltlcu problems Murray Prior Hobbs
04:01 Re: pltlc and pltlcu problems Murray Prior Hobbs
11:40 null = null chester c young
12:50 Re: pltlc and pltlcu problems Tom Lane
12:50 Re: null = null Tom Lane
14:10 table alias on update and delete query chester c young
15:20 Re: table alias on update and delete query Stephan Szabo

20 January 2002

02:50 Re: pltlc and pltlcu problems Murray Prior Hobbs

21 January 2002

04:21 list triggers ? Urs Steiner
14:42 Triggers Hunter, Ray
14:42 PGACCESS installation Unnikrishnan Menon
15:03 importing data from Filemaker: weird newline characters Frank Joerdens
15:03 support for transact-sql? Marius Andreiana
15:15 Re: list triggers ? Stephan Szabo
16:13 Re: support for transact-sql? Stephan Szabo
18:42 Re: importing data from Filemaker: weird newline characters Ross J. Reedstrom
19:42 Passing a list of pairs to a PL/PGSQL function David Stanaway
22:12 Re: Passing a list of pairs to a PL/PGSQL function David Stanaway
22:42 Re: Date Time calculation help Unnikrishnan Menon
23:12 Re: Passing a list of pairs to a PL/PGSQL function David Stanaway

22 January 2002

08:02 sharing data accross several databases bob lapique
10:52 Re: list triggers ? Urs Steiner
11:33 Re: list triggers ? Stephan Szabo
18:12 Re: sharing data accross several databases Josh Berkus
18:33 Re: sharing data accross several databases chester c young
19:12 Re: Passing a list of pairs to a PL/PGSQL function David Stanaway
20:22 Re: importing data from Filemaker: weird newline characters Frank Joerdens

23 January 2002

09:55 ERROR (Bug?) in RULE processing ? Fritz Lehmann-Grube
10:12 Re: importing data from Filemaker: weird newline characters Frank Joerdens
11:14 Re: ERROR (Bug?) in RULE processing ? Jan Wieck
11:14 Re: ERROR (Bug?) in RULE processing ? Tom Lane
13:45 Re: PGACCESS installation Oleg Lebedev
14:37 Re: PGACCESS installation Tom Lane
15:13 Re: importing data from Filemaker: weird newline characters Ross J. Reedstrom

24 January 2002

08:33 table name - TypeCreate error Felipe Nievinski
08:42 Re: table name - TypeCreate error Radu-Adrian Popescu
10:12 Re: table name - TypeCreate error Tom Lane
12:42 why can a named subselect not be used in a where condition? Markus Bertheau
13:13 auto group by Markus Bertheau
13:13 Re: why can a named subselect not be used in a where Josh Berkus
13:33 Re: why can a named subselect not be used in a where condition? Tom Lane
13:43 Keeping information changes history Marius Andreiana
13:43 Re: auto group by Andrew G. Hammond
14:13 Re: Keeping information changes history Tom Lane
15:53 linking from SQL Server Oleg Lebedev
20:13 Re: linking from SQL Server Steve Boyle \(Roselink\)
20:33 Re: linking from SQL Server Josh Berkus

25 January 2002

06:15 Good tutorial on plperl. Bhuvan A
10:13 Re: linking from SQL Server SHELTON,MICHAEL (Non-HP-Boise,ex1)
10:13 Arrays Question Achilleus Mantzios
11:13 LIMIT Optimization alexandre paes :: aldeia digital
11:43 Re: linking from SQL Server Josh Berkus
11:43 Complex column ref. Arve Fahlvik
12:43 Re: LIMIT Optimization Bruce Momjian
13:03 Re: LIMIT Optimization Tom Lane
13:13 Re: LIMIT Optimization Tom Lane
13:13 Re: LIMIT Optimization Bruce Momjian
13:14 Re: Arrays Question Oleg Bartunov
13:44 Re: LIMIT Optimization Oleg Bartunov
13:44 Re: LIMIT Optimization alexandre paes :: aldeia digital
14:43 Re: Good tutorial on plperl. Tom Lane
14:43 Re: LIMIT Optimization Bruce Momjian
15:13 Re: LIMIT Optimization Oleg Bartunov
17:13 Re: PGACCESS installation Unnikrishnan Menon

26 January 2002

12:43 Re: Resources Lg
13:13 Re: Resources Tom Lane
18:13 Re: LIMIT Optimization Bruce Momjian
19:03 interval and timestamp change? postgresql
19:33 update syntax chester c young
19:43 Re: update syntax Bruce Momjian
19:53 Re: interval and timestamp change? Chris Ruprecht
20:04 Re: interval and timestamp change? Brent Verner
22:13 Re: update syntax chester c young
22:43 Re: update syntax Bruce Momjian
23:13 options for no multiple rows? pgsql
23:13 Re: LIMIT Optimization Tom Lane
23:13 Re: interval and timestamp change? Tom Lane
23:33 Re: LIMIT Optimization Bruce Momjian

27 January 2002

03:54 Re: options for no multiple rows? Stephan Szabo
10:43 double quote handling? postgresql
11:03 Re: double quote handling? Peter Eisentraut
17:43 Re: LIMIT Optimization Ross J. Reedstrom

28 January 2002

08:43 Re: LIMIT Optimization Oleg Bartunov
13:14 Re: LIMIT Optimization Ross J. Reedstrom
13:44 Re: PGACCESS installation Jean-Luc Lachance
15:14 Re: options for no multiple rows? Jeff Eckermann
15:24 xbase2pg 1.0-1 vs postgres 7.2b5 compatibility Jean-Luc Lachance
16:45 Re: options for no multiple rows? Allan Engelhardt
17:14 Re: export/save meta data Allan Engelhardt

29 January 2002

06:05 get array data with range Johny Jugianto
19:14 Date Parse pocm@rnl.ist.utl.pt (Paulo J. Matos)
19:44 Re: Date Parse postgresql
19:54 Re: Date Parse Andrew G. Hammond
20:14 Re: Date Parse Chris Ruprecht
21:14 Re: [ADMIN] SQL Script David Stanaway

30 January 2002

07:55 psql and macOSX with 7.2b5 postgresql
10:36 Re: psql and macOSX with 7.2b5 Chris Ruprecht
14:48 Re: linking from SQL Server Oleg Lebedev
14:55 Re: psql and macOSX with 7.2b5 Tom Lane
19:05 Difference between Access97 and PostgreSQL Yan Bai
20:14 Re: Difference between Access97 and PostgreSQL Josh Berkus
20:35 Index Management pocm@rnl.ist.utl.pt (Paulo J. Matos)

31 January 2002

02:44 How to merge several attributes and Delete an attribute Yan Bai
03:15 Re: How to merge several attributes and Delete an attribute Christopher Kings-Lynne
05:55 working with sequences Alex Ott
07:47 Re: How to merge several attributes and Delete an attribute Tod McQuillin
10:45 Re: Difference between Access97 and PostgreSQL Roberto Mello
10:45 Regression tests failed on 7.2rc2 Radu-Adrian Popescu
11:41 Re: [ADMIN] Regression tests failed on 7.2rc2 Radu-Adrian Popescu
11:53 Re: Regression tests failed on 7.2rc2 Peter Eisentraut
12:06 Re: working with sequences Tom Lane
12:06 Re: Regression tests failed on 7.2rc2 Tom Lane
14:45 Re: How to merge several attributes and Delete an attribute Annie Bai
15:46 Re: How to merge several attributes and Delete an Josh Berkus
19:46 Re: Difference between Access97 and PostgreSQL Christopher Kings-Lynne