Mailing lists [pgsql-sql]

1 April 1999

• 01:49   How do I return values that begin with non-alphabet characters from a search? Robert Chalmers

9 April 1999

• 11:35   Nested subqueries in the target list Jens Glaser
• 11:38   Nested subqueries in the target list Jens Glaser
• 11:55   Re: [SQL] Nested subqueries in the target list Vadim Mikheev
• 12:24   Re: [SQL] how to retrieve... ZioBudda
• 22:37   Re: [SQL] how to retrieve... Ross J. Reedstrom

11 April 1999

• 22:30   aggregate functions and varchar type Will Benton
• 22:34   aggregate functions and varchar type Will Benton

12 April 1999

• 12:20   Re: [SQL] aggregate functions and varchar type José Soares
• 18:12   subqueries Walt Bigelow

13 April 1999

• 14:13   Trouble with null text fields! Glenn Waldron
• 14:20   Trouble with null text fields Glenn Waldron
• 14:39   Re: [SQL] subqueries Tom Lane
• 14:52   RE: [SQL] Trouble with null text fields Michael Davis
• 15:05   RE: [SQL] Trouble with null text fields Michael Davis
• 15:10   Re: [SQL] Trouble with null text fields José Soares
• 15:19   bug report on text text fields. WAS: Re: [SQL] Trouble with ... David Sauer
• 19:14   Re: [SQL] subqueries Walt Bigelow
• 22:32   Re: [SQL] subqueries Tom Lane

14 April 1999

• 07:45   inet problem Olivier BLONDEAU
• 09:03   external environment variable Randal Flagg
• 11:15   Re: [SQL] inet problem D'Arcy" "J.M." Cain
• 11:52   Re: [SQL] inet problem Olivier BLONDEAU
• 12:43   Re: [SQL] external environment variable José Soares

15 April 1999

• 13:55   Re: [SQL] external environment variable Tom Lane
• 17:21   [SQL] OUTER JOINS Dan Janowski
• 19:11   [SQL] OUTER JOINS Dan Janowski

16 April 1999

• 01:24   ... Lucas Di Pentima
• 01:25   ... Lucas Di Pentima
• 07:48   Update on 6.5 Chairudin Sentosa
• 12:11   UPDATE subselect? Chris Bitmead
• 13:12   Re: [SQL] Update on 6.5 José Soares
• 14:01   Re: [SQL] UPDATE subselect? José Soares
• 14:28   Re: [SQL] UPDATE subselect? Chris Bitmead
• 15:34   RE: [SQL] UPDATE subselect? Jackson, DeJuan
• 15:38   How to compare Datetime Henrik Pedersen
• 17:40   php for pgsql for windows Dr. Alexey A. Terent'ev
• 20:24   Strange behaviour with date costants.... Daniele Orlandi

17 April 1999

• 13:01   ... Ady-55
• 14:47   Re: [SQL] How to compare Datetime Tom Lane
• 23:52   Impossible query with SQL? or not? david

18 April 1999

• 00:37   PL/TCL and NULL values Daniele Orlandi
• 16:52   Re: [SQL] Trouble with null text fields! Tom Lane
• 17:14   Case insensitive searchs Andy Lewis
• 17:18   Re: [SQL] Case insensitive searchs Gregory W Burnham
• 17:31   Re: [SQL] Case insensitive searchs Andy Lewis
• 17:44   Re: [SQL] Case insensitive searchs reedstrm@wallace.ece.rice.edu (Ross J. Reedstrom)
• 17:51   Re: [SQL] Case insensitive searchs reedstrm@wallace.ece.rice.edu (Ross J. Reedstrom)
• 17:58   Re: [SQL] Case insensitive searchs Andy Lewis
• 22:37   postgres 6.3.2 and regexp Bill Brandt

19 April 1999

