pgsql-sql - October 2004

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 31

Oct. 1, 2004

Thread Author Time
psql variable interpolation from command line Jeff Boes 13:24
Re: psql variable interpolation from command line Jeff Boes 13:28
Re: SELECT with Function Marcin Piotr Grondecki 16:46
Re: date_trunc'd timestamp index possible? Bruno Wolff III 18:28
Re: date_trunc'd timestamp index possible? D. Duccini 18:28
Re: date_trunc'd timestamp index possible? Bruno Wolff III 18:44
Re: [SQL] date_trunc'd timestamp index possible? Tom Lane 18:49
Re: date_trunc'd timestamp index possible? Tom Lane 21:17
Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) Tom Lane 22:53

Oct. 2, 2004

Thread Author Time
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) Bruno Wolff III 00:50
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd Gaetano Mendola 08:43
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) Peter Eisentraut 17:41
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) Tom Lane 18:22
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd Bruno Wolff III 20:04

Oct. 3, 2004

Thread Author Time
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd Bruno Wolff III 01:16
[No subject] Bosko Vukov 07:36
Concurrency problem Dag Gullberg 10:58
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd Gaetano Mendola 11:18
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) Mike Rylander 14:49
Re: Postgres Doubt John DeSoi 15:50
Re: Concurrency problem Tom Lane 17:15
How to convert 3 colums to timestamp with timezone Jens Arnfelt 20:50
Re: Stable function semantics (was Re: Mislabeled timestamp functions) Tom Lane 21:27
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) Greg Stark 21:49
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) Tom Lane 22:37
Re: How to convert 3 colums to timestamp with timezone Bruno Wolff III 23:42

Oct. 4, 2004

Thread Author Time
Difference between IN and JOIN Markus Bertheau 08:39
Re: Concurrency problem Dag Gullberg 11:35
Re: Concurrency problem Magnus Hagander 11:39
Re: Difference between IN and JOIN Tom Lane 14:17
Re: Difference between IN and JOIN Markus Bertheau 14:23

Oct. 5, 2004

Thread Author Time
Stuffing six separate columns into a single array? C. Bensend 03:56
Re: Stuffing six separate columns into a single array? Michael Fuhr 07:04
Re: Howto turn an integer into an interval? Achilleus Mantzios 11:44
Howto turn an integer into an interval? Erik Wasser 12:07
Re: Howto turn an integer into an interval? Pierre-Frédéric Caillaud 12:38
Re: Stuffing six separate columns into a single array? C. Bensend 13:26
Using timestamp in function Silke Trissl 15:37
Re: Using timestamp in function Tom Lane 16:06
Re: Using timestamp in function Michael Fuhr 16:19
Stored Procedures returning a RECORD Kent Anderson 17:52
Re: Stored Procedures returning a RECORD Jeff Eckermann 20:41

Oct. 6, 2004

Thread Author Time
Regex Theo Galanakis 00:52
Database Backup sreejith s 02:39
Re: Regex Tom Lane 03:36
Re: Howto turn an integer into an interval? sad 05:01
Re: Regex Theo Galanakis 05:44
Re: Howto turn an integer into an interval? Erik Wasser 08:13
Re: Database Backup sklassen 15:19
Table locks Jaime Casanova 20:36

Oct. 7, 2004

Thread Author Time
Query from different Database Abdul Wahab Dahalan 08:52
Re: Query from different Database Robert Creager 14:05
Re: Query from different Database Jaime Casanova 20:58

Oct. 8, 2004

Thread Author Time
help on a query Michelle Murrain 03:03
Re: help on a query Thomas F.O'Connell 03:10
Re: help on a query sad 04:44
Re: help on a query CHRIS HOOVER 13:02
Re: help on a query Achilleus Mantzios 13:03
Re: help on a query Thomas F.O'Connell 15:06
Re: help on a query Michelle Murrain 15:19
Record Count sreejith s 17:51
Re: Record Count Michael Fuhr 19:32

Oct. 9, 2004

Thread Author Time
Re: help on a query Greg Stark 03:17
Impact of foreign keys on a simple count(*) ? C. Bensend 03:37
Re: Impact of foreign keys on a simple count(*) ? Tom Lane 03:49
Re: Impact of foreign keys on a simple count(*) ? C. Bensend 04:13
Re: SELECT with Function Paulo Nievierowski 15:11
How do FKs work? Marc G. Fournier 18:08
SQL confusion Andrew Ward 20:39
Re: SQL confusion Richard Poole 21:11
Re: SQL confusion Michael Fuhr 21:59

Oct. 10, 2004

