Home > mailing lists

Mailing lists [pgsql-sql]

1 October 2004

17:39 Re: psql variable interpolation from command line Jeff Boes
17:39 psql variable interpolation from command line Jeff Boes
22:18 Re: [NOVICE] date_trunc'd timestamp index possible? Bruno Wolff III
22:34 Re: [NOVICE] date_trunc'd timestamp index possible? Bruno Wolff III
22:49 Re: [NOVICE] date_trunc'd timestamp index possible? Tom Lane

2 October 2004

01:17 Re: [NOVICE] date_trunc'd timestamp index possible? Tom Lane

3 October 2004

14:57 Concurrency problem Dag Gullberg
18:27 date_trunc'd timestamp index possible? D. Duccini
18:27 Error : could not send data to client vab ip
18:27 Postgres Doubt sreejith s
18:30 Bosko Vukov
18:30 Re: SELECT with Function Marcin Piotr Grondecki
18:30 Re: [NOVICE] date_trunc'd timestamp index possible? D. Duccini
19:52 Re: Postgres Doubt John DeSoi
21:16 Re: Concurrency problem Tom Lane

4 October 2004

00:50 How to convert 3 colums to timestamp with timezone Jens Arnfelt
03:32 Re: How to convert 3 colums to timestamp with timezone Bruno Wolff III
12:40 Difference between IN and JOIN Markus Bertheau
15:33 Re: Concurrency problem Dag Gullberg
15:39 Re: Concurrency problem Magnus Hagander
18:17 Re: Difference between IN and JOIN Tom Lane
18:24 Re: Difference between IN and JOIN Markus Bertheau

5 October 2004

07:56 Stuffing six separate columns into a single array? C. Bensend
11:04 Re: Stuffing six separate columns into a single array? Michael Fuhr
16:07 Howto turn an integer into an interval? Erik Wasser
16:29 Re: Howto turn an integer into an interval? Achilleus Mantzios
16:37 Re: Howto turn an integer into an interval? Pierre-Frédéric Caillaud
17:27 Re: Stuffing six separate columns into a single array? C. Bensend
19:38 Using timestamp in function Silke Trissl
20:07 Re: Using timestamp in function Tom Lane
20:19 Re: Using timestamp in function Michael Fuhr
21:53 Stored Procedures returning a RECORD Kent Anderson

6 October 2004

00:42 Re: Stored Procedures returning a RECORD Jeff Eckermann
04:56 Regex Theo Galanakis
06:39 Database Backup sreejith s
07:36 Re: Regex Tom Lane
09:48 Re: Regex Theo Galanakis
09:52 Re: Howto turn an integer into an interval? sad
12:13 Re: Howto turn an integer into an interval? Erik Wasser
19:19 Re: Database Backup sklassen@commandprompt.com

7 October 2004

00:36 Table locks Jaime Casanova
13:49 Query from different Database Abdul Wahab Dahalan
18:06 Re: Query from different Database Robert Creager

8 October 2004

00:58 Re: Query from different Database Jaime Casanova
07:03 help on a query Michelle Murrain
07:10 Re: help on a query Thomas F.O'Connell
09:34 Re: help on a query sad
17:06 Re: help on a query CHRIS HOOVER
17:48 Re: help on a query Achilleus Mantzios
19:07 Re: help on a query Thomas F.O'Connell
19:21 Re: help on a query Michelle Murrain
21:52 Record Count sreejith s
23:32 Re: Record Count Michael Fuhr

9 October 2004

07:18 Re: help on a query Greg Stark
07:38 Impact of foreign keys on a simple count(*) ? C. Bensend
07:49 Re: Impact of foreign keys on a simple count(*) ? Tom Lane
08:13 Re: Impact of foreign keys on a simple count(*) ? C. Bensend
19:08 Re: SELECT with Function Paulo Nievierowski

10 October 2004

00:39 SQL confusion Andrew Ward
01:12 Re: SQL confusion Richard Poole
02:00 Re: SQL confusion Michael Fuhr
04:03 How do FKs work? Marc G. Fournier
04:24 Re: How do FKs work? Tom Lane
04:44 Re: How do FKs work? Marc G. Fournier
04:49 Re: How do FKs work? Marc G. Fournier
16:24 Re: How do FKs work? Janning Vygen
17:01 Re: How do FKs work? Marc G. Fournier
18:20 SQL doubt - Date Add sreejith s
18:50 Re: SQL doubt - Date Add Gaetano Mendola
18:50 Re: SQL doubt - Date Add Gaetano Mendola

11 October 2004

03:03 Export tab delimited from mysql to postgres. Theo Galanakis
13:21 Re: SQL doubt - Date Add Richard Huxton
13:40 Re: Export tab delimited from mysql to postgres. Harald Fuchs
13:49 table update using result from join Gary Stainburn
15:04 Re: How do FKs work? Janning Vygen

12 October 2004