• 05:25   Re: [SQL] OUTER JOINS Joe Shevland
• 12:27   Re: [SQL] OUTER JOINS Dan Janowski
• 12:39   Re: [SQL] postgres 6.3.2 and regexp Tom Lane
• 14:20   RE: [SQL] OUTER JOINS Michael J Davis
• 14:22   RE: [SQL] OUTER JOINS Michael J Davis
• 15:25   Re: [SQL] Case insensitive searchs D'Arcy" "J.M." Cain
• 16:31   Re: [SQL] postgres 6.3.2 and regexp Guido Piazzi
• 17:13   VACUUM in a trigger Brett W. McCoy
• 19:14   6.4.2 and LEFT/RIGHT OUTER JOIN Giovanni Battista, Stefanoni
• 20:37   Re: [SQL] VACUUM in a trigger Brian
• 21:21   problem when vacuuming. . . JT Kirkpatrick

20 April 1999

• 01:14   FW: [SQL] OUTER JOINS Michael J Davis
• 01:14   RE:[SQL] OUTER JOINS Michael J Davis
• 01:38   RE: [SQL] OUTER JOINS Michael J Davis
• 01:38   RE: [SQL] OUTER JOINS Michael J Davis
• 02:41   Re: [SQL] OUTER JOINS Joe Shevland
• 04:34   RE: [SQL] OUTER JOINS Michael J Davis
• 08:18   Questions about embedded-sql! Anna Langer
• 11:31   Re: [SQL] Questions about embedded-sql! Magnum Ind. da Amazonia S/A
• 13:01   Re: [GENERAL] problem when vacuuming. . . Karl DeBisschop
• 13:23   Re: [SQL] Questions about embedded-sql! Maarten Boekhold
• 13:36   Re: [SQL] Questions about embedded-sql! Tom Lane
• 14:11   SELECT LIMIT not working with unions? Dirk Lutzebaeck
• 15:25   null values to be replaced by a default value Nuchanard Chiannilkulchai
• 16:17   RE: [SQL] null values to be replaced by a default value Michael J Davis
• 16:21   Re: [SQL] null values to be replaced by a default value Tom Lane
• 17:56   TUPLES <> HEAP JT Kirkpatrick

21 April 1999

• 00:37   Re: [SQL] Update on 6.5 Chairudin Sentosa
• 11:48   Re: [SQL] Update on 6.5 José Soares
• 14:43   perl and postgres. . . JT Kirkpatrick
• 15:08   Re: [SQL] perl and postgres. . . Brett W. McCoy
• 17:31   convert text to number or number to text JT Kirkpatrick

22 April 1999

• 09:16   default in ALTER Àíäðåé Íîâèêîâ
• 10:35   Re: [SQL] default in ALTER George Moga
• 12:55   Re: [SQL] convert text to number or number to text José Soares
• 12:55   Re: [SQL] convert text to number or number to text José Soares
• 13:05   UNION with grouping? Bill Carlson
• 13:14   Finding the "most recent" rows Julian Scarfe
• 13:34   SELECT TOP _x_ ?? Justin Long
• 13:43   Re: [SQL] SELECT TOP _x_ ?? Chris Bitmead
• 13:45   Re: [SQL] Finding the "most recent" rows Chris Bitmead
• 13:50   Re: [SQL] Finding the "most recent" rows George Moga
• 13:57   RE: [SQL] Finding the "most recent" rows Michael J Davis
• 14:30   Re: [SQL] Finding the "most recent" rows Tom Lane
• 16:22   sum of two queries Kyle Bateman
• 16:31   ... Daniel Facciolo Pires
• 16:53   RE: [SQL] sum of two queries Michael J Davis
• 17:11   Re: [SQL] sum of two queries Kyle Bateman
• 17:52   Re: [SQL] Finding the "most recent" rows Brook Milligan
• 17:53   SELECT TOP X -- part 2 -- parse error? Justin Long
• 19:27   Index on date_trunc Christophe Labouisse
• 19:30   backend closing channel unexpectedly JT Kirkpatrick
• 20:17   RE: [SQL] SELECT TOP X -- part 2 -- parse error? Michael J Davis
• 20:24   Re: [SQL] sum of two queries G. Anthony Reina
• 20:24   RE: [SQL] SELECT TOP X -- part 2 -- parse error? Justin Long
• 20:47   Changing the editor for the \e option G. Anthony Reina
• 20:47   RE: [SQL] SELECT TOP X -- part 2 -- parse error? Michael J Davis
• 21:00   Re: [SQL] Changing the editor for the \e option Brett W. McCoy
• 21:02   Re: [SQL] Changing the editor for the \e option John M. Flinchbaugh
• 21:13   Re: [SQL] Changing the editor for the \e option G. Anthony Reina
• 22:56   Re: [SQL] Finding the "most recent" rows Chris Bitmead
• 23:04   Replacing PREPARE Paul E Stephens
• 23:04   Replacing PREPARE Paul E Stephens
• 23:17   Re: [SQL] SELECT TOP X -- part 2 -- parse error? Chris Bitmead
• 23:46   Re: [SQL] Finding the "most recent" rows Tom Lane