Thread Author Time
Re: How do FKs work? Tom Lane 00:23
Re: How do FKs work? Marc G. Fournier 00:43
Re: How do FKs work? Marc G. Fournier 00:48
Re: How do FKs work? Janning Vygen 12:24
Re: How do FKs work? Marc G. Fournier 13:01
SQL doubt - Date Add sreejith s 14:19
Re: SQL doubt - Date Add Gaetano Mendola 14:36
Re: SQL doubt - Date Add Gaetano Mendola 14:37
Export tab delimited from mysql to postgres. Theo Galanakis 22:59

Oct. 11, 2004

Thread Author Time
Re: SQL doubt - Date Add Richard Huxton 09:21
Re: Export tab delimited from mysql to postgres. Harald Fuchs 09:33
table update using result from join Gary Stainburn 09:49
Re: How do FKs work? Janning Vygen 11:03
Re: Export tab delimited from mysql to postgres. Theo Galanakis 23:23
Re: Export tab delimited from mysql to postgres. Bruno Wolff III 23:40

Oct. 12, 2004

Thread Author Time
Re: Export tab delimited from mysql to postgres. Christopher Browne 00:46
[No subject] Ramiro Batista da Luz 00:52
Re: Export tab delimited from mysql to postgres. Theo Galanakis 05:33
Re: Export tab delimited from mysql to postgres. Pierre-Frédéric Caillaud 07:20
the problem of createlang! Fang Genjie 08:01
Information about the command SQL " create synonym". Gerald.Laurent 13:04
PL/pgSQL, RETURN NEXT, ORDER Markus Bertheau 13:24
Re: PL/pgSQL, RETURN NEXT, ORDER Markus Bertheau 13:41
Re: Export tab delimited from mysql to postgres. Tom Lane 13:56
JDBC +CIDR Johann Robette 15:54
Re: SQL confusion Thomas F.O'Connell 17:01
Re: Information about the command SQL " create synonym". Peter Eisentraut 17:37
Re: Export tab delimited from mysql to postgres. Theo Galanakis 23:56

Oct. 13, 2004

Thread Author Time
help with to_date and to_char Lori 00:20
Plperlu function & backticks return value -> truncated? Philippe Lang 15:07
Re: Plperlu function & backticks return value -> truncated? Richard Huxton 15:25
Re: Plperlu function & backticks return value -> truncated? Philippe Lang 15:42
Re: Plperlu function & backticks return value -> truncated? Michael Fuhr 15:47
Re: Plperlu function & backticks return value -> truncated? Philippe Lang 15:54

Oct. 14, 2004

Thread Author Time
libpq-fe: PQgetvalue() ? sad 12:34

Oct. 15, 2004

Thread Author Time
Re: libpq-fe: PQgetvalue() ? ljb 00:51
Inserting into table only if the row does not already exist. C. Bensend 04:18
Re: Inserting into table only if the row does not already exist. Greg Stark 05:10
Re: libpq-fe: PQgetvalue() ? Christoph Haller 08:57
Re: Inserting into table only if the row does not already C. Bensend 13:14
Re: libpq-fe: PQgetvalue() ? Tom Lane 14:21

Oct. 16, 2004

Thread Author Time
need query advice Stephan Fiebrandt 09:08

Oct. 17, 2004

Thread Author Time
Re: Inserting into table only if the row does not already Steven Klassen 00:49
Re: Inserting into table only if the row does not already C. Bensend 01:09
Database backup sreejith s 03:19
Re: Database backup Steven Klassen 03:34
Re: Inserting into table only if the row does not already Greg Stark 05:22
Re: Inserting into table only if the row does not already C. Bensend 06:04

Oct. 18, 2004

Thread Author Time
Installation woes Richard Sydney-Smith 13:56
Re: Installation woes Magnus Hagander 15:12
bibliographic schema Guillaume 15:18
Aggregate Function with Argument David Siegal 15:24
Ordering a record returned from a stored procedure Kent Anderson 15:59
Re: Aggregate Function with Argument Bruno Wolff III 16:05
Re: Ordering a record returned from a stored procedure Stephan Szabo 16:25
problems using phpPgAmin beyaNet 16:28
Re: problems using phpPgAmin Richard_D_Levine 16:39
Re: Database backup Andreas 16:39
Re: Ordering a record returned from a stored procedure - date issue Kent Anderson 18:32
Re: Ordering a record returned from a stored procedure - date issue Kent Anderson 19:17
Re: problems using phpPgAmin Oliver Elphick 19:35
Re: bibliographic schema Josh Berkus 20:10

Oct. 19, 2004

Thread Author Time
Re: bibliographic schema Karsten Hilbert 07:17
Re: Ordering a record returned from a stored procedure - date Richard Huxton 08:21
Re: problems using phpPgAmin Mark Gibson 11:47
Re: bibliographic schema Guillaume 11:56
Re: Aggregate Function with Argument Mark Gibson 14:50
Re: help with to_date and to_char Thomas F.O'Connell 21:27
Re: the problem of createlang! Tom Lane 21:31
Re: help with to_date and to_char Edmund Bacon 23:00
Re: help with to_date and to_char Edmund Bacon 23:05
Re: help with to_date and to_char lorid 23:08

Oct. 20, 2004

Thread Author Time
Re: need query advice Pierre-Frédéric Caillaud 00:14
Which type of functions are best? Postgres User 02:41
Re: help with to_date and to_char Thomas F.O'Connell 03:29
Cross tabulations Muhyiddin A.M Hayat 04:43
Re: Cross tabulations Greg Stark 06:35
SQL update function faililed in Webmin Interface Kathiravan Velusamy 07:03
Re: [SQL] SQL update function faililed in Webmin Interface Richard Huxton 07:37
Re: SQL update function faililed in Webmin Interface Scott Marlowe 07:49
Reuse previously calculated column in sql query? Philippe Lang 12:50
Re: Reuse previously calculated column in sql query? Rod Taylor 13:05
Re: the problem of createlang! Weiping 14:57
time of constraint checking Markus Bertheau 15:58
Re: time of constraint checking Markus Bertheau 16:16
Re: time of constraint checking Stephan Szabo 16:56
"copy from" in "create function" Gifford Hesketh 22:03

Oct. 21, 2004

Thread Author Time
Re: Reuse previously calculated column in sql query? Iain 01:31
Offtopic: psql sad 11:58
Re: Offtopic: psql Achilleus Mantzios 12:35
Re: Aggregate Function with Argument David Siegal 15:26
Finding duplicated values Kent Anderson 18:58
Re: Finding duplicated values Bricklen 19:20
Re: Finding duplicated values Stephan Szabo 20:09
Trouble with explicit joins Dmitry Tkach 22:44
Re: Finding duplicated values lorid 23:18
Re: Trouble with explicit joins Tom Lane 23:32
Re: Trouble with explicit joins Dmitry Tkach 23:36

Oct. 22, 2004

Thread Author Time
Question on the 8.0Beta Version Davide Negri 06:59
Re: Finding duplicated values Christoph Haller 07:49
now() + integer, not rounded to whole day JN 12:04
Re: Functions return a select in a table, which data type I Markus Bertheau 13:38
Log Davide Negri 13:52

Oct. 23, 2004

Thread Author Time
Re: Question on the 8.0Beta Version Gaetano Mendola 22:08

Oct. 24, 2004

Thread Author Time
Re: [GENERAL] Question on the 8.0Beta Version Scott Marlowe 01:06
Re: Log Scott Marlowe 01:08
Re: Question on the 8.0Beta Version Harald Armin Massa 10:19

Oct. 25, 2004

Thread Author Time
Create interval using column value? Larry Lennhoff 02:54
Re: Create interval using column value? Tom Lane 03:11
Re: Create interval using column value? Michael Glaesemann 03:13
Re: Create interval using column value? Larry Lennhoff 03:18
sql cristivoinicaru 08:13
Re: Cross tabulations Muhyiddin A.M Hayat 08:49
Re: now() + integer, not rounded to whole day JN 09:27
Re: sql Andrei Bintintan 10:04
Re: bibliographic schema James Cloos 10:36
Re: sql Mike Rylander 11:20
Re: sql Andrew J. Kopciuch 11:44
Re: sql Mike Rylander 13:05
Re: now() + integer, not rounded to whole day Bruno Wolff III 16:32
Re: "copy from" in "create function" Jan Wieck 17:19
plpgsql: PERFORM vs. SELECT INTO (PERFORM not setting FOUND variable?) Marinos Yannikos 19:44
Re: plpgsql: PERFORM vs. SELECT INTO (PERFORM not setting FOUND variable?) Tom Lane 20:02
Re: plpgsql: PERFORM vs. SELECT INTO (PERFORM not setting FOUND Edmund Bacon 20:08

Oct. 26, 2004

Thread Author Time
Re: [HACKERS] Question on the 8.0Beta Version Adrian Maier 06:13
How to recognize trigger-inserted rows? Jeff Boes 16:27
How to recognize trigger-inserted rows? Jeff Boes 17:00
How to re-sort a sorted query? Yudie 19:23
How do you compare (NULL) and (non-NULL)? Wei Weng 20:23

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 31