Mailing lists [pgsql-sql]

1 September 2004

• 05:13   Re: casting BOOL to somthng sad
• 05:20   Re: casting BOOL to somthng sad
• 05:25   Re: casting BOOL to somthng Stephan Szabo
• 06:32   Re: casting BOOL to somthng sad
• 06:39   Re: casting BOOL to somthng Michael Glaesemann
• 06:46   Re: casting BOOL to somthng sad
• 06:59   Re: casting BOOL to somthng Peter Eisentraut
• 07:04   Re: casting BOOL to somthng Michael Glaesemann
• 07:16   Re: casting BOOL to somthng Stephan Szabo
• 07:18   Re: casting BOOL to somthng sad
• 07:22   Re: casting BOOL to somthng Stephan Szabo
• 07:34   casting UNKNOWN to REGCLASS sad
• 10:25   Re: casting BOOL to somthng Geoffrey
• 14:02   German "umlaut insensitive" query Robert Strötgen
• 14:20   Re: casting BOOL to somthng Tom Lane
• 14:33   Re: casting BOOL to somthng Stephan Szabo
• 14:37   Re: German "umlaut insensitive" query Michael Kleiser
• 15:14   Extracting fieldnames from a TABLE Erik Wasser
• 15:17   Re: German "umlaut insensitive" query Robert Strötgen
• 15:59   Re: colored PL with emacs John DeSoi
• 16:28   Re: Extracting fieldnames from a TABLE Thomas F.O'Connell
• 20:27   Defining Field Types with view Traci Sumpter
• 22:41   Re: Defining Field Types with view Tom Lane

2 September 2004

• 13:16   copy old column's values to new column 
• 13:42   Re: copy old column's values to new column Bruno Wolff III
• 14:29   PRIMARY KEY and INDEX Nosyman
• 14:36   Re: PRIMARY KEY and INDEX Achilleus Mantzios
• 14:48   Re: PRIMARY KEY and INDEX Devrim GUNDUZ
• 15:03   Re: Complicated "group by" question Jeff Boes

5 September 2004

• 20:53   Full access to a DB with a second user? Erik Wasser
• 21:38   Storing properties in a logical way. Daniel M.
• 21:51   Re: Storing properties in a logical way. Pierre-Frédéric Caillaud

6 September 2004

• 02:57   INFORMATION_SCHEMA and foreign keys Troels Arvin
• 03:29   Re: INFORMATION_SCHEMA and foreign keys Stephan Szabo
• 06:13   Re: INFORMATION_SCHEMA and foreign keys Tom Lane
• 10:25   Re: Full access to a DB with a second user? Oliver Elphick
• 13:33   Re: Storing properties in a logical way. Daniel M.
• 18:03   How to rename a constraint/trigger?? Andrei Bintintan

7 September 2004

• 00:31   When a table was last ANALYZEd Troels Arvin
• 09:47   Isnumeric function? Theo Galanakis
• 10:05   Re: Isnumeric function? Oliver Elphick
• 16:11   Problem with LATIN1 characters from Perl-DBI Andreas Joseph Krogh
• 17:59   Re: Problem with LATIN1 characters from Perl-DBI Andreas Joseph Krogh
• 21:14   Problem with returning setof record oliverp21@free.fr
• 21:36   Re: Problem with returning setof record Richard Huxton

8 September 2004

• 20:50   Re: Isnumeric function? Josh Berkus
• 21:08   Re: How to rename a constraint/trigger?? Josh Berkus
• 21:20   Re: Isnumeric function? Oliver Elphick
• 21:51   Re: Isnumeric function? Josh Berkus
• 22:12   Re: Isnumeric function? Oliver Elphick

9 September 2004

• 01:12   aggregate function stddev Kemin Zhou
• 03:42   Re: Isnumeric function? Theo Galanakis
• 03:57   Re: Isnumeric function? Tom Lane
• 04:06   Re: Isnumeric function? Theo Galanakis
• 05:44   check for circular references in a 2-table heirachy Terence Kearns
• 05:58   Re: Isnumeric function? Thomas Swan
• 07:49   Re: Isnumeric function? Greg Stark
• 09:33   Query Plan Theo Galanakis
• 11:35    Theo Galanakis
• 12:28   Re: Query Plan Richard Huxton
• 18:02   Re: Isnumeric function? Jeff Eckermann
• 18:23   Datetime conversion in WHERE clause Philippe Lang
• 19:02   Re: Isnumeric function? Passynkov, Vadim
• 22:37   Re: aggregate function stddev Josh Berkus
• 22:42   Re: Datetime conversion in WHERE clause Josh Berkus
• 22:46   Re: Isnumeric function? Josh Berkus

10 September 2004

