Home > mailing lists

Mailing lists [pgsql-sql]

1 October 2004

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

3 October 2004

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

4 October 2004

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

5 October 2004

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

6 October 2004

01:56 Regex Theo Galanakis
03:39 Database Backup sreejith s
04:36 Re: Regex Tom Lane
06:48 Re: Regex Theo Galanakis
06:52 Re: Howto turn an integer into an interval? sad
09:13 Re: Howto turn an integer into an interval? Erik Wasser
16:19 Re: Database Backup sklassen@commandprompt.com
21:36 Table locks Jaime Casanova

7 October 2004

10:49 Query from different Database Abdul Wahab Dahalan
15:06 Re: Query from different Database Robert Creager
21:58 Re: Query from different Database Jaime Casanova

8 October 2004

04:03 help on a query Michelle Murrain
04:10 Re: help on a query Thomas F.O'Connell
06:34 Re: help on a query sad
14:06 Re: help on a query CHRIS HOOVER
14:48 Re: help on a query Achilleus Mantzios
16:07 Re: help on a query Thomas F.O'Connell
16:21 Re: help on a query Michelle Murrain
18:52 Record Count sreejith s
20:32 Re: Record Count Michael Fuhr

9 October 2004

04:18 Re: help on a query Greg Stark
04:38 Impact of foreign keys on a simple count(*) ? C. Bensend
04:49 Re: Impact of foreign keys on a simple count(*) ? Tom Lane
05:13 Re: Impact of foreign keys on a simple count(*) ? C. Bensend
16:08 Re: SELECT with Function Paulo Nievierowski
21:39 SQL confusion Andrew Ward
22:12 Re: SQL confusion Richard Poole
23:00 Re: SQL confusion Michael Fuhr

10 October 2004

01:03 How do FKs work? Marc G. Fournier
01:24 Re: How do FKs work? Tom Lane
01:44 Re: How do FKs work? Marc G. Fournier
01:49 Re: How do FKs work? Marc G. Fournier
13:24 Re: How do FKs work? Janning Vygen
14:01 Re: How do FKs work? Marc G. Fournier
15:20 SQL doubt - Date Add sreejith s
15:50 Re: SQL doubt - Date Add Gaetano Mendola
15:50 Re: SQL doubt - Date Add Gaetano Mendola

11 October 2004

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

12 October 2004

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

13 October 2004

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

14 October 2004

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

15 October 2004

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

17 October 2004

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

18 October 2004

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

19 October 2004

08:21 Re: bibliographic schema Karsten Hilbert
09:22 Re: Ordering a record returned from a stored procedure - date Richard Huxton
12:47 Re: problems using phpPgAmin Mark Gibson
12:57 Re: bibliographic schema Guillaume
15:50 Re: Aggregate Function with Argument Mark Gibson
22:03 help with to_date and to_char Lori
22:03 the problem of createlang! Fang Genjie
22:15 Re: libpq-fe: PQgetvalue() ? ljb
22:15 need query advice Stephan Fiebrandt
22:28 Re: help with to_date and to_char Thomas F.O'Connell
22:32 Re: the problem of createlang! Tom Lane

20 October 2004

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

21 October 2004

02:31 Re: Reuse previously calculated column in sql query? Iain
13:48 Offtopic: psql sad
14:18 Re: Offtopic: psql Achilleus Mantzios
19:59 Finding duplicated values Kent Anderson
21:10 Re: Finding duplicated values Stephan Szabo
23:44 Trouble with explicit joins Dmitry Tkach

22 October 2004

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

25 October 2004

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

26 October 2004

18:22 How to recognize trigger-inserted rows? jboes@nexcerpt.com (Jeff Boes)
20:25 How to re-sort a sorted query? Yudie
21:20 How do you compare (NULL) and (non-NULL)? Wei Weng
21:35 Re: How to re-sort a sorted query? Oliver Elphick
21:50 Re: How do you compare (NULL) and (non-NULL)? Stephan Szabo
22:01 Re: How do you compare (NULL) and (non-NULL)? Jerome Alet
22:34 Re: How to re-sort a sorted query? Yudie
22:46 Re: How to re-sort a sorted query? Tom Lane
22:58 Re: How to re-sort a sorted query? Oliver Elphick

27 October 2004

14:18 RULE and default nextval() column Dmitry P. Ovechkin
15:12 Re: RULE and default nextval() column Stephan Szabo
16:22 How to recognize trigger-inserted rows? Jeff Boes
16:25 Re: How do you compare (NULL) and (non-NULL)? Bruno Wolff III
16:31 Re: How to re-sort a sorted query? Yudie

28 October 2004

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

29 October 2004

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

31 October 2004

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