Mailing lists [pgsql-sql]

1 March 2003

• 00:00   Re: Executing SQL commands via triggers without the use of Stephan Szabo
• 04:22   Re: Beginner needs help Greg Stark
• 06:41   Re: Beginner needs help Victor Yegorov
• 07:25   Re: use of geometric types in select ? Victor Yegorov
• 10:31   Arrays in Postgresql Processes Aspire Something
• 11:34   Re: [ADMIN] Users and groups Oliver Elphick
• 12:48   Epoch extraction Denis Arh
• 12:57   Epoch extraction Denis Arh
• 14:49   Re: Denormalizing during select Edmund Lian
• 14:56   Re: Denormalizing during select Edmund Lian
• 15:00   Re: Executing SQL commands via triggers without the use of procedures Jeff Eckermann
• 15:07   Re: Epoch extraction Tom Lane
• 15:08   Re: Denormalizing during select Rod Taylor
• 15:08   Re: Denormalizing during select Rod Taylor
• 15:16   Re: Denormalizing during select Tom Lane
• 16:12   Re: Denormalizing during select Greg Stark
• 20:57   PL/pgSQL Zodiac
• 21:23   Re: Beginner needs help Chad Thompson
• 22:11   Re: Beginner needs help Bruno Wolff III
• 22:57   OUTER JOIN with filter Nicolas Fertig

2 March 2003