• 04:33   Re: Isnumeric function? Theo Galanakis
• 06:22   Re: Isnumeric function? Josh Berkus
• 06:53   Re: Isnumeric function? Theo Galanakis
• 09:39   Re: Isnumeric function? sad
• 10:25   Re: Isnumeric function? Achilleus Mantzios
• 10:43   Re: Isnumeric function? Greg Stark
• 11:02   Re: Isnumeric function? Greg Stark
• 17:59   Re: Isnumeric function? Tom Lane
• 19:33   Re: Isnumeric function? Greg Stark

11 September 2004

• 01:48   Re: aggregate function stddev Bruce Momjian
• 09:07   HOW TO HANDLE ZEROS IN DATE FIELD? James M Doherty
• 09:07   SQL99 "with recursive" question Thomas Wegner
• 09:07   PL/pgSQL Function Problem the inquirer
• 09:08   Using UPDATE FROM Collin Peters
• 09:08   CREATE RULE ignored, what did I do wrong andrew@pillette.com
• 09:44   Re: HOW TO HANDLE ZEROS IN DATE FIELD? Michael Glaesemann
• 10:03   Re: [GENERAL] PL/pgSQL Function Problem Tom Lane
• 10:17   Re: Using UPDATE FROM Tom Lane
• 10:42   Re: CREATE RULE ignored, what did I do wrong Tom Lane
• 16:58   Re: HOW TO HANDLE ZEROS IN DATE FIELD? Michael Glaesemann

12 September 2004

• 09:37   Re: PL/pgSQL Function Problem Michalis Kabrianis
• 09:37   Re: [GENERAL] PL/pgSQL Function Problem Doug McNaught
• 09:37   create unique index schema.index_name on table (column)? m0ntar3@cox.net
• 09:49   Re: create unique index schema.index_name on table (column)? Michael Glaesemann
• 09:55   Re: create unique index schema.index_name on table (column)? Michael Glaesemann
• 09:55   Re: create unique index schema.index_name on table (column)? Tom Lane

13 September 2004

• 12:36   what is maximum size of "text" datatype in postgres? Smit
• 14:07   Re: what is maximum size of "text" datatype in postgres? Christopher Browne
• 19:03   Interpolation and extrapolation in SQL David Garamond
• 19:16   Re: Interpolation and extrapolation in SQL Tom Lane

14 September 2004

• 02:03   Difficulties to use a Set Returning Function on a join Alvaro Nunes Melo
• 08:25   Re: create unique index schema.index_name on table (column)? mØntar3
• 08:25   Re: CREATE RULE ignored, what did I do wrong andrew@pillette.com

15 September 2004

• 05:21   explain analyze results are different for each iteration Robert Davis
• 05:33   Re: explain analyze results are different for each iteration Gregory S. Williamson
• 06:07   Re: explain analyze results are different for each iteration Stephan Szabo
• 07:03   implementing an out-of-transaction trigger Iain
• 13:20   Re: sleep function Sanjay Singh
• 16:25   Preserving column order when recreating table. Stef
• 17:19   Re: Preserving column order when recreating table. Andrew Sullivan
• 18:22   Re: Preserving column order when recreating table. Stef
• 18:42   Re: Preserving column order when recreating table. Andrew Sullivan
• 19:07   Re: Preserving column order when recreating table. Stef
• 19:36   Re: Preserving column order when recreating table. Andrew Sullivan
• 20:03   Re: implementing an out-of-transaction trigger Mike Rylander

16 September 2004

• 06:03   Re: implementing an out-of-transaction trigger Iain
• 07:58   Re: implementing an out-of-transaction trigger Greg Stark
• 09:15   Re: implementing an out-of-transaction trigger Iain

17 September 2004

• 00:57   CREATE TABLE AS SELECT.... Arash Zaryoun

18 September 2004

• 18:11   PL/pgSQL multidimension (matrix) array in function Sergio Fantinel
• 18:13   Implicit Transactions Chip Gobs
• 18:13   How to check postgres running or not ? Sandeep Gaikwad
• 18:13   1-byte integers stig erikson
• 18:13   Sequence of SQL command execution involving triggers and stored procedures. Omkar Rath
• 19:39   Re: 1-byte integers Greg Stark
• 20:39   Re: Sequence of SQL command execution involving triggers and stored procedures. Tom Lane
• 21:37   Re: How to check postgres running or not ? Christopher Browne
• 22:37   Re: How to check postgres running or not ? Gaetano Mendola

19 September 2004

