Mailing lists [pgsql-sql]

1 September 2004

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

2 September 2004

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

5 September 2004

• 17:53   Full access to a DB with a second user? Erik Wasser
• 18:38   Storing properties in a logical way. Daniel M.
• 18:51   Re: Storing properties in a logical way. Pierre-Frédéric Caillaud
• 23:57   INFORMATION_SCHEMA and foreign keys Troels Arvin

6 September 2004

• 00:29   Re: INFORMATION_SCHEMA and foreign keys Stephan Szabo
• 03:13   Re: INFORMATION_SCHEMA and foreign keys Tom Lane
• 07:25   Re: Full access to a DB with a second user? Oliver Elphick
• 10:33   Re: Storing properties in a logical way. Daniel M.
• 15:03   How to rename a constraint/trigger?? Andrei Bintintan
• 21:31   When a table was last ANALYZEd Troels Arvin

7 September 2004

• 06:47   Isnumeric function? Theo Galanakis
• 07:05   Re: Isnumeric function? Oliver Elphick
• 13:11   Problem with LATIN1 characters from Perl-DBI Andreas Joseph Krogh
• 14:59   Re: Problem with LATIN1 characters from Perl-DBI Andreas Joseph Krogh
• 18:14   Problem with returning setof record oliverp21@free.fr
• 18:36   Re: Problem with returning setof record Richard Huxton

8 September 2004

• 17:50   Re: Isnumeric function? Josh Berkus
• 18:08   Re: How to rename a constraint/trigger?? Josh Berkus
• 18:20   Re: Isnumeric function? Oliver Elphick
• 18:51   Re: Isnumeric function? Josh Berkus
• 19:12   Re: Isnumeric function? Oliver Elphick
• 22:12   aggregate function stddev Kemin Zhou

9 September 2004

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

10 September 2004

• 01:33   Re: Isnumeric function? Theo Galanakis
• 03:22   Re: Isnumeric function? Josh Berkus
• 03:53   Re: Isnumeric function? Theo Galanakis
• 06:39   Re: Isnumeric function? sad
• 07:25   Re: Isnumeric function? Achilleus Mantzios
• 07:43   Re: Isnumeric function? Greg Stark
• 08:02   Re: Isnumeric function? Greg Stark
• 14:59   Re: Isnumeric function? Tom Lane
• 16:33   Re: Isnumeric function? Greg Stark
• 22:48   Re: aggregate function stddev Bruce Momjian

11 September 2004

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

12 September 2004

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

13 September 2004

• 09:36   what is maximum size of "text" datatype in postgres? Smit
• 11:07   Re: what is maximum size of "text" datatype in postgres? Christopher Browne
• 16:03   Interpolation and extrapolation in SQL David Garamond
• 16:16   Re: Interpolation and extrapolation in SQL Tom Lane
• 23:03   Difficulties to use a Set Returning Function on a join Alvaro Nunes Melo

14 September 2004

• 05:25   Re: create unique index schema.index_name on table (column)? mØntar3
• 05:25   Re: CREATE RULE ignored, what did I do wrong andrew@pillette.com

15 September 2004

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

16 September 2004

• 03:03   Re: implementing an out-of-transaction trigger Iain
• 04:58   Re: implementing an out-of-transaction trigger Greg Stark
• 06:15   Re: implementing an out-of-transaction trigger Iain
• 21:57   CREATE TABLE AS SELECT.... Arash Zaryoun

18 September 2004

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

19 September 2004

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

20 September 2004

• 01:21   Re: How to check postgres running or not ? Andrew Sullivan
• 01:35   Re: How to check postgres running or not ? Worik
• 01:51   Re: ORDER BY and NULLs Greg Stark
• 02:04   Re: How to check postgres running or not ? Worik
• 02:11   Re: How to check postgres running or not ? Tom Lane
• 02:29   Re: How to check postgres running or not ? Arne Stoelck
• 02:44   Re: How to check postgres running or not ? Christopher Browne
• 04:16   Test for file exists? Richard Sydney-Smith
• 08:20   Re: How to check postgres running or not ? Reiner Dassing
• 09:06   Re: ORDER BY and NULLs T E Schmitz
• 11:06   Re: How to check postgres running or not ? Gaetano Mendola
• 12:47   Re: How to check postgres running or not ? Peter Eisentraut
• 13:19   Re: How to check postgres running or not ? Bruce Momjian
• 13:34   Re: Implicit Transactions Bruce Momjian
• 14:46   Re: How to check postgres running or not ? Theodore Petrosky
• 16:47   COUNT(*) to find records which have a certain number of dependencies ? T E Schmitz
• 17:19   Re: COUNT(*) to find records which have a certain number of T E Schmitz
• 17:31   Re: Test for file exists? Josh Berkus
• 17:32   Re: COUNT(*) to find records which have a certain number of Rod Taylor
• 19:08   Re: COUNT(*) to find records which have a certain number of T E Schmitz
• 19:32   Re: COUNT(*) to find records which have a certain number of dependencies ? Greg Stark
• 19:33   Re: COUNT(*) to find records which have a certain number of Greg Stark
• 20:25   JOIN performance Dean Gibson (DB Administrator)
• 20:53   Re: COUNT(*) to find records which have a certain number of T E Schmitz
• 21:40   Help with function CHRIS HOOVER
• 21:45   Re: COUNT(*) to find records which have a certain number of dependencies ? Greg Stark
• 21:51   Re: Help with function Stephan Szabo
• 21:55   Re: COUNT(*) to find records which have a certain number of Chester Kustarz
• 22:26   unsubscribe Ramiro Batista da Luz
• 22:54   Re: CREATE TABLE AS SELECT.... Andrew Hammond

