Home > mailing lists

Mailing lists [pgsql-sql]

1 March 1999

04:39 Re: pgsql-sql-digest V1 #155 Andru Luvisi
05:16 Re: pgsql-sql-digest V1 #155 luvisi@andru.sonoma.edu (Andru Luvisi)
16:07 RE: [SQL] Simple Question?? Michael Davis
20:02 6.4.x to 6.5 pierre@desertmoon.com

2 March 1999

02:36 Staus of Primary/Foreign key? Stan Brown
04:02 Semantics of LIKE Craig Johannsen
08:09 Persistent connection in PostGresSQL CIMPOESU Teodor
09:26 FW: indexing functions Bas Peters
09:51 CREATE TABLE - DEFAULT Ingrith Andrea Correa Vargas
16:54 Commit Daniel Facciolo Pires
17:04 Commit Daniel Facciolo Pires
17:16 COMMIT Daniel Facciolo Pires
18:48 Re: [SQL] Staus of Primary/Foreign key? jwieck@debis.com (Jan Wieck)
20:07 RULE problem mueller@pmsun20.dial.eunet.ch (Pascal Mueller)

3 March 1999

01:01 question about pg_dump Bill Brandt
02:40 Undeliverable Message
13:06 Trees in SQL (again) Bartek Teodorczyk
13:20 Re: [SQL] Trees in SQL (again) jwieck@debis.com (Jan Wieck)
13:26 Re: question about pg_dump Tom Lane
15:21 A dillema ... Mario Jorge Nunes Filipe
15:28 return types in functions Brett W. McCoy
19:46 FW: Trees in SQL Jackson, DeJuan

4 March 1999

11:22 Back end crash during vacuum Tim Perdue
11:26 Correction - not crash Tim Perdue
13:10 Re: [SQL] Correction - not crash G. Anthony Reina
16:09 Minimal rights Pavel PaJaSoft Janousek
17:15 Description of lo_import and lo_export Ing. Roberto Andrade

5 March 1999

09:53 rules Remigiusz Sokolowski
12:29 Hello & create rule question Emils Klotins
13:52 Re: [SQL] rules jwieck@debis.com (Jan Wieck)
13:59 Re: [SQL] rules Emils Klotins
14:41 Re: [SQL] Hello & create rule question jwieck@debis.com (Jan Wieck)
18:08 [SQL] CREATE TABLE (fwd ): again! Ingrith Andrea Correa Vargas
20:14 Re: [SQL] CREATE TABLE (fwd ): again! Gene Selkov Jr.
20:47 Re: [SQL] CREATE TABLE (fwd ): again! owner-pgsql-sql@postgreSQL.org: BOUNCE pgsql-sql@postgreSQL.org Gene Selkov Jr.
22:37 Number of parameters in a sql function Stan Ng

6 March 1999

04:43 How to sort date Zhenhua
06:42 ER, OMT chart of a database Martin Möderndorfer
12:24 Re: [SQL] How to sort date Brett W. McCoy
12:29 [SQL] Relations Fernando Carvalho
14:55 Re: [SQL] CREATE TABLE (fwd ): again! Tom Lane
15:21 Re: Number of parameters in a sql function Tom Lane

7 March 1999

01:26 Re: [SQL] 6.4.x to 6.5 Bruce Momjian
22:06 "typedef" in Pstgresql? Zalman Stern
22:21 "typedef" in Pstgresql? Zalman Stern

8 March 1999

00:23 Help: insert inheritance class Weon-sun Lee
02:38 PostgreSQL EndTransactionBlock and not inprogress/abort state Manuel Lemos
05:30 Re: [SQL] rules Remigiusz Sokolowski
11:44 unsubscribe pgsql-sql Viorel Anghel
17:21 6.4.x vs. 6.5 oddity pierre@desertmoon.com
17:29 Re: [SQL] 6.4.x vs. 6.5 oddity Bruce Momjian
17:34 Re: [SQL] 6.4.x vs. 6.5 oddity Bruce Momjian
17:53 Re: [SQL] 6.4.x vs. 6.5 oddity reedstrm@wallace.ece.rice.edu (Ross J. Reedstrom)
18:16 Re: [SQL] 6.4.x vs. 6.5 oddity pierre@desertmoon.com
18:23 Re: [SQL] 6.4.x vs. 6.5 oddity Bruce Momjian

9 March 1999

10:49 time comparing Remigiusz Sokolowski
10:55 Re: [SQL] time comparing Patrik Kudo
11:11 Re: [SQL] time comparing Remigiusz Sokolowski
16:32 How to optimize a query... secret
16:39 help Fernezelyi Marton
16:56 Re: [SQL] How to optimize a query... Ross J. Reedstrom
23:34 Performance Tim Perdue

10 March 1999