• 06:13   Re: How to check postgres running or not ? Worik
• 16:02   Re: How to check postgres running or not ? Geoffrey
• 18:57   ORDER BY and NULLs T E Schmitz
• 19:19   Re: ORDER BY and NULLs 
• 20:08   Re: How to check postgres running or not ? Jeff Eckermann
• 20:18   Re: ORDER BY and NULLs Jean-Luc Lachance
• 20:25   Re: How to check postgres running or not ? Tom Lane
• 20:36   Re: ORDER BY and NULLs T E Schmitz
• 20:58   Re: How to check postgres running or not ? Andrew Sullivan
• 20:59   Re: ORDER BY and NULLs Tom Lane
• 21:12   Re: How to check postgres running or not ? Tom Lane
• 21:42   Re: ORDER BY and NULLs T E Schmitz
• 22:37   Re: ORDER BY and NULLs Greg Stark
• 23:00   Re: ORDER BY and NULLs Tom Lane

20 September 2004

• 00:22   Re: ORDER BY and NULLs T E Schmitz
• 00:30   Re: ORDER BY and NULLs Tom Lane
• 00:53   Re: ORDER BY and NULLs T E Schmitz
• 01:14   Re: How to check postgres running or not ? Gaetano Mendola
• 01:14   Re: How to check postgres running or not ? Gaetano Mendola
• 04:21   Re: How to check postgres running or not ? Andrew Sullivan
• 04:35   Re: How to check postgres running or not ? Worik
• 04:51   Re: ORDER BY and NULLs Greg Stark
• 05:04   Re: How to check postgres running or not ? Worik
• 05:11   Re: How to check postgres running or not ? Tom Lane
• 05:29   Re: How to check postgres running or not ? Arne Stoelck
• 05:44   Re: How to check postgres running or not ? Christopher Browne
• 07:16   Test for file exists? Richard Sydney-Smith
• 11:20   Re: How to check postgres running or not ? Reiner Dassing
• 12:06   Re: ORDER BY and NULLs T E Schmitz
• 14:06   Re: How to check postgres running or not ? Gaetano Mendola
• 15:47   Re: How to check postgres running or not ? Peter Eisentraut
• 16:19   Re: How to check postgres running or not ? Bruce Momjian
• 16:34   Re: Implicit Transactions Bruce Momjian
• 17:46   Re: How to check postgres running or not ? Theodore Petrosky
• 19:47   COUNT(*) to find records which have a certain number of dependencies ? T E Schmitz
• 20:19   Re: COUNT(*) to find records which have a certain number of T E Schmitz
• 20:31   Re: Test for file exists? Josh Berkus
• 20:32   Re: COUNT(*) to find records which have a certain number of Rod Taylor
• 22:08   Re: COUNT(*) to find records which have a certain number of T E Schmitz
• 22:32   Re: COUNT(*) to find records which have a certain number of dependencies ? Greg Stark
• 22:33   Re: COUNT(*) to find records which have a certain number of Greg Stark
• 23:25   JOIN performance Dean Gibson (DB Administrator)
• 23:53   Re: COUNT(*) to find records which have a certain number of T E Schmitz

21 September 2004

• 00:40   Help with function CHRIS HOOVER
• 00:45   Re: COUNT(*) to find records which have a certain number of dependencies ? Greg Stark
• 00:51   Re: Help with function Stephan Szabo
• 00:55   Re: COUNT(*) to find records which have a certain number of Chester Kustarz
• 01:26   unsubscribe Ramiro Batista da Luz
• 01:54   Re: CREATE TABLE AS SELECT.... Andrew Hammond
• 03:06   Re: JOIN performance Tom Lane
• 04:11   Re: JOIN performance Dean Gibson (DB Administrator)
• 04:54   Re: JOIN performance Tom Lane
• 05:44   Re: JOIN performance Dean Gibson (DB Administrator)
• 08:09   Re: JOIN performance Chester Kustarz
• 08:10   Re: JOIN performance Tom Lane
• 08:42   Re: JOIN performance Dean Gibson (DB Administrator)
• 08:44   Re: PL/pgSQL multidimension (matrix) array in function Joe Conway
• 09:19   Re: JOIN performance Tom Lane
• 11:40   Difference in DATEs Dean Gibson (DB Administrator)
• 15:22   degradation in performance Alain Reymond
• 15:31   Re: degradation in performance Martin Knipper
• 16:25   Re: degradation in performance Stephan Szabo
• 16:40   Re: degradation in performance Pierre-Frédéric Caillaud
• 18:01   Re: Difference in DATEs Tom Lane
• 18:27   Re: Help with function CHRIS HOOVER
• 19:25   Re: Help with function Stephan Szabo
• 19:54   Re: Difference in DATEs Dean Gibson (DB Administrator)
• 20:19   Re: Different topic Dean Gibson (DB Administrator)
• 20:48   raise is not working CHRIS HOOVER
• 21:54   Re: raise is not working Josh Berkus
• 22:26   Re: JOIN performance Greg Stark