23 April 1999

• 01:48   Re: [SQL] Finding the "most recent" rows Chris Bitmead
• 01:48   Re: [SQL] SELECT TOP _x_ ?? Chris Bitmead
• 01:50   Re: [SQL] Finding the "most recent" rows Chairudin Sentosa
• 01:52   Re: [SQL] SELECT TOP _x_ ?? Chairudin Sentosa
• 01:58   Re: [SQL] Finding the "most recent" rows Chairudin Sentosa
• 01:58   Re: [SQL] Finding the "most recent" rows Chris Bitmead
• 03:09   Re: [SQL] Finding the "most recent" rows Tom Lane
• 03:11   Re: [SQL] Finding the "most recent" rows Brook Milligan
• 03:37   Re: [SQL] Finding the "most recent" rows Chris Bitmead
• 09:30   Re: [SQL] Finding the "most recent" rows Julian Scarfe
• 13:33   Re: [SQL] SELECT TOP X -- part 2 -- parse error? José Soares
• 13:35   FW: [SQL] SELECT TOP _x_ ?? Justin Long
• 13:43   Re: [SQL] Finding the "most recent" rows Brook Milligan
• 14:05   Large objects - bug? caveat? feature? Justin Long
• 15:06   Re: [SQL] Finding the "most recent" rows Tom Lane
• 15:31   Re: [SQL] Finding the "most recent" rows Tom Lane
• 18:43   Re: [HACKERS] Re: [SQL] Finding the "most recent" rows Bruce Momjian
• 19:09   what is "cost"? Gregory Holston
• 20:24   Re: [SQL] what is "cost"? Bruce Momjian
• 20:27   Re: [SQL] what is "cost"? Gregory Holston
• 20:29   Re: [SQL] what is "cost"? Bruce Momjian

24 April 1999

• 01:59   Re: [SQL] Large objects - bug? caveat? feature? Chris Bitmead
• 15:12   Percentages? Chris Bitmead

25 April 1999

• 08:23   Confusion about DISTINCT. Chris Bitmead
• 14:12   Relating 1 table to another. Nigel Tamplin
• 15:23   Re: [SQL] Confusion about DISTINCT. Tom Lane
• 15:48   Re: [SQL] Relating 1 table to another. Tom Lane
• 16:10   PL/pgsql questions.. tveith@heaven.oeh.univie.ac.at
• 17:04   Primary Key Bugs Tim Perdue

26 April 1999

• 06:45   Re: [SQL] PL/pgsql questions.. jwieck@debis.com (Jan Wieck)
• 12:01   Re: [SQL] Primary Key Bugs José Soares
• 14:50   substring Nuchanard Chiannilkulchai
• 14:55   CURRVAL(INDEX) Justin Long
• 18:39   RE: [SQL] substring Michael J Davis
• 18:40   Strange behavior Christophe Labouisse
• 20:25   Re: [SQL] Strange behavior Tom Lane

27 April 1999