03:27 Re: Export tab delimited from mysql to postgres. Theo Galanakis
03:31 Re: Export tab delimited from mysql to postgres. Bruno Wolff III
04:48 Re: Export tab delimited from mysql to postgres. Christopher Browne
04:53 ... Ramiro Batista da Luz
09:38 Re: Export tab delimited from mysql to postgres. Theo Galanakis
11:16 Re: Export tab delimited from mysql to postgres. Pierre-Frédéric Caillaud
17:05 Information about the command SQL " create synonym". Gerald.Laurent@bull.net
17:25 PL/pgSQL, RETURN NEXT, ORDER Markus Bertheau
17:41 Re: PL/pgSQL, RETURN NEXT, ORDER Markus Bertheau
17:56 Re: Export tab delimited from mysql to postgres. Tom Lane
19:55 JDBC +CIDR Johann Robette
21:02 Re: SQL confusion Thomas F.O'Connell
21:38 Re: Information about the command SQL " create synonym". Peter Eisentraut

13 October 2004

03:59 Re: Export tab delimited from mysql to postgres. Theo Galanakis
19:07 Plperlu function & backticks return value -> truncated? Philippe Lang
19:25 Re: Plperlu function & backticks return value -> truncated? Richard Huxton
19:42 Re: Plperlu function & backticks return value -> truncated? Philippe Lang
19:47 Re: Plperlu function & backticks return value -> truncated? Michael Fuhr
19:54 Re: Plperlu function & backticks return value -> truncated? Philippe Lang

14 October 2004

17:24 libpq-fe: PQgetvalue() ? sad

15 October 2004

08:18 Inserting into table only if the row does not already exist. C. Bensend
09:11 Re: Inserting into table only if the row does not already exist. Greg Stark
12:57 Re: libpq-fe: PQgetvalue() ? Christoph Haller
17:15 Re: Inserting into table only if the row does not already C. Bensend
18:21 Re: libpq-fe: PQgetvalue() ? Tom Lane

17 October 2004

04:49 Re: Inserting into table only if the row does not already Steven Klassen
05:10 Re: Inserting into table only if the row does not already C. Bensend
07:19 Database backup sreejith s
07:34 Re: Database backup Steven Klassen
09:22 Re: Inserting into table only if the row does not already Greg Stark
10:05 Re: Inserting into table only if the row does not already C. Bensend

18 October 2004

17:56 Installation woes Richard Sydney-Smith
19:13 Re: Installation woes Magnus Hagander
19:18 bibliographic schema Guillaume
19:33 Aggregate Function with Argument David Siegal
19:55 Re: Aggregate Function with Argument Bruno Wolff III
20:00 Ordering a record returned from a stored procedure Kent Anderson
20:25 Re: Ordering a record returned from a stored procedure Stephan Szabo
20:29 problems using phpPgAmin beyaNet
20:38 Re: Database backup Andreas
20:39 Re: problems using phpPgAmin Richard_D_Levine@raytheon.com
22:33 Re: Ordering a record returned from a stored procedure - date issue Kent Anderson
23:18 Re: Ordering a record returned from a stored procedure - date issue Kent Anderson
23:35 Re: problems using phpPgAmin Oliver Elphick

19 October 2004

00:08 Re: bibliographic schema Josh Berkus
11:21 Re: bibliographic schema Karsten Hilbert
12:22 Re: Ordering a record returned from a stored procedure - date Richard Huxton
15:47 Re: problems using phpPgAmin Mark Gibson
15:57 Re: bibliographic schema Guillaume
18:50 Re: Aggregate Function with Argument Mark Gibson

20 October 2004

01:03 help with to_date and to_char Lori
01:03 the problem of createlang! Fang Genjie
01:15 Re: libpq-fe: PQgetvalue() ? ljb
01:15 need query advice Stephan Fiebrandt
01:28 Re: help with to_date and to_char Thomas F.O'Connell
01:32 Re: the problem of createlang! Tom Lane
03:00 Re: help with to_date and to_char Edmund Bacon
03:01 Re: help with to_date and to_char lorid
03:05 Re: help with to_date and to_char Edmund Bacon
04:14 Re: need query advice Pierre-Frédéric Caillaud
06:40 Which type of functions are best? Postgres User
07:29 Re: help with to_date and to_char Thomas F.O'Connell
08:45 Cross tabulations Muhyiddin A.M Hayat
10:35 Re: Cross tabulations Greg Stark
11:04 SQL update function faililed in Webmin Interface Kathiravan Velusamy
11:37 Re: SQL update function faililed in Webmin Interface Richard Huxton
16:50 Reuse previously calculated column in sql query? Philippe Lang
17:08 Re: Reuse previously calculated column in sql query? Rod Taylor
19:22 Re: the problem of createlang! Weiping
19:22 Re: [GENERAL] SQL update function faililed in Webmin Interface Scott Marlowe
19:58 time of constraint checking Markus Bertheau
20:16 Re: time of constraint checking Markus Bertheau
20:56 Re: time of constraint checking Stephan Szabo