22 September 2004

• 02:29   Re: raise is not working Tom Lane
• 16:18   Porting problem from Informix to Postgres... Marco Gaiarin
• 16:30   Re: Porting problem from Informix to Postgres... Michalis Kabrianis
• 16:33   Re: Porting problem from Informix to Postgres... Achilleus Mantzios
• 21:14   Re: Porting problem from Informix to Postgres... Josh Berkus

23 September 2004

• 02:54   LIKE operator and string comparison Wei Weng
• 03:09   Re: LIKE operator and string comparison Tom Lane
• 03:17   Re: LIKE operator and string comparison Wei Weng
• 03:21   Re: LIKE operator and string comparison Tom Lane
• 19:33   plpgsql syntax Kemin Zhou
• 20:03   Re: plpgsql syntax Yasir Malik
• 20:19   Re: plpgsql syntax Tom Lane
• 20:35   Re: raise is not working CHRIS HOOVER
• 20:52   Re: raise is not working Tom Lane
• 21:08   Re: raise is not working CHRIS HOOVER
• 21:11   Re: raise is not working Tom Lane

24 September 2004

• 00:40   need "row number" Karsten Hilbert
• 11:23   Re: [GENERAL] need ``row number`` Karsten Hilbert
• 15:18   INDEX problem Vladimir S. Tikhonjuk
• 15:51   select column by position Jennifer Lee
• 18:20   Re: [GENERAL] need ``row number`` Tom Lane
• 19:40   How to insert values in bytea? Oliver Nolden

25 September 2004

• 00:35   Re: [GENERAL] need ``row number`` Greg Stark
• 01:00   Re: select column by position Chester Kustarz

26 September 2004

• 20:15   plpgsql - accessing fields of record type Szálka Tamás
• 22:34   Re: plpgsql - accessing fields of record type Michael Fuhr
• 23:24   Re: COUNT(*) to find records which have a certain number of Martin Knipper

27 September 2004

• 02:37   Re: COUNT(*) to find records which have a certain number of dependencies Mischa Sandberg
• 02:37   where clause on a left outer join Cris Carampa
• 02:37   Porting problem from Informix to Postgres... Marco Gaiarin
• 02:37   Doubt S.Sreejith
• 02:37   Problem with functions Michael Snodgrass
• 02:37   Re: JOIN performance Dean Gibson (DB Administrator)
• 02:37   postgres rpm Nagaraj GS
• 03:02   Re: [GENERAL] need ``row number`` Ian Harding
• 03:02   Re: [GENERAL] need ``row number`` Ian Harding
• 03:03   [ocpfree] Info Needed about OCA birdy edwards
• 04:21   Re: where clause on a left outer join Stephan Szabo
• 04:34   Re: Problem with functions Stephan Szabo
• 10:32   Re: postgres rpm Devrim GUNDUZ
• 13:45   Re: COUNT(*) to find records which have a certain number of T E Schmitz
• 17:27   Re: COUNT(*) to find records which have a certain number of dependencies Greg Stark
• 18:02   Temp Tables sad

28 September 2004

• 10:59   FOREIGN KEY and AccessExclusiveLock Achilleus Mantzios
• 16:58   Best way to know if there is a row Martin Marques
• 17:09   Re: Best way to know if there is a row Achilleus Mantzios
• 18:02   CHECK col A not NULL if col B='x' T E Schmitz
• 18:05   Re: FOREIGN KEY and AccessExclusiveLock Tom Lane
• 18:14   Re: CHECK col A not NULL if col B='x' Martin Marques
• 18:15   Re: CHECK col A not NULL if col B='x' Alexander M. Pravking
• 18:19   Re: FOREIGN KEY and AccessExclusiveLock Achilleus Mantzios
• 18:24   Re: Best way to know if there is a row Tom Lane
• 18:38   Re: CHECK col A not NULL if col B='x' T E Schmitz
• 19:23   Re: CHECK col A not NULL if col B='x' T E Schmitz

29 September 2004

• 00:40   Re: Doubt Paul Thomas
• 02:37   Re: CHECK col A not NULL if col B='x' Tom Lane
• 10:21   Re: FOREIGN KEY and AccessExclusiveLock Achilleus Mantzios
• 17:22   Re: Porting problem from Informix to Postgres... Marco Gaiarin
• 17:49   SELECT with Function Paulo Nievierowski
• 18:04   Re: FOREIGN KEY and AccessExclusiveLock Achilleus Mantzios
• 21:13   multiple insert van Elsacker Frans

30 September 2004

• 15:36   Re: FOREIGN KEY and AccessExclusiveLock Achilleus Mantzios