• 05:07   Re: [SQL] Strange behavior Christophe Labouisse
• 08:08   Re: [SQL] substring Nuchanard Chiannilkulchai
• 08:12   Re: [SQL] Percentages? Nuchanard Chiannilkulchai
• 11:58   Re: [SQL] Percentages? José Soares
• 12:03   Re: [SQL] substring José Soares
• 12:49   Arrays and count () Mr M Pacey
• 13:04   Arrays and count() Mr M Pacey
• 13:11   RE: [SQL] substring Michael J Davis
• 13:26   rules help Brook Milligan
• 13:31   Re: [SQL] Strange behavior Tom Lane
• 13:37   Re: [SQL] substring Tom Lane
• 14:08   Re: [SQL] Arrays and count() Tom Lane
• 14:43   Re: [SQL] rules help jwieck@debis.com (Jan Wieck)
• 15:29   Re: [SQL] substring José Soares
• 16:21   Re: [SQL] rules help Brook Milligan
• 17:37   Re: [SQL] Strange behavior Christophe Labouisse
• 18:55   filling an empty table w/ defaults defined JT Kirkpatrick
• 19:11   incrementing by the second JT Kirkpatrick
• 19:37   RE: [SQL] filling an empty table w/ defaults defined Jackson, DeJuan
• 19:40   RE: [SQL] incrementing by the second Jackson, DeJuan
• 20:14   RE: [SQL] incrementing by the second JT Kirkpatrick
• 20:56   Re: [SQL] Strange behavior Tom Lane

28 April 1999

• 04:27   Re: [SQL] Strange behavior Christophe Labouisse
• 11:55   Re: [SQL] substring Nuchanard Chiannilkulchai
• 14:58   Re: [SQL] OUTER JOINS Herouth Maoz
• 19:55    Eric Vernichon

29 April 1999

• 04:24   LIMIT Mr. Poet
• 04:45   Re: [SQL] LIMIT Chris Bitmead
• 07:04   Re: [SQL] LIMIT Dirk Lutzebaeck
• 08:24   Re: [SQL] LIMIT Mark Jewiss
• 09:04   Re: [SQL] Finding the "most recent" rows Herouth Maoz
• 09:29   Re: [SQL] Finding the "most recent" rows Herouth Maoz
• 10:00   Re: [SQL] Relating 1 table to another. Herouth Maoz
• 12:32   Re: [SQL] LIMIT José Soares
• 13:28   Re: [SQL] Finding the "most recent" rows Chris Bitmead
• 14:03   Re: [SQL] Finding the "most recent" rows Herouth Maoz
• 16:51   Limit Questions 2 Mr. Poet
• 17:37   RE: [SQL] Limit Questions 2 Jackson, DeJuan
• 17:50   why i couldn't insert. . . JT Kirkpatrick
• 19:11   time intervals JT Kirkpatrick
• 23:04   Re: [SQL] Limit Questions 2 Chris Bitmead

30 April 1999

• 01:24   OT: It's Official Mr. Poet
• 04:25   [SQL] Index on date_trunc Christophe Labouisse
• 07:10   Re: [SQL] time intervals Mark Jewiss
• 08:56   Re: [SQL] time intervals George Moga
• 12:04   Re: [SQL] time intervals José Soares
• 12:22   RE: [SQL] time intervals JT Kirkpatrick
• 13:29   finding the most recent records JT Kirkpatrick
• 13:55   Re: [SQL] finding the most recent records Mark Jewiss
• 14:39   RE: [SQL] Limit Questions 2 Jackson, DeJuan
• 14:57   combining a single field in two tables into one column. JT Kirkpatrick
• 15:02   RE: [SQL] combining a single field in two tables into one column. Jackson, DeJuan
• 15:07   RE: [SQL] combining a single field in two tables into one column. JT Kirkpatrick
• 15:11   Re: [SQL] finding the most recent records Tom Lane
• 15:15   Re: [SQL] combining a single field in two tables into one column. Chris Bitmead