Home > mailing lists

Mailing lists [pgsql-sql]

1 January 2002

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

2 January 2002

17:45 Re: Tree structure index usage Josh Berkus

3 January 2002

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

4 January 2002

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

5 January 2002

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

6 January 2002

03:22 Re: simple? join Peter Eisentraut

7 January 2002

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

8 January 2002

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

9 January 2002

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

10 January 2002

00:04 Re: converting an epoch to a timestamp Tom Lane
12:15 Resources Gurudutt
13:55 Re: Resources Jason Earl
14:15 Re: Resources Stephan Szabo
14:26 Re: Resources Nick Fankhauser
18:35 Re: Resources Wei Weng
20:15 Re: Resources SHELTON,MICHAEL (Non-HP-Boise,ex1)
20:35 replication Peter T. Brown
21:15 Temporary tables SHELTON,MICHAEL (Non-HP-Boise,ex1)
21:15 Recall: Temporary tables SHELTON,MICHAEL (Non-HP-Boise,ex1)
21:55 Re: [ADMIN] replication David Stanaway

11 January 2002

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

12 January 2002

11:55 triggered data change violation Murray Prior Hobbs
14:25 Re: triggered data change violation Tom Lane
20:55 Re: triggered data change violation Murray Prior Hobbs

13 January 2002

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

14 January 2002

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

15 January 2002

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

16 January 2002

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

17 January 2002

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

18 January 2002

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

19 January 2002

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

20 January 2002

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

21 January 2002

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

22 January 2002

01:12 Re: Passing a list of pairs to a PL/PGSQL function David Stanaway
01:42 Re: Date Time calculation help Unnikrishnan Menon
02:12 Re: Passing a list of pairs to a PL/PGSQL function David Stanaway
11:02 sharing data accross several databases bob lapique
13:52 Re: list triggers ? Urs Steiner
14:33 Re: list triggers ? Stephan Szabo
21:12 Re: sharing data accross several databases Josh Berkus
21:33 Re: sharing data accross several databases chester c young
22:12 Re: Passing a list of pairs to a PL/PGSQL function David Stanaway
23:22 Re: importing data from Filemaker: weird newline characters Frank Joerdens

23 January 2002

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

24 January 2002

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

25 January 2002

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

26 January 2002

15:43 Re: Resources Lg
16:13 Re: Resources Tom Lane
21:13 Re: LIMIT Optimization Bruce Momjian
22:03 interval and timestamp change? postgresql
22:33 update syntax chester c young
22:43 Re: update syntax Bruce Momjian
22:53 Re: interval and timestamp change? Chris Ruprecht
23:04 Re: interval and timestamp change? Brent Verner

27 January 2002

01:13 Re: update syntax chester c young
01:43 Re: update syntax Bruce Momjian
02:13 options for no multiple rows? pgsql
02:13 Re: LIMIT Optimization Tom Lane
02:13 Re: interval and timestamp change? Tom Lane
02:33 Re: LIMIT Optimization Bruce Momjian
06:54 Re: options for no multiple rows? Stephan Szabo
13:43 double quote handling? postgresql
14:03 Re: double quote handling? Peter Eisentraut
20:43 Re: LIMIT Optimization Ross J. Reedstrom

28 January 2002

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

29 January 2002

09:05 get array data with range Johny Jugianto
22:14 Date Parse pocm@rnl.ist.utl.pt (Paulo J. Matos)
22:44 Re: Date Parse postgresql
22:54 Re: Date Parse Andrew G. Hammond
23:14 Re: Date Parse Chris Ruprecht

30 January 2002

00:14 Re: [ADMIN] SQL Script David Stanaway
10:55 psql and macOSX with 7.2b5 postgresql
13:36 Re: psql and macOSX with 7.2b5 Chris Ruprecht
17:48 Re: linking from SQL Server Oleg Lebedev
17:55 Re: psql and macOSX with 7.2b5 Tom Lane
22:05 Difference between Access97 and PostgreSQL Yan Bai
23:14 Re: Difference between Access97 and PostgreSQL Josh Berkus
23:35 Index Management pocm@rnl.ist.utl.pt (Paulo J. Matos)

31 January 2002

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