21 September 2004

• 00:06   Re: JOIN performance Tom Lane
• 01:11   Re: JOIN performance Dean Gibson (DB Administrator)
• 01:54   Re: JOIN performance Tom Lane
• 02:44   Re: JOIN performance Dean Gibson (DB Administrator)
• 05:09   Re: JOIN performance Chester Kustarz
• 05:10   Re: JOIN performance Tom Lane
• 05:42   Re: JOIN performance Dean Gibson (DB Administrator)
• 05:44   Re: PL/pgSQL multidimension (matrix) array in function Joe Conway
• 06:19   Re: JOIN performance Tom Lane
• 08:40   Difference in DATEs Dean Gibson (DB Administrator)
• 12:22   degradation in performance Alain Reymond
• 12:31   Re: degradation in performance Martin Knipper
• 13:25   Re: degradation in performance Stephan Szabo
• 13:40   Re: degradation in performance Pierre-Frédéric Caillaud
• 15:01   Re: Difference in DATEs Tom Lane
• 15:27   Re: Help with function CHRIS HOOVER
• 16:25   Re: Help with function Stephan Szabo
• 16:54   Re: Difference in DATEs Dean Gibson (DB Administrator)
• 17:19   Re: Different topic Dean Gibson (DB Administrator)
• 17:48   raise is not working CHRIS HOOVER
• 18:54   Re: raise is not working Josh Berkus
• 19:26   Re: JOIN performance Greg Stark
• 23:29   Re: raise is not working Tom Lane

22 September 2004

• 13:18   Porting problem from Informix to Postgres... Marco Gaiarin
• 13:30   Re: Porting problem from Informix to Postgres... Michalis Kabrianis
• 13:33   Re: Porting problem from Informix to Postgres... Achilleus Mantzios
• 18:14   Re: Porting problem from Informix to Postgres... Josh Berkus
• 23:54   LIKE operator and string comparison Wei Weng

23 September 2004

• 00:09   Re: LIKE operator and string comparison Tom Lane
• 00:17   Re: LIKE operator and string comparison Wei Weng
• 00:21   Re: LIKE operator and string comparison Tom Lane
• 16:33   plpgsql syntax Kemin Zhou
• 17:03   Re: plpgsql syntax Yasir Malik
• 17:19   Re: plpgsql syntax Tom Lane
• 17:35   Re: raise is not working CHRIS HOOVER
• 17:52   Re: raise is not working Tom Lane
• 18:08   Re: raise is not working CHRIS HOOVER
• 18:11   Re: raise is not working Tom Lane
• 21:40   need "row number" Karsten Hilbert

24 September 2004

• 08:23   Re: [GENERAL] need ``row number`` Karsten Hilbert
• 12:18   INDEX problem Vladimir S. Tikhonjuk
• 12:51   select column by position Jennifer Lee
• 15:20   Re: [GENERAL] need ``row number`` Tom Lane
• 16:40   How to insert values in bytea? Oliver Nolden
• 21:35   Re: [GENERAL] need ``row number`` Greg Stark
• 22:00   Re: select column by position Chester Kustarz

26 September 2004

• 17:15   plpgsql - accessing fields of record type Szálka Tamás
• 19:34   Re: plpgsql - accessing fields of record type Michael Fuhr
• 20:24   Re: COUNT(*) to find records which have a certain number of Martin Knipper
• 23:37   Re: COUNT(*) to find records which have a certain number of dependencies Mischa Sandberg
• 23:37   where clause on a left outer join Cris Carampa
• 23:37   Porting problem from Informix to Postgres... Marco Gaiarin
• 23:37   Doubt S.Sreejith
• 23:37   Problem with functions Michael Snodgrass
• 23:37   Re: JOIN performance Dean Gibson (DB Administrator)
• 23:37   postgres rpm Nagaraj GS

27 September 2004

• 00:02   Re: [GENERAL] need ``row number`` Ian Harding
• 00:02   Re: [GENERAL] need ``row number`` Ian Harding
• 00:03   [ocpfree] Info Needed about OCA birdy edwards
• 01:21   Re: where clause on a left outer join Stephan Szabo
• 01:34   Re: Problem with functions Stephan Szabo
• 07:32   Re: postgres rpm Devrim GUNDUZ
• 10:45   Re: COUNT(*) to find records which have a certain number of T E Schmitz
• 14:27   Re: COUNT(*) to find records which have a certain number of dependencies Greg Stark
• 15:02   Temp Tables sad

28 September 2004

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

29 September 2004

• 07:21   Re: FOREIGN KEY and AccessExclusiveLock Achilleus Mantzios
• 14:22   Re: Porting problem from Informix to Postgres... Marco Gaiarin
• 14:49   SELECT with Function Paulo Nievierowski
• 15:04   Re: FOREIGN KEY and AccessExclusiveLock Achilleus Mantzios
• 18:13   multiple insert van Elsacker Frans

30 September 2004

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