00:33 Re: [SQL] Performance Clark Evans
00:50 Re: [SQL] Performance Karl Denninger
00:50 Re: [SQL] Performance Brett W. McCoy
01:11 Re: [SQL] Performance D'Arcy" "J.M." Cain
01:15 Re: [SQL] Performance Tim Perdue
01:24 Re: [SQL] Performance Jason Slagle
01:31 Re: [SQL] Performance Karl Denninger
01:35 Re: [SQL] Performance Tim Perdue
01:42 Re: [SQL] Performance Brett W. McCoy
11:15 shared tables Remigiusz Sokolowski
13:28 Re: How to optimize a query... Tom Lane
13:38 Re: [SQL] Performance Tom Lane
13:38 Re: [SQL] How to optimize a query... secret
15:04 DISTINCT within aggregates. Stuart Rison
16:27 Re: [SQL] Performance Jason Slagle
16:36 Re: [SQL] Performance Karl Denninger
16:39 Re: [SQL] Performance Jason Slagle
16:42 Re: [SQL] Performance G. Anthony Reina
16:46 Re: [SQL] Performance Karl Denninger
16:51 Re: [SQL] Performance Jason Slagle
16:57 HJ#####.# pierre@desertmoon.com
17:29 Re: [SQL] Performance Bruce Momjian
18:15 RE: [HACKERS] Bug on complex subselect (was: Bug on complex join) Jackson, DeJuan
19:02 How match percent sign in SELECT using LIKE? Dan Lauterbach
19:52 Recording Date,Time and UserId when a record is modified Sue Hanen
19:59 Re: [SQL] Re: How to optimize a query... -- Extreme performance difference, same EXPLAIN secret
20:02 How match percent sign in SELECT using LIKE? Dan Lauterbach

11 March 1999