• 00:39   Re: Are scalar type's in/out functions implicitly STRICT? Denis Zaitsev
• 00:42   Re: Are scalar type's in/out functions implicitly STRICT? Denis Zaitsev
• 00:42    
• 00:45   using Avg() Mark Connelly@South Central
• 00:45   Re: how to return ONE single record from a function in plpgsql? Hubert depesz Lubaczewski
• 00:48   Inquiry From Form [pgsql] Jack Kiss
• 00:48   Any limitation in size for return result from SELECT? Natasa Bulatovic
• 00:51   two dates mixo
• 00:52   Re: good style? Tambet Matiisen
• 00:55   Re: Denormalizing during select Edmund Lian
• 00:56   Re: Denormalizing during select no.spam@address.com
• 00:59   Dynamic SELECT condition Victor Yegorov
• 00:59   Denormalizing during select no.spam@address.com
• 01:15   Dynamic SELECT condition Victor Yegorov
• 01:15   Denormalizing during select no.spam@address.com
• 01:20   Dynamic SELECT condition Victor Yegorov
• 01:21   Denormalizing during select no.spam@address.com
• 01:58   Re: Any limitation in size for return result from SELECT? Bruno Wolff III
• 03:36   Re: OUTER JOIN with filter Bruno Wolff III
• 03:47   Re: Any limitation in size for return result from SELECT? Stephan Szabo
• 04:49   Re: OUTER JOIN with filter Stephan Szabo
• 05:54   Re: Any limitation in size for return result from SELECT? Joe Conway
• 08:51   Re: Dynamic SELECT condition Bruno Wolff III
• 09:47   Re: Tom Lane
• 09:52   Re: OUTER JOIN with filter Tom Lane
• 09:54   Re: OUTER JOIN with filter Stephan Szabo
• 10:02   default operator class (PostgreSQL's error?) Denis Zaitsev
• 10:25   Re: Dynamic SELECT condition Achilleus Mantzios
• 12:10   Re: Inquiry From Form [pgsql] Greg Stark
• 12:19   Re: Dynamic SELECT condition Greg Stark
• 16:01   Re: default operator class (PostgreSQL's error?) Tom Lane
• 16:09   Re: Beginner needs help Tomasz Myrta
• 19:58   Re: Zodiac
• 22:07   HardCORE QUERY HELP!!! Metnetsky

3 March 2003

• 00:13   Re: default operator class (PostgreSQL's error?) Denis Zaitsev
• 01:27   Re: default operator class (PostgreSQL's error?) Tom Lane
• 03:09   Re: default operator class (PostgreSQL's error?) Denis Zaitsev
• 04:24   Re: HardCORE QUERY HELP!!! Rajesh Kumar Mallah
• 05:55   Re: Dynamic SELECT condition Achilleus Mantzios
• 07:20   copy help val@webtribe.net
• 07:58   Re: Users and groups Christoph Haller
• 08:29   Re: copy help Janning Vygen
• 09:32   pl/pgsql errors Tomasz Myrta
• 09:45   Re: pl/pgsql errors Tambet Matiisen
• 10:10   Re: two dates Richard Huxton
• 10:33   Re: two dates Oliver Elphick
• 10:33   Re: pl/pgsql errors Tomasz Myrta
• 10:44   Re: HardCORE QUERY HELP!!! Tomasz Myrta
• 11:23   Re: Executing SQL commands via triggers without the use of procedures Oleg Samoylov
• 11:30   Re: Dynamic SELECT condition Oleg Samoylov
• 12:55   Re: Dynamic SELECT condition Victor Yegorov
• 13:05   Querying Hierarchical Data Eric
• 14:23   Re: Querying Hierarchical Data Lex Berezhny
• 14:26   Re: Querying Hierarchical Data Rajesh Kumar Mallah
• 14:51   Re: Querying Hierarchical Data Victor Yegorov
• 14:52   Checking my HD space (noarchive) Ries van Twisk
• 14:57   Re: Querying Hierarchical Data Achilleus Mantzios
• 15:08   complex query Matt Gerginski
• 15:19   Insert multiple Rows saintxplo@yahoo.com.ar (Saint X)
• 15:20   Re: complex query Victor Yegorov
• 15:39   Re: Insert multiple Rows Victor Yegorov
• 15:49   Suggestion: set session authorization with password Aasmund Midttun Godal
• 15:52   Re: Insert multiple Rows Oliver Elphick
• 16:18   Re: Beginner needs help Josh Berkus
• 16:27   Re: Querying Hierarchical Data Joe Conway
• 16:31   Re: OUTER JOIN with filter Josh Berkus
• 16:34   Re: Querying Hierarchical Data Robert Treat
• 16:35   Re: Querying Hierarchical Data Josh Berkus
• 17:17   Re: OUTER JOIN with filter Tom Lane
• 18:47   Re: HardCORE QUERY HELP!!! Greg Stark
• 19:11   Query Against a dblink View Takes Too Long to Return Dawn Hollingsworth
• 19:16   Forcing query to use an index Michael Nachbaur
• 19:47   Gist indexes on int arrays Greg Stark
• 20:37   Re: Forcing query to use an index Josh Berkus
• 20:38   Re: Forcing query to use an index Stephan Szabo
• 20:47   Re: Forcing query to use an index Greg Stark
• 20:54   Re: Forcing query to use an index Michael Nachbaur
• 20:55   Re: Forcing query to use an index Michael Nachbaur
• 20:59   Re: Forcing query to use an index Michael Nachbaur
• 21:21   Re: Forcing query to use an index Josh Berkus
• 21:27   Re: Forcing query to use an index Michael Nachbaur
• 21:32   Re: Forcing query to use an index Josh Berkus
• 23:03   Re: Forcing query to use an index Michael Nachbaur
• 23:14   Re: Forcing query to use an index Greg Stark
• 23:27   Re: Forcing query to use an index Greg Stark
• 23:28   SCHEMA's Hepworth, Mike

4 March 2003

• 00:25   Re: SCHEMA's Tom Lane
• 00:43   Re: Query Against a dblink View Takes Too Long to Return Tom Lane
• 05:35   Re: Gist indexes on int arrays Achilleus Mantzios
• 07:12   SQL books Juan Fernández
• 07:21   Re: Checking my HD space (noarchive) Richard Huxton
• 08:54   Re: Insert multiple Rows Oleg Samoylov
• 09:14   Re: using Avg() Christoph Haller
• 09:22   Re: Insert multiple Rows Gary Stainburn
• 10:45   Re: SQL books Douglas Trainor
• 13:28   Re: Gist indexes on int arrays Greg Stark
• 14:50   Re: Gist indexes on int arrays Achilleus Mantzios
• 14:56   Re: Gist indexes on int arrays Greg Stark
• 15:42   SETOF Fernando
• 16:00   Convert a text list to text array? Was: Denormalizing during select Guy Fraser
• 16:17   Re: Gist indexes on int arrays Oleg Bartunov
• 16:17   Re: Gist indexes on int arrays Oleg Bartunov
• 16:27   Re: Convert a text list to text array? Was: Denormalizing during select Greg Stark
• 16:36   LIMIT and SUBQUERIES cprice@hrdenterprises.com (Chris)
• 16:36   Re: HardCORE QUERY HELP!!! Matthew Metnetsky
• 16:36   Database function syntax for inserting records Susan Hoddinott
• 16:36   Re: HardCORE QUERY HELP!!! Erwin Moller
• 16:38   Re: Gist indexes on int arrays Greg Stark
• 16:40   Re: Gist indexes on int arrays Guy Fraser
• 16:52   Re: Database function syntax for inserting records Josh Berkus
• 17:41   Re: Convert a text list to text array? Was: Denormalizing during Joe Conway
• 17:45   Sorting by NULL values Ian Burrell
• 17:52   Re: Forcing query to use an index Jean-Luc Lachance
• 18:15   Re: Sorting by NULL values Dan Langille
• 18:25   Re: Forcing query to use an index Greg Stark
• 18:26   Re: Sorting by NULL values Tomasz Myrta
• 19:46   Re: Sorting by NULL values Stephan Szabo
• 22:25   Re: Sorting by NULL values Josh Berkus
• 22:36   Re: Gist indexes on int arrays Oleg Bartunov
• 23:51   Re: Forcing query to use an index Jean-Luc Lachance

5 March 2003

• 00:21   Re: Gist indexes on int arrays Greg Stark
• 01:03   Re: LIMIT and SUBQUERIES Tomasz Myrta
• 04:01   Re: Forcing query to use an index Tom Lane
• 06:54   Re: Insert multiple Rows Christoph Haller
• 07:49   Re: Sorting by NULL values Rod Taylor
• 08:56   DELETE FROM A BLACK LIST luca.scaramella@recom.it
• 09:14   Re: DELETE FROM A BLACK LIST Achilleus Mantzios
• 09:47   Re: SETOF Christoph Haller
• 10:47   Re: SETOF Greg Stark
• 11:11   Re: SETOF Christoph Haller
• 11:24   Re: LIMIT and SUBQUERIES Christoph Haller
• 11:36   Re: SETOF Greg Stark
• 11:37   Re: SETOF Greg Stark
• 12:10   Re: SETOF Christoph Haller
• 12:27   Re: DELETE FROM A BLACK LIST Christoph Haller
• 12:34   unsuscribe Miriam Fernández Galicia
• 12:41   sort / limit / range problem Gary Stainburn
• 12:49   Re: sort / limit / range problem Tomasz Myrta
• 12:51   Re: sort / limit / range problem Achilleus Mantzios
• 13:22   Re: LIMIT and SUBQUERIES Greg Stark
• 13:39   upgrading from 7.1.2 to 7.3.2 patrick
• 13:56   Re: DELETE FROM A BLACK LIST Chad Thompson
• 14:03   Re: sort / limit / range problem Gary Stainburn
• 22:54   INTERSECT / where id IN (etc..) James Cooper

6 March 2003

• 04:06   Arrays Or Loop Aspire Something
• 04:41   Re: INTERSECT / where id IN (etc..) Tomasz Myrta
• 09:30   sql question regarding count(*) Rajesh Kumar Mallah
• 10:16   Re: sql question regarding count(*) Tomasz Myrta
• 15:18   Re: Arrays Or Loop Josh Berkus
• 17:53   Re: Relation "pg_relcheck" Bruce Momjian
• 18:22   Re: Copy from a SELECT Bruce Momjian
• 20:56   Cancelling Queries Mark Mitchell
• 23:31   Re: disable constraints Bruce Momjian

7 March 2003

• 03:21   Re: sql question regarding count(*) Rajesh Kumar Mallah
• 03:29   Re: Cancelling Queries jasiek@klaster.net
• 04:12   Re: sql question regarding count(*) Stephan Szabo
• 04:29   Re: sql question regarding count(*) Rajesh Kumar Mallah
• 04:40   Re: sql question regarding count(*) Stephan Szabo
• 05:53   Re: sql question regarding count(*) Rajesh Kumar Mallah
• 08:26   Help on indexing timestamps Andre Schubert
• 08:30   How to notice column changes in trigger Andreas Pflug
• 08:53   Re: Help on indexing timestamps Achilleus Mantzios
• 09:27   Re: Help on indexing timestamps Andre Schubert
• 09:40   Re: Help on indexing timestamps Achilleus Mantzios
• 10:02   Re: Help on indexing timestamps Andre Schubert
• 10:04   Re: How to notice column changes in trigger Christoph Haller
• 10:09   Re: Help on indexing timestamps Achilleus Mantzios
• 10:46   Re: Help on indexing timestamps Andre Schubert
• 10:55   Re: Help on indexing timestamps Achilleus Mantzios
• 11:02   problem with subselect Mathieu Arnold
• 11:11   Re: Help on indexing timestamps Andre Schubert
• 11:15   Re: problem with subselect Christoph Haller
• 11:27   Re: problem with subselect Mathieu Arnold
• 11:37   Re: Cancelling Queries Mark Mitchell
• 12:51   Re: problem with subselect Christoph Haller
• 13:05   Re: Help on indexing timestamps Tom Lane
• 13:28   Underscores in column names Mark Mitchell
• 14:06   Hex Integer Input Achilleus Mantzios
• 14:25   Re: How to notice column changes in trigger Andreas Pflug
• 14:29   Re: Underscores in column names Richard Huxton
• 14:47   Re: Underscores in column names Mark Mitchell
• 14:53   Re: Hex Integer Input Joe Conway
• 15:08   Re: Underscores in column names Tom Lane
• 15:13   Re: Hex Integer Input Tom Lane
• 15:42   Re: How to notice column changes in trigger Josh Berkus
• 15:49   Re: problem with subselect Josh Berkus
• 16:10   Re: How to notice column changes in trigger Andreas Pflug
• 16:27   Re: Cancelling Queries Bruce Momjian
• 16:31   Re: problem with subselect Tom Lane
• 20:14   Splitting text into rows with SQL Chris Gamache
• 22:07   Re: Splitting text into rows with SQL Ryan

8 March 2003

• 19:17   Atomicity of UPDATE, interchanging values in unique column daniel alvarez
• 19:33   Re: Atomicity of UPDATE, interchanging values in unique column Rod Taylor
• 19:48   Re: Atomicity of UPDATE, interchanging values in unique column daniel alvarez
• 19:56   Re: Atomicity of UPDATE, interchanging values in unique Rod Taylor
• 20:10   Re: Atomicity of UPDATE, interchanging values in unique Tom Lane
• 20:29   Re: Cancelling Queries jasiek@klaster.net
• 21:21   Re: Atomicity of UPDATE, interchanging values in unique daniel alvarez

9 March 2003

• 01:33   pl/pgsql how to return multiple values from a function jack
• 03:42   Re: pl/pgsql how to return multiple values from a function jack
• 03:59   Re: pl/pgsql how to return multiple values from a function Rajesh Kumar Mallah
• 06:51   Re: pl/pgsql how to return multiple values from a function Stephan Szabo
• 13:14   check if table/object is locked Jonathan Weiss
• 13:35   Re: check if table/object is locked Rod Taylor
• 17:56   Special characters in SQL queries Vernon Wu
• 18:35   Cursors and backwards scans and SCROLL Tom Lane
• 19:01   Re: Cursors and backwards scans and SCROLL Josh Berkus
• 19:04   Re: Cursors and backwards scans and SCROLL Rod Taylor
• 19:18   Re: Cursors and backwards scans and SCROLL Tom Lane
• 19:20   Re: [HACKERS] Cursors and backwards scans and SCROLL Neil Conway
• 22:48   Re: pl/pgsql how to return multiple values from a function jack
• 22:50   Re: pl/pgsql how to return multiple values from a function jack
• 23:21   About Create Type jack
• 23:35   Re: About Create Type Joe Conway

10 March 2003

• 00:09   types? James Cooper
• 02:48   Re: About Create Type jack
• 07:17   Re: Help on indexing timestamps Andre Schubert
• 07:35   Re: Help on indexing timestamps Tomasz Myrta
• 11:51   Optimizing view Victor Yegorov
• 12:24   Re: Help on indexing timestamps Andre Schubert
• 12:34   Re: How to notice column changes in trigger Christoph Haller
• 12:40   Re: [HACKERS] Cursors and backwards scans and SCROLL Tom Lane
• 13:07   Re: Help on indexing timestamps Tom Lane
• 13:14   Re: Optimizing view Tom Lane
• 13:41   Re: [HACKERS] Cursors and backwards scans and SCROLL Tom Lane
• 14:26   Re: [HACKERS] Cursors and backwards scans and SCROLL Bruce Momjian
• 14:43   Execution plan Question Objectz
• 15:12   Re: Execution plan Question Tomasz Myrta
• 16:06   Re: Beginner needs help Lee Harr
• 16:06   Re: Insert multiple Rows mark carew
• 16:07   Re: [HACKERS] Cursors and backwards scans and SCROLL Hannu Krosing
• 20:57   Re: Could someone please sort out the e-mail to news gateway! Joseph Shraibman

11 March 2003

• 01:28   explain (internal feature) A.M.
• 02:10   Re: explain (internal feature) Josh Berkus
• 02:54   Re: explain (internal feature) Tom Lane
• 03:02   Re: How to notice column changes in trigger Aspire Something
• 03:09   Re: Execution plan Question Objectz
• 04:02   export from postgres into dbf cristi
• 06:00   Re: Execution plan Question Tomasz Myrta
• 06:05   Re: Hex Integer Input Achilleus Mantzios
• 06:05   Re: Hex Integer Input Achilleus Mantzios
• 06:11   Re: Execution plan Question ObjectZ
• 13:32   Re: Special characters in SQL queries Christoph Haller
• 13:36   Re: How to notice column changes in trigger Andreas Pflug
• 18:24   Novice needs help Terry Lee Tucker
• 18:50   Re: Novice needs help Terry Lee Tucker
• 19:01   Re: Novice needs help Joe Conway
• 19:06   Re: Novice needs help jasiek@klaster.net
• 19:24   Re: Novice needs help Chad Thompson

12 March 2003

• 00:53   converting time_t to timestamp? patrick
• 01:31   Re: Special characters in SQL queries Vernon Wu
• 01:48   Table Updates .. Rudi Starcevic
• 01:56   Re: Table Updates .. Josh Berkus
• 02:05   Re: Table Updates .. Rudi Starcevic
• 02:42   Re: converting time_t to timestamp? Stephan Szabo
• 02:55   Re: Novice needs help Rajesh Kumar Mallah
• 04:27   Re: Help on indexing timestamps Andre Schubert
• 04:43   Re: Special characters in SQL queries Victor Yegorov
• 05:21   SERIAL does not ROLLBACK Muhammad Shariq Muzaffar
• 05:34   Re: SERIAL does not ROLLBACK Stephan Szabo
• 06:14   Re: Special characters in SQL queries Christoph Haller
• 07:44   Re: Special characters in SQL queries Richard Huxton
• 12:15   The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard David Delorme
• 16:24   LEFT JOIN and missing values mila
• 16:34   Re: [HACKERS] Cursors and backwards scans and SCROLL Zeugswetter Andreas SB SD
• 16:46   Re: LEFT JOIN and missing values Tomasz Myrta
• 17:45   Execution plan problem Hesham Gowaily
• 17:45   Re: [HACKERS] Cursors and backwards scans and SCROLL Jeroen T. Vermeulen
• 17:45   The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard David Delorme
• 17:45   Using column alias in WHERE clause? August Detlefsen
• 17:45   Create function statement with insert statement Susan Hoddinott
• 17:45   Using update statements in create function statements Susan Hoddinott
• 17:45   filtering out doubles Jules Alberts
• 17:45   Re: Special characters in SQL queries Rupa Schomaker
• 17:45   Re: Beginner needs help Björn Lundin
• 17:52   problematic query (for me ;-) Kim Petersen
• 17:52   Re: problematic query (for me ;-) Bjarke Dahl Ebert
• 17:52   decode or case statements Priya, Nagappan (N.)
• 17:52   postgresql installation question Ninonard Policarpio
• 17:52   View - Join based on dis-similar data types speakeasy
• 17:52   Re: problematic query (for me ;-) [solved? - sorry to bother] Kim Petersen
• 17:52   DELETE FROM A BLACK LIST luca.scaramella@recom.it
• 17:52   DELETE FROM A BLACK LIST luca.scaramella@recom.it
• 18:03   Re: filtering out doubles Chad Thompson
• 18:05   extending ORDER BY make query much slower Dan Langille
• 18:12   Re: LEFT JOIN and missing values mila
• 18:12   Re: Create function statement with insert statement Jon Griffin
• 18:17   Re: filtering out doubles Stephan Szabo
• 18:39   Re: LEFT JOIN and missing values Tomasz Myrta
• 18:49   Re: DELETE FROM A BLACK LIST Steve Crawford
• 18:49   Re: DELETE FROM A BLACK LIST Bruno Wolff III
• 18:49   Deleting large object from table pg_largeobject David
• 18:50   Re: LEFT JOIN and missing values mila boldareva
• 19:13   "hide" values in a column Valerie Goodman
• 19:39   Re: Using column alias in WHERE clause? Rod Taylor
• 19:44   Re: "hide" values in a column Rod Taylor
• 19:47   Re: extending ORDER BY make query much slower Stephan Szabo
• 19:48   Re: "hide" values in a column Tomasz Myrta
• 20:01   Re: extending ORDER BY make query much slower Tom Lane
• 20:32   Re: View - Join based on dis-similar data types Tom Lane
• 20:39   Re: "hide" values in a column Steve Crawford
• 20:46   Re: extending ORDER BY make query much slower Dan Langille
• 20:59   Re: extending ORDER BY make query much slower Dan Langille
• 21:31   nearest match Ryan
• 22:12   What's wrong with this group by clause? Franco Bruno Borghesi

13 March 2003

• 02:52   Function calling error in postgreSQL 7.3.1 vincent
• 04:05   Re: Function calling error in postgreSQL 7.3.1 Stephan Szabo
• 06:57   Re: nearest match Tomasz Myrta
• 07:02   Re: Using update statements in create function statements Christoph Haller
• 07:36   Re: The folding of unquoted names to lower case in PostgreSQL is Christoph Haller
• 08:07   Re: Create function statement with insert statement Christoph Haller
• 11:15   Re: Create function statement with insert statement Christoph Haller
• 12:13   Re: What's wrong with this group by clause? Christoph Haller
• 12:59   Re: "hide" values in a column Chris Gamache
• 13:18   Re: What's wrong with this group by clause? Manfred Koizar
• 13:26   A Brief Real-World Trigger Example Richard Huxton
• 14:15   Re: [HACKERS] What's wrong with this group by clause? Christoph Haller
• 15:03   Re: [HACKERS] What's wrong with this group by clause? Tom Lane
• 15:46   massive INSERT Kurt Overberg
• 17:23   Re: nearest match Jason Earl
• 17:32   Retrieving Definition for Composite Type Jordan S. Jones
• 17:55   Re: nearest match Ryan
• 19:25   ... Tilo Schwarz
• 19:32   Re: Tilo Schwarz
• 20:23   Re: Retrieving Definition for Composite Type jasiek@klaster.net
• 20:39   Re: Retrieving Definition for Composite Type Joe Conway
• 22:20   Re: massive INSERT Greg Stark
• 23:37   date and plpgsql error Christopher Smith
• 23:55   Re: date and plpgsql error Stephan Szabo

14 March 2003

• 01:11   displaying correct name Bruce Young
• 03:12   Re: View - Join based on dis-similar data types speakeasy
• 03:12   Re: nearest match Ryan Orth
• 03:12   Poor performance on a right join sarloc@jevic.com (Carmen)
• 03:12   Re: Create function statement with insert statement Ian Harding
• 03:12   Re: What's wrong with this group by clause? Len Morgan
• 03:18   Re: nearest match Larry Rosenman
• 05:57   Re: displaying correct name Tomasz Myrta
• 06:13   Re: Poor performance on a right join dev@archonet.com
• 08:39   Re: What's wrong with this group by clause? Manfred Koizar
• 08:52   Re: View - Join based on dis-similar data types Richard Huxton
• 09:02   Re: Deleting large object from table pg_largeobject Richard Huxton
• 12:30   Re: Create function statement with insert statement Susan Hoddinott
• 12:52   Re: Create function statement with insert statement Susan Hoddinott
• 13:05   Re: Create function statement with insert statement Christoph Haller
• 13:08   Re: Create function statement with insert statement Andreas Schmitz
• 14:35   look for latest user login in one table from a list of users in a nother Sill-II, Stephen
• 15:04   Re: look for latest user login in one table from a list of Achilleus Mantzios
• 15:11   Re: look for latest user login in one table from a list of users Jean-Luc Lachance
• 15:15   Re: look for latest user login in one table from a list of Sill-II, Stephen
• 15:50   Re: [HACKERS] What's wrong with this group by clause? Franco Bruno Borghesi
• 16:54   Re: Create function statement with insert statement Susan Hoddinott
• 16:58   Re: Create function statement with insert statement Susan Hoddinott
• 17:40   Re: Create function statement with insert statement Joe Conway
• 18:06   MapInfo and PostgreSQL how-to David Delorme

15 March 2003

• 13:38   help with table constraint / check cliff@cliffmeyers.com
• 14:15   Re: help with table constraint / check Bruno Wolff III
• 21:47   Retrieving Definition for Composite Type Jordan S. Jones
• 21:53   create index right after create table not working? Joost Witteveen

17 March 2003

• 06:01   String aggregate function Objectz
• 06:09   Re: create index right after create table not working? Manfred Koizar
• 06:30   How to compare dates? Abdul Wahab Dahalan
• 06:44   Re: How to compare dates? Victor Yegorov
• 06:58   Re: How to compare dates? Christoph Haller
• 07:15   Re: String aggregate function Tomasz Myrta
• 08:31   Re: How to compare dates? Achilleus Mantzios
• 08:35   Re: String aggregate function Objectz
• 08:55   Re: String aggregate function Tomasz Myrta
• 08:58   Re: String aggregate function Tomasz Myrta
• 09:25   Re: Create function statement with insert statement Christoph Haller
• 09:46   Formatting intervals.. Rajesh Kumar Mallah
• 09:55   Re: Formatting intervals.. Tomasz Myrta
• 11:04   Re: Formatting intervals.. Christoph Haller
• 11:04   Re: Formatting intervals.. Rajesh Kumar Mallah
• 12:02   Re: Formatting intervals.. Rajesh Kumar Mallah
• 12:09   Re: Formatting intervals.. Christoph Haller
• 12:14   Re: Formatting intervals.. Tomasz Myrta
• 12:26   Re: String aggregate function Objectz
• 12:26   Re: Formatting intervals.. Christoph Haller
• 12:31   Re: Formatting intervals.. Tomasz Myrta
• 12:53   Re: Formatting intervals.. Rajesh Kumar Mallah
• 15:09   howto? Sjors
• 15:39   Re: howto? Bruno Wolff III
• 16:00   Re: Formatting intervals.. Josh Berkus
• 16:02   Re: Formatting intervals.. Larry Rosenman
• 16:39   create index right after create table not working? joost witteveen
• 16:39   Howto?? J.C.M. van der Kwast
• 16:39   Re: two dates D.Sanchez
• 16:39   Min values? J.C.M. van der Kwast
• 16:57   Re: Howto?? chester c young
• 17:02   parse error when calling function in plpgsql David Witham
• 17:02   Re: Function calling error in postgreSQL 7.3.1 CoL
• 17:02   Re: Poor performance on a right join Carmen Sarlo
• 17:05   Re: Howto?? Tomasz Myrta
• 17:48   Re: parse error when calling function in plpgsql Tom Lane
• 18:00   Re: btree_gist, gint4_union Bruce Momjian
• 18:22   upcasting multiplication in a query John Guthrie
• 18:30   Re: Poor performance on a right join Tom Lane
• 18:33   Re: Poor performance on a right join dev@archonet.com
• 18:35   Re: upcasting multiplication in a query dev@archonet.com
• 18:50   Re: btree_gist, gint4_union Tom Lane
• 18:52   Re: upcasting multiplication in a query Tom Lane
• 19:06   Re: btree_gist, gint4_union Itai Zukerman

18 March 2003

• 00:01   Re: Create function statement with insert statement Susan Hoddinott
• 04:27   Count equals 0 Rudi Starcevic
• 05:22   PLPGSQL with Multibyte Issue Frankie Lam
• 05:45   Re: Formatting intervals.. Karel Zak
• 05:48   Re: PLPGSQL with Multibyte Issue Tatsuo Ishii
• 06:34   Re: PLPGSQL with Multibyte Issue Frankie Lam
• 06:36   Re: PLPGSQL with Multibyte Issue Tatsuo Ishii
• 09:17   the best way to get some records not in another table jack
• 09:36   Re: Min values? Christoph Haller
• 09:37   Re: Count equals 0 jasiek@klaster.net
• 11:47   Re: the best way to get some records not in another table Christoph Haller
• 12:07   Trigger issue, bug? on 7.2.1 Miguel Carvalho
• 13:24   Numeric type Alan Roberto Romaniuc
• 13:31   Re: Count equals 0 greg@turnstep.com
• 13:44   Re: Trigger issue, bug? on 7.2.1 Christoph Haller
• 14:35   Re: Count equals 0 Josh Berkus
• 14:54   outer join versus not exists chester c young
• 15:14   Re: Numeric type Tom Lane
• 15:16   Re: outer join versus not exists Bruno Wolff III
• 15:29   Re: outer join versus not exists Tom Lane
• 15:59   showing records from the last 20 min Matthew Nuzum
• 16:19   Re: showing records from the last 20 min Tomasz Myrta
• 16:35   Re: showing records from the last 20 min Matthew Nuzum
• 16:55   Re: Convert a text list to text array? Was: Denormalizing during Guy Fraser

19 March 2003

• 02:42   Number of rows affected by an update David Witham
• 02:59   Re: showing records from the last 20 min Rajesh Kumar Mallah
• 04:17   Casting with character and character varying David Loh
• 06:11   Re: Number of rows affected by an update Tomasz Myrta
• 06:37   vacuum all but system tables Victor Yegorov
• 08:02   Re: Casting with character and character varying Christoph Haller
• 10:18   Listing Users Kyle
• 10:27   Re: Listing Users Achilleus Mantzios
• 11:27   Re: howto/min values Sjors
• 11:32   Re: vacuum all but system tables A.Bhuvaneswaran
• 11:54   Re: howto/min values Christoph Haller
• 12:29   Re: vacuum all but system tables Tom Lane
• 12:39   Re: vacuum all but system tables Victor Yegorov
• 12:47   Re: vacuum all but system tables Tom Lane
• 12:52   Re: vacuum all but system tables Tomasz Myrta
• 12:59   Re: Casting with character and character varying Jeff Eckermann
• 13:01   Re: vacuum all but system tables Victor Yegorov
• 13:07   Re: howto/min values Sjors
• 14:18   integrity of column used to order rows cliff@cliffmeyers.com
• 14:50   Re: integrity of column used to order rows Ed L.
• 15:35   Re: Poor performance on a right join Carmen Sarlo
• 15:35   trouble with query alexj
• 16:49   Re: trouble with query jasiek@klaster.net
• 23:20   Re: the best way to get some records not in another table jack

20 March 2003

• 02:34   Is it possible to select encoding in PLPGSQL function? Frankie Lam
• 03:36   Re: Count equals 0 Rudi Starcevic
• 06:45   Re: vacuum all but system tables Tomasz Myrta
• 09:32   Re: query 2 database Olleg Samojlov
• 09:51   Re: query 2 database A.Bhuvaneswaran
• 10:45   Re: [GENERAL] Trigger issue, bug? on 7.2.1 Miguel Carvalho
• 10:47   SQL stored proc query (optimising) paul_smith1@talk21.com
• 13:08   Re: SQL stored proc query (optimising) Tom Lane
• 19:41   Help with LIKE David Olbersen
• 19:55   Re: [PERFORM] Help with LIKE Josh Berkus
• 21:19   Re: [PERFORM] Help with LIKE David Olbersen

21 March 2003

• 00:47   What this parser mean? Abdul Wahab Dahalan
• 00:52   Re: What this parser mean? David Witham
• 03:48   explain Popeanga Marian
• 04:11   Re: explain Popeanga Marian
• 04:18   Re: explain Roberto Mello
• 04:24   Re: explain Popeanga Marian
• 06:23   Re: explain Rajesh Kumar Mallah
• 06:28   Cant get all records from dbase Abdul Wahab Dahalan
• 06:30   Re: explain Popeanga Marian
• 08:04   Re: Formatting intervals.. Peter Eisentraut
• 08:30   Re: Formatting intervals.. Karel Zak
• 09:03   Re: explain Popeanga Marian
• 10:10   Re: explain Rajesh Kumar Mallah
• 10:38   Re: explain Popeanga Marian
• 11:08   Re: explain A.Bhuvaneswaran
• 11:36   cast of integer to bool doesn't work (anymore?) Eric Veldhuyzen
• 11:42   Re: cast of integer to bool doesn't work (anymore?) Achilleus Mantzios
• 12:19   Re: cast of integer to bool doesn't work (anymore?) Eric Veldhuyzen
• 12:34   Re: cast of integer to bool doesn't work (anymore?) Achilleus Mantzios
• 13:01   Re: cast of integer to bool doesn't work (anymore?) Eric Veldhuyzen
• 13:07   Re: cast of integer to bool doesn't work (anymore?) Tom Lane
• 13:08   Re: cast of integer to bool doesn't work (anymore?) Achilleus Mantzios
• 14:31   Re: explain 
• 17:28   Diffcult query Dan Winslow
• 17:28   Seeking help with a query.... Dan Winslow
• 17:28    Mario Alberto Soto Cordones
• 17:28   newline character in SQL Sethi Tarun-ETS017
• 17:28   Rule for updating through a view. Mike Meyer
• 17:28   query 2 database betty
• 17:28   FUNCTIONS PROBLEM Mario Alberto Soto Cordones
• 17:35   SQL Sethi Tarun-ETS017
• 17:46   Re: Diffcult query Josh Berkus
• 18:13   Re: Stephan Szabo
• 20:53   column label Ryan
• 21:17   Re: Diffcult query Josh Berkus

22 March 2003

• 04:04   Re: Diffcult query Lee Harr
• 04:15   Re: explain Popeanga Marian
• 06:02   SQL help for efficient time handling.. Rajesh Kumar Mallah
• 06:45   Re: explain Rajesh Kumar Mallah
• 06:48   Re: SQL help for efficient time handling.. Popeanga Marian
• 06:55   Re: SQL help for efficient time handling.. Rajesh Kumar Mallah
• 07:11   Re: SQL help for efficient time handling.. Popeanga Marian
• 08:03   Re: newline character in SQL Rajesh Kumar Mallah
• 09:57   ALTER TABLE does not raises WARNING/ERROR Rajesh Kumar Mallah
• 14:09   Re: ALTER TABLE does not raises WARNING/ERROR Stephan Szabo
• 14:10   Re: ALTER TABLE does not raises WARNING/ERROR Tom Lane
• 14:17   Re: SQL help for efficient time handling.. Stephan Szabo
• 15:47   Re: SQL help for efficient time handling.. 
• 15:49   Re: ALTER TABLE does not raises WARNING/ERROR 
• 16:30   Re: newline character in SQL 

23 March 2003

• 17:05   Re: Diffcult query Harald Fuchs
• 17:05   Re: newline character in SQL Sethi Tarun-ETS017
• 21:18   Re: FUNCTIONS PROBLEM David Witham

24 March 2003

• 02:43   Re: FUNCTIONS PROBLEM Rajesh Kumar Mallah
• 06:17   Which Approach Performs Better? CN
• 06:19   Re: Seeking help with a query.... Victor Yegorov
• 07:55   function with security definer Tomasz Myrta
• 07:55   Re: column label Tomasz Myrta
• 08:27   Complex outer joins? Correia, Carla
• 08:43   Re: Complex outer joins? Peter Childs
• 08:57   Re: query 2 database Christoph Haller
• 08:57   Complex outer joins? Correia, Carla
• 08:57   Re: Complex outer joins? Correia, Carla
• 12:22   Re: Seeking help with a query.... Christoph Haller
• 12:30   UPDATE FROM portability Andreas Pflug
• 13:02   Re: function with security definer Tom Lane
• 13:12   Re: Complex outer joins? Stephan Szabo
• 13:18   Re: Complex outer joins? Tom Lane
• 13:56   Re: What this parser mean? Guy Fraser
• 14:02   Re: Rule for updating through a view. Christoph Haller
• 16:17   Re: function with security definer Tomasz Myrta
• 16:36   Re: function with security definer Antti Haapala
• 16:44   Re: Rule for updating through a view. Mike Meyer

25 March 2003

• 13:01   Re: How to increase Column width of table Atul Pedgaonkar
• 13:18   Re: How to increase Column width of table Christoph Haller
• 14:47   Re: How to increase Column width of table Robert Treat
• 14:48   Re: column label Ryan
• 14:50   Re: How to increase Column width of table Andreas Pflug
• 15:31   Does anyone use TO_CHAR(INTERVAL)? Josh Berkus
• 15:33   How to show timestamp with milliseconds(3 digits) in Select clause in Ver7.1 ? Liang Luo
• 18:01   Insert race hazard condition. Roy Souther
• 18:08   Re: Insert race hazard condition. Bruno Wolff III
• 18:10   Re: Insert race hazard condition. Stephan Szabo
• 18:32   Re: Insert race hazard condition. patrick
• 20:24   Concatenation Snafu Thomas Good
• 21:01   Re: Concatenation Snafu Chad Thompson
• 21:27   Re: Concatenation Snafu Thomas Good
• 21:34   Re: Concatenation Snafu Tom Lane
• 21:53   Re: Concatenation Snafu Thomas Good
• 22:03   Re: Does anyone use TO_CHAR(INTERVAL)? Tomasz Myrta

26 March 2003

• 02:44   Re: Does anyone use TO_CHAR(INTERVAL)? Bruno Wolff III
• 05:10   Re: Does anyone use TO_CHAR(INTERVAL)? Karel Zak
• 06:08   Re: How to increase Column width of table Christoph Haller
• 06:34   Re: Does anyone use TO_CHAR(INTERVAL)? Tomasz Myrta
• 07:16   Re: How to show timestamp with milliseconds(3 digits) in Select Christoph Haller
• 07:50   Re: Does anyone use TO_CHAR(INTERVAL)? Peter Childs
• 07:55   Re: column label Christoph Haller
• 08:27   Re: UPDATE FROM portability Christoph Haller
• 08:38   Re: Does anyone use TO_CHAR(INTERVAL)? Tomasz Myrta
• 12:06   Re: How to show timestamp with milliseconds(3 digits) in Select clause in Ver7.1 ? Tom Lane
• 12:36   Re: Complex outer joins? Greg Stark
• 13:52   Re: Complex outer joins? Stephan Szabo
• 14:34   Re: Does anyone use TO_CHAR(INTERVAL)? Josh Berkus
• 16:09   order by Jodi Kanter
• 16:17   Re: UPDATE FROM portability Manfred Koizar
• 16:29   Re: order by Tomasz Myrta
• 16:44   Re: order by Stephan Szabo
• 16:47   How can I pass an array from PostgreSQL to C (libpq)? gar8@pitt.edu (Tony Reina)
• 17:08   Re: UPDATE FROM portability Andreas Pflug
• 17:10   Re: How can I pass an array from PostgreSQL to C (libpq)? Joe Conway
• 20:34   Re: Complex outer joins? Tom Lane
• 21:02   Re: Complex outer joins? Stephan Szabo
• 22:02   Off topic : world database Rudi Starcevic
• 22:54   Re: Off topic : world database Ryan
• 22:58   Re: Off topic : world database Michael A Nachbaur
• 23:31   Re: Off topic : world database Tamir Halperin
• 23:54   EXECUTE problem on schema jack

27 March 2003

• 00:24   Re: Off topic : world database Joe Conway
• 01:39   Re: Off topic : world database John Hasler
• 02:08   Database not restarting Stefan Berg
• 02:08   Re: Executing SQL commands via triggers without the use of procedures fabio
• 02:08   Re: How can I pass an array from PostgreSQL to C (libpq)? G. Anthony Reina
• 02:08   order by Jodi Kanter
• 02:35   Re: Complex outer joins? Greg Stark
• 02:54   Re: Off topic : world database Rudi Starcevic
• 03:36   Re: Complex outer joins? Stephan Szabo
• 04:18   Re: Complex outer joins? Tom Lane
• 04:23   Re: Database not restarting Josh Berkus
• 04:57   Re: order by Tom Lane
• 05:20   Re: Off topic : world database Achilleus Mantzios
• 05:23   Re: How can I pass an array from PostgreSQL to C (libpq)? Achilleus Mantzios
• 08:02   Re: Off topic : world database Tomasz Myrta
• 08:12   Re: EXECUTE problem on schema Ian Barwick
• 11:42   Re: Complex outer joins? Correia, Carla
• 12:16   Re: order by Jodi Kanter
• 12:38   Re: order by Tom Lane
• 12:44   Re: order by Jodi Kanter
• 12:49   Re: order by Jodi Kanter
• 13:06   Re: order by Julian Scarfe
• 15:03   Re: Off topic : world database Bruno Wolff III
• 15:06   Re: Off topic : world database Bruno Wolff III
• 22:59   Re: EXECUTE problem on schema jack

28 March 2003

• 00:40   How to configure two netcard for PostgreSQL? dailiming
• 03:50   Re: How to configure two netcard for PostgreSQL? Popeanga Marian
• 06:35   Re: EXECUTE problem on schema Ian Barwick
• 08:15   field defaults Peter Childs
• 11:41   Re: field defaults A.Bhuvaneswaran
• 11:55   Re: How to configure two netcard for PostgreSQL? Peter Eisentraut
• 11:56   Re: field defaults Peter Eisentraut
• 13:57   Re: How to show timestamp with milliseconds(3 digits) in Select clause in Ver7.1 ? Liang Luo
• 20:31   Stored procedures Zodiac
• 21:19   returning composite types. Franco Bruno Borghesi
• 21:41   Re: Stored procedures Franco Bruno Borghesi
• 22:32   Re: returning composite types. Jordan S. Jones

29 March 2003

• 14:19   Re: returning composite types. Franco Bruno Borghesi
• 14:51   Re: returning composite types. Joe Conway
• 15:35   Re: returning composite types. Franco Bruno Borghesi
• 16:27   Re: returning composite types. Joe Conway
• 16:58   Re: returning composite types. Franco Bruno Borghesi
• 18:35   Re: Stored procedures Zodiac
• 19:05   Re: Stored procedures Franco Bruno Borghesi
• 21:15   Re: Off topic : world database Alain Gougeon
• 21:31   Re: Off topic : world database Vernon

30 March 2003

• 10:54   to_number Kaare Rasmussen
• 11:56   Re: to_number Tomasz Myrta
• 16:24   Re: to_number Kaare Rasmussen
• 17:27   Re: to_number Tom Lane
• 17:58   Re: to_number Kaare Rasmussen
• 18:05   Re: Off topic : world database Bruno Wolff III
• 21:44   PHP LINK module (RPM format) for PostgreSQL V7.3 jack
• 22:30   Re: Off topic : world database Rudi Starcevic
• 23:05   Re: How to configure two netcard for PostgreSQL? dailiming

31 March 2003

• 00:15   Re: How to configure two netcard for PostgreSQL? Tom Lane
• 00:55   Re: How to configure two netcard for PostgreSQL? dailiming
• 13:38   Re: How to configure two netcard for PostgreSQL? dailiming
• 13:41   Re: How to configure two netcard for PostgreSQL? Tom Lane
• 13:43   Re: How to configure two netcard for PostgreSQL? Tomasz Myrta
• 13:44   Re: Off topic : world database Rajesh Kumar Mallah
• 13:51   Re: How to notice column changes in trigger Jan Wieck
• 13:58   create view with numeric data cio198@plasa.com (cio198)
• 15:00   Re: Off topic : world database Bruno Wolff III
• 15:53   Re: create view with numeric data Tom Lane
• 20:24   Re: create view with numeric data Tomasz Myrta