21 October 2004

05:31 Re: Reuse previously calculated column in sql query? Iain
16:48 Offtopic: psql sad
17:18 Re: Offtopic: psql Achilleus Mantzios
22:59 Finding duplicated values Kent Anderson

22 October 2004

00:10 Re: Finding duplicated values Stephan Szabo
02:44 Trouble with explicit joins Dmitry Tkach
03:03 Functions return a select in a table, which data type I must use? (Brazilian User) André Toscano
03:32 Re: Trouble with explicit joins Tom Lane
03:36 Re: Trouble with explicit joins Dmitry Tkach
09:11 Re: Finding duplicated values lorid
11:49 Re: Finding duplicated values Christoph Haller
17:39 Re: Functions return a select in a table, which data type I Markus Bertheau

25 October 2004

06:54 Create interval using column value? Larry Lennhoff
07:12 Re: Create interval using column value? Tom Lane
07:14 Re: Create interval using column value? Michael Glaesemann
07:19 Re: Create interval using column value? Larry Lennhoff
11:14 sql cristivoinicaru
12:50 Re: Cross tabulations Muhyiddin A.M Hayat
14:04 Re: sql Andrei Bintintan
14:36 Re: bibliographic schema James Cloos
15:20 Re: sql Mike Rylander
15:42 Re: sql Andrew J. Kopciuch
17:05 Re: sql Mike Rylander
20:00 "copy from" in "create function" Gifford Hesketh
20:00 Question on the 8.0Beta Version Davide Negri
20:00 Re: now() + integer, not rounded to whole day jirinej@volny.cz (JN)
20:00 Re: Aggregate Function with Argument David Siegal
20:02 Re: Finding duplicated values Bricklen
20:04 now() + integer, not rounded to whole day jirinej@volny.cz (JN)
20:06 Re: [GENERAL] Log Scott Marlowe
20:08 Log Davide Negri
20:22 Re: now() + integer, not rounded to whole day Bruno Wolff III
21:19 Re: "copy from" in "create function" Jan Wieck
23:45 plpgsql: PERFORM vs. SELECT INTO (PERFORM not setting FOUND variable?) Marinos Yannikos

26 October 2004

00:02 Re: plpgsql: PERFORM vs. SELECT INTO (PERFORM not setting FOUND variable?) Tom Lane
00:08 Re: plpgsql: PERFORM vs. SELECT INTO (PERFORM not setting FOUND Edmund Bacon
21:22 How to recognize trigger-inserted rows? jboes@nexcerpt.com (Jeff Boes)
23:25 How to re-sort a sorted query? Yudie

27 October 2004

00:20 How do you compare (NULL) and (non-NULL)? Wei Weng
00:35 Re: How to re-sort a sorted query? Oliver Elphick
00:50 Re: How do you compare (NULL) and (non-NULL)? Stephan Szabo
01:01 Re: How do you compare (NULL) and (non-NULL)? Jerome Alet
01:34 Re: How to re-sort a sorted query? Yudie
01:46 Re: How to re-sort a sorted query? Tom Lane
01:58 Re: How to re-sort a sorted query? Oliver Elphick
17:18 RULE and default nextval() column Dmitry P. Ovechkin
18:12 Re: RULE and default nextval() column Stephan Szabo
19:22 How to recognize trigger-inserted rows? Jeff Boes
19:25 Re: How do you compare (NULL) and (non-NULL)? Bruno Wolff III
19:31 Re: How to re-sort a sorted query? Yudie

28 October 2004

14:03 Select Instead on a table Markus Schaber
14:21 curious delay on view/where Gary Stainburn
14:47 Re: extra info - curious delay on view/where Gary Stainburn
18:22 Re: Select Instead on a table Tom Lane
18:25 Re: curious delay on view/where Tom Lane
18:49 Re: extra info - curious delay on view/where andre.toscano
19:06 Re: curious delay on view/where Gary Stainburn
20:58 Re: Select Instead on a table Markus Schaber

29 October 2004

13:09 Re: Functions return a select in a table, which data type I Markus Bertheau
19:56 Re: How do you compare (NULL) and (non-NULL)? Wei Weng
21:47 Re: How do you compare (NULL) and (non-NULL)? Bruno Wolff III
21:48 Re: extra info - curious delay on view/where Markus Schaber

31 October 2004

04:25 Re: ORDER BY and NULLs Murphy Pope
08:43 JOIN not being calculated correctly Scott Pederick
08:43 Foreign Key Non-Null Problem in 8.0 Jon Uhal
08:53 Re: ORDER BY and NULLs Murphy Pope
08:55 Re: ORDER BY and NULLs Murphy Pope
09:22 Re: Foreign Key Non-Null Problem in 8.0 Stephan Szabo