03:01 Stored Procedure FAQ Joe Shevland
04:07 unsubscribe Vikrant Rathore
06:44 Re: [SQL] How match percent sign in SELECT using LIKE? Ulf Mehlig
12:21 Re: SQL92 standard conformance [was Re: [SQL] OUTER JOINS in 6.4.2?? Work around?? Herouth Maoz
15:02 Very disappointing performance -- All Indexes Ignored. secret
15:36 Re: [SQL] Very disappointing performance -- All Indexes Ignored. Bruce Momjian
17:31 Re: [SQL] Very disappointing performance -- All Indexes Ignored. secret
18:17 Re: [SQL] Very disappointing performance -- All Indexes Ignored. Bruce Momjian
18:33 Re: [SQL] Staus of Primary/Foreign key? Bruce Momjian

12 March 1999

02:28 sum gives different answer Chairudin Sentosa
03:23 sum gives different answer Chairudin Sentosa
05:14 sum gives different answer Chairudin Sentosa
07:41 Re: [SQL] sum gives different answer George Moga
10:59 where can I get... ZioBudda
13:58 Re: Very disappointing performance -- All Indexes Ignored. Tom Lane
16:55 Re: [SQL] Re: Very disappointing performance -- All Indexes Ignored. secret
21:36 So what happens at 2GB? Tim Perdue
21:56 Re: [SQL] So what happens at 2GB? Karl Denninger

13 March 1999

07:53 Backend closes caused by query on a view?! Viktor A.
14:06 Re: [SQL] Backend closes caused by query on a view?! Bruce Momjian
14:22 OT: Modeling Tools Clark Evans
16:08 Re: [SQL] So what happens at 2GB? Brett W. McCoy
16:08 unsubscribe Ana Badillo
18:17 Re: [SQL] So what happens at 2GB? Karl Denninger
18:27 Re: [SQL] So what happens at 2GB? Brett W. McCoy

14 March 1999

02:48 URGENT - "CANNOT EXTEND" Tim Perdue
03:07 Re: [HACKERS] URGENT - "CANNOT EXTEND" Bruce Momjian
03:58 Re: [HACKERS] URGENT - "CANNOT EXTEND" Tim Perdue
04:38 install problem Eric J McKeown
07:11 Re: [SQL] "typedef" in Pstgresql? Clark Evans
08:25 Re: [HACKERS] URGENT - "CANNOT EXTEND" Peter T Mount
15:48 Re: [SQL] So what happens at 2GB? Tom Lane
16:04 Re: sum gives different answer Tom Lane
16:14 Re: [SQL] Re: sum gives different answer Clark Evans

15 March 1999

07:19 Mail about FOREIGN KEY Vikrant Rathore
12:54 Re: [HACKERS] Re: [SQL] Functional Indexes Bruce Momjian
13:10 Re: [SQL] install problem Tom Lane
13:31 Re: [SQL] install problem Eric J McKeown
13:46 Re: [SQL] How match percent sign in SELECT using LIKE? Bruce Momjian
22:41 Re: [SQL] Re: [HACKERS] URGENT - Tim Perdue
23:51 Re: [SQL] Re: [HACKERS] URGENT - Bruce Momjian

16 March 1999

05:14 Re: pgsql-sql-digest V1 #169 Jaap Willems
09:51 Re: [SQL] How match percent sign in SELECT using LIKE? Herouth Maoz
10:39 Setting Next Value in Sequence Tim Perdue
11:00 Re: [SQL] Setting Next Value in Sequence Remigiusz Sokolowski
11:02 Re: [SQL] Setting Next Value in Sequence Herouth Maoz
11:13 Re: [SQL] Setting Next Value in Sequence Tim Perdue
11:22 Re: [SQL] Setting Next Value in Sequence Patrik Kudo
11:22 Re: [SQL] Setting Next Value in Sequence Herouth Maoz
11:27 Re: [SQL] Setting Next Value in Sequence Remigiusz Sokolowski
12:20 Re: [SQL] Setting Next Value in Sequence Tim Perdue
18:31 Re: [SQL] How match percent sign in SELECT using LIKE? Bruce Momjian
18:54 Re: [SQL] How match percent sign in SELECT using LIKE? Zalman Stern
20:30 Re: [SQL] How match percent sign in SELECT using LIKE? Bruce Momjian
20:58 Re: [SQL] How match percent sign in SELECT using LIKE? Zalman Stern
21:05 Re: [SQL] How match percent sign in SELECT using LIKE? Bruce Momjian

17 March 1999

07:57 Re: [SQL] How match percent sign in SELECT using LIKE? Herouth Maoz
11:35 Problems with OUTER JOIN - UNION ..... Angelo CONFLITTI
11:45 Problems with OUTER JOIN - UNION ...... Angelo CONFLITTI
14:04 Problems with OUTER JOIN - UNION ... and so on .. Angelo CONFLITTI
14:31 Re: [SQL] How match percent sign in SELECT using LIKE? Bruce Momjian
21:04 unsubscribe Bill Barber

18 March 1999

07:35 pgsql-sql@postgresql.org Frederic Nourry
17:39 Vacuum Tim Stoddard
17:58 Re: [SQL] Vacuum Sascha Schumann
18:06 Re: [SQL] Vacuum Sascha Schumann
18:32 Re: [SQL] Vacuum Bruce Momjian
21:45 Stuck on SQL - Any Takers? Tim Perdue
23:51 Re: [SQL] Stuck on SQL - Any Takers? Matthew Diesch

19 March 1999

00:34 Re: [SQL] Stuck on SQL - Any Takers? Tim Perdue
01:16 Re: [SQL] Stuck on SQL - Any Takers? twm139@its.to
02:15 Re: [SQL] Stuck on SQL - Any Takers? Tim Perdue
13:22 Re: Stuck on SQL - Any Takers? Tom Lane
14:22 Re: [SQL] Re: Stuck on SQL - Any Takers? David Martinez Cuevas
19:15 compound key MESZAROS Attila
19:24 Re: [SQL] compound key Brett W. McCoy
19:25 ... Ismail Kizir

20 March 1999

09:38 string containing (') Atika
11:01 Re: [SQL] string containing (') Bruce Momjian
12:31 [SQL] Restore deleted records Eugenia Bulakh
14:07 Re: [SQL] string containing (') Brian Baquiran
20:41 ... Robert McArthur
20:43 ... Robert McArthur

21 March 1999

22:58 Re: [SQL] string containing (') Peter Garner

22 March 1999

10:33 Re: [SQL] string containing (') Herouth Maoz

23 March 1999

13:33 Simple Optimization Problem secret
16:05 transaction-lock? Forgacs Tamas
17:01 DEFAULT TEXT 'now' Roberto Joao Lopes Garcia

24 March 1999

05:05 Re: [SQL] DEFAULT TEXT 'now' Howie
05:18 Re: [SQL] DEFAULT TEXT 'now' tolik@icomm.ru (Anatoly K. Lasareff)
10:41 Re: [SQL] transaction-lock? Herouth Maoz
14:26 Re: [SQL] DEFAULT TEXT 'now' Ross J. Reedstrom
17:40 Comparing Dates to Current Time Jenny DiBartolomeo
17:59 Comparing Dates to Current Time Jenny DiBartolomeo
18:16 Use of 'default TEXT now()' Ing. Roberto Andrade
19:12 RE: [SQL] Comparing Dates to Current Time Jackson, DeJuan
19:14 RE: [SQL] Use of 'default TEXT now()' Jackson, DeJuan
19:21 RE: [SQL] Comparing Dates to Current Time Michael Davis
19:28 RE: [SQL] Use of 'default TEXT now()' Ing. Roberto Andrade
19:51 Re: [SQL] Use of 'default TEXT now()' Rich Shepard
20:00 RE: [SQL] Use of 'default TEXT now()' Jackson, DeJuan
20:01 types and subtypes Ingrith Andrea Correa Vargas
20:27 RE: [SQL] types and subtypes Jackson, DeJuan

25 March 1999

01:13 Help with query Oleg Bartunov
02:43 Undeliverable Message
04:35 sql 92 support in postgres Eric Enockson
14:24 subscribe Eddie
14:54 [SQL] Subselect has too many or too few fields Oleg Bartunov
19:39 RE: [SQL] Subselect has too many or too few fields Jackson, DeJuan

26 March 1999

01:46 Odd "problem", not sure if there is a solution .... The Hermit Hacker
14:29 RE: [SQL] Odd "problem", not sure if there is a solution .... Jackson, DeJuan
18:08 Re: [SQL] Odd "problem", not sure if there is a solution .... secret
19:11 newbie question about type conversions Andrew Douglas
19:39 newbie question about type conversions Andrew Douglas

28 March 1999

13:46 Re: [SQL] Odd "problem", not sure if there is a solution .... Herouth Maoz
15:23 Re: [GENERAL] Determining if "in a text set" Herouth Maoz
15:43 Re: [SQL] Re: [GENERAL] Determining if "in a text set" Herouth Maoz
16:14 Re: [SQL] Re: [GENERAL] Determining if "in a text set" Richi Plana
16:59 Re: [GENERAL] Determining if "in a text set" Richi Plana
17:15 Re: [SQL] Re: [GENERAL] Determining if "in a text set" Richi Plana

29 March 1999

06:29 inheritance and selection Francois TETE
06:33 inheritance and update Francois TETE
06:40 Inheritance and update Francois TETE
06:40 Inheritance and selection Francois TETE
08:33 Re: [GENERAL] Determining if "in a text set" Herouth Maoz
08:50 IIF.. Eduardo Noeda
09:01 pgsql and function results erikp
11:44 Newbie question about datatype conversion Andrew Douglas
18:19 union on views Gregory Holston
18:30 RE: [SQL] union on views Jackson, DeJuan
19:38 Re: [SQL] IIF.. Clark Evans
21:00 Re: [SQL] union on views] Bruce Momjian
21:29 RE: [SQL] IIF.. Jackson, DeJuan
22:05 Re: [SQL] IIF.. Clark Evans
22:31 RE: [SQL] IIF.. Jackson, DeJuan

30 March 1999

01:29 indexing a datetime by date Andrew Merrill
02:07 RE: [SQL] indexing a datetime by date Jackson, DeJuan
04:12 Re: [SQL] indexing a datetime by date Thomas Lockhart
09:49 Re: [GENERAL] Returning an integer from a date Herouth Maoz
09:57 RE: [SQL] indexing a datetime by date Herouth Maoz
11:58 Re: [GENERAL] sorting by date & time in descending order ?? Herouth Maoz
12:57 Re: [GENERAL] How to do this in SQL? Herouth Maoz
13:05 Re: [GENERAL] How to do this in SQL? Chris Bitmead
13:12 Re: [GENERAL] How to do this in SQL? Herouth Maoz
14:00 Date operation efficiency Oliver Smith
14:33 Re: [SQL] indexing a datetime by date Tom Lane
15:21 RE: [SQL] indexing a datetime by date Jackson, DeJuan
15:28 Re: [SQL] indexing a datetime by date Andrew Merrill
15:33 RE: [SQL] indexing a datetime by date Jackson, DeJuan
15:45 regexp strangeness Andrew Merrill
16:13 Re: [SQL] indexing a datetime by date Andrew Merrill
18:36 Selecting and deleting duplicate rows Clark Evans

31 March 1999

02:34 TO_CHAR or TO_DATE Chairudin Sentosa
04:12 Re: [SQL] Odd "problem", not sure if there is a solution .... Chairudin Sentosa
11:09 merging date and time Marco.Iannacone@DEU.dupont.com
11:09 merging date and time Marco.Iannacone@DEU.dupont.com
12:09 merging date and time miannaco@csc.com
12:31 Re: [SQL] TO_CHAR or TO_DATE Clark Evans
12:42 error -dl- ZioBudda
13:57 Help Kaza
14:01 Re: [SQL] merging date and time Ross J. Reedstrom
14:16 Re: [SQL] merging date and time Oliver Smith
14:54 RE: [SQL] Odd "problem", not sure if there is a solution .... Jackson, DeJuan
17:36 select ... from (select .. from where.. ) where ... ? MESZAROS Attila
18:04 Re: [SQL] select ... from (select .. from where.. ) where ... ? Clark Evans
18:55 Retrieving the record not matched with a join. Frans de Wet
19:06 RE: [SQL] Retrieving the record not matched with a join. Jackson, DeJuan
22:57 Finding strange patters Richi Plana