pgsql-sql since 2003-02-01 00:00

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

Feb. 1, 2003

Thread Author Time
Re: For each record in SELECT Keary Suska 01:28
Re: CSV import Guy Fraser 01:32
Re: [SQL] For each record in SELECT Andrew J. Kopciuch 02:36
Re: Controlling access to Sequences Tom Lane 04:09
Re: Controlling access to Sequences Matthew Horoschun 04:28
Re: Controlling access to Sequences Tom Lane 04:43
Re: [NOVICE] For each record in SELECT Andrew McMillan 04:43
Re: Which version is this? Rajesh Kumar Mallah. 05:03
Re: Controlling access to Sequences Matthew Horoschun 05:09
Re: Controlling access to Sequences Stephan Szabo 06:14
Re: Controlling access to Sequences Bruno Wolff III 06:39
update and IN vs. EXISTS pginfo 11:40
vacuum and serial primary keys Carmen Marincu 12:45
Re: update and IN vs. EXISTS pginfo 13:49
Re: vacuum and serial primary keys D'Arcy J.M. Cain 14:16
Re: update and IN vs. EXISTS Bruno Wolff III 14:54
Re: Controlling access to Sequences Ross J. Reedstrom 23:42

Feb. 2, 2003

Thread Author Time
Re: how can i convert a substring to a date? Ross J. Reedstrom 07:16
Returning records from a function John C 07:20
Re: Postgres MD5 Function Joe Conway 07:29
Re: Postgres MD5 Function David Durst 07:45
Re: CR/LF conversion (was: import error) Bruce Momjian 08:14
Re: returning table from a function mallah 13:02
Re: Help with a query for charting mallah 14:39
help: pgSQL docs and debug Vic Cekvenich 14:47
How to return records from a function John Cavacas 15:44
Re: How to return records from a function jasiek 15:52
Re: How to return records from a function John Cavacas 16:34
Re: help: pgSQL docs and debug Tomasz Myrta 17:34
Re: how do i create a date from a substring??? Tomasz Myrta 17:40
Re: Help with a query for charting greg 20:25
Re: COPY use in function with variable file name Oliver Elphick 21:30
7.2 functions that return multiple result sets? mail.luckydigital.com 21:45
[No subject] mail.luckydigital.com 21:47
Re: PL/pgSQL question Josh Berkus 21:59
Re: Oliver Elphick 22:12
Re: extracting constraints from schema Tomasz Myrta 23:51

Feb. 3, 2003

Thread Author Time
window version of psql of postgreSQL v7.3.1 jack 00:54
TEMP tables Lex Berezhny 01:25
Re: TEMP tables Bruce Momjian 01:58
Re: update and IN vs. EXISTS Tambet Matiisen 08:37
Re: TEMP tables Tomasz Myrta 09:55
Re: Commenting PLPGSQL Tomasz Myrta 10:01
Commenting PLPGSQL David Durst 10:17
Re: Format in psql Tomasz Myrta 10:46
Re: Format in psql Ian Barwick 10:50
Format in psql Bhuvan A 10:54
Automatic casting Vicente Alabau Gonzalvo 12:08
numeric when compared to literal Vicente Alabau Gonzalvo 12:45
cannot EXPLAIN query... Rajesh Kumar Mallah. 14:02
Re: cannot EXPLAIN query... Tomasz Myrta 14:15
Re: cannot EXPLAIN query... Tom Lane 14:46
Re: cannot EXPLAIN query... Rajesh Kumar Mallah. 15:38
Re: cannot EXPLAIN query... Tom Lane 15:40
Re: cannot EXPLAIN query... Tom Lane 15:45
Re: cannot EXPLAIN query... Bruce Momjian 15:47
Re: cannot EXPLAIN query... Rajesh Kumar Mallah. 15:49
Re: cannot EXPLAIN query... Christoph Haller 15:50
Re: cannot EXPLAIN query... Rajesh Kumar Mallah. 15:54
Re: cannot EXPLAIN query... Rajesh Kumar Mallah. 15:59
Re: cannot EXPLAIN query... Rajesh Kumar Mallah. 16:32
unsubscribe Josef Astner 16:40
Re: cannot EXPLAIN query... mallah 17:34
Serialized Transaction Locking Issues Jasper Tymesman 18:58
Re: Server access thru webmin Robert Treat 19:17
float and numeric in 7.3 Tomasz Myrta 19:36
SQL99/SQL92 Grammar Les Hazlewood 21:36
Re: float and numeric in 7.3 Tom Lane 21:54

Feb. 4, 2003

Thread Author Time
pg_views Lex Berezhny 02:34
Re: Format in psql Bhuvan A 05:26
iceberg queries Wei Weng 05:38
Re: iceberg queries Christoph Haller 08:39
Re: pg_views Christoph Haller 09:02
Re: SQL99/SQL92 Grammar Bruce Momjian 10:58
Re: iceberg queries Wei Weng 14:08
Re: iceberg queries Bruno Wolff III 15:50
Re: pg_views Jan Wieck 17:36
Re: iceberg queries Jan Wieck 18:06
Re: iceberg queries Tom Lane 18:37
Re: pg_views Tom Lane 18:46
Serialized Transaction Locking Issues justin 22:10
Re: iceberg queries Jan Wieck 23:14
Re: Serialized Transaction Locking Issues Tom Lane 23:21

Feb. 5, 2003

Thread Author Time
Inserting a tab character Luke Pascoe 03:39
Re: Inserting a tab character Matthew Horoschun 03:54
Re: Inserting a tab character Ludwig Lim 07:59
Lock timeout detection in postgres 7.3.1 Muhammad Shariq Muzaffar 08:51
bytea Adrian Chong 09:55
Re: bytea Christoph Haller 10:15
Re: bytea Adrian Chong 10:25
Postgresql To Oracle9i Atul Pedgaonkar 11:52
Re: bytea Christoph Haller 12:04
Problem with VACUUM Marcelo Pereira Tada 12:21
Re: Inserting a tab character Christoph Haller 14:07
automatic time/user stamp - rule or trigger? Neal Lindsay 14:47
Re: Problem with VACUUM Tom Lane 15:23
Re: Postgresql To Oracle9i Jan Wieck 18:24
design question: status table+log table, indexes, triggers george young 18:51
Re: automatic time/user stamp - rule or trigger? Jan Wieck 19:01
Re: design question: status table+log table, indexes, triggers Tom Lane 19:07
Re: automatic time/user stamp - rule or trigger? Neal Lindsay 19:33
Re: automatic time/user stamp - rule or trigger? Achilleus Mantzios 19:48
Re: automatic time/user stamp - rule or trigger? codeWarrior 23:38

Feb. 6, 2003

Thread Author Time
to_date has beaten me... Rodger Donaldson 04:02
Re: to_date has beaten me... Tom Lane 04:22
Re: to_date has beaten me... Rodger Donaldson 04:25
Re: to_date has beaten me... Roberto Mello 05:06
Re: to_date has beaten me... Rodger Donaldson 09:19
Re: Lock timeout detection in postgres 7.3.1 Christoph Haller 09:51
conversi ms-sql7 vs postgresql 7.3 betty 10:10
TIME vs. TIMESTAMP data type Ludwig Lim 11:04
Re: Lock timeout detection in postgres 7.3.1 Ludwig Lim 11:14
Re: TIME vs. TIMESTAMP data type Tomasz Myrta 11:33
get # of rows while doing SELECT with LIMIT at same time ? Sam Iam 12:01
Trigger para fazer log Maurício Sessue Otta 12:06
Re: TIME vs. TIMESTAMP data type Ludwig Lim 12:08
Re: Lock timeout detection in postgres 7.3.1 Christoph Haller 12:12
Re: TIME vs. TIMESTAMP data type Julian Scarfe 12:17
Re: Trigger para fazer log Tomasz Myrta 13:49
Re: Trigger para fazer log Roberto Mello 15:58
Re: Returning records from a function Lex Berezhny 18:57
changing referential integrety action on existing table Matthew Nuzum 19:25
Re: get # of rows while doing SELECT with LIMIT at same time ? Roberto Mello 19:27
Re: 7.2 functions that return multiple result sets? Chad Thompson 19:28
Re: changing referential integrety action on existing table Stephan Szabo 20:19
Re: numeric when compared to literal Tom Lane 20:29
Re: 7.2 functions that return multiple result sets? Ian Barwick 22:53
Re: Automatic casting Josh Berkus 23:02

Feb. 7, 2003

Thread Author Time
PostgreSQL 7.3.1 multiple schema select query error: java.sql.SQLException: ERROR: parser: parse error at or near "." waimeng 07:53
which will be faster? w/ or w/o indices val 08:04
"function has no parameter $1" - help. Michael Weaver 08:10
update column with rowtype betty 08:26
Re: "function has no parameter $1" - help. Christoph Haller 08:28
PostgreSQL 7.3.1 multiple schema select query error: java.sql.SQLException: ERROR: parser: parse error at or near "." waimeng 08:29
SET TIMEOUT equivalent / was: Lock timeout detection Christoph Haller 09:35
Re: which will be faster? w/ or w/o indices dev 09:36
Re: conversi ms-sql7 vs postgresql 7.3 Christoph Haller 09:59
efficient count/join query Gary Stainburn 10:07
Re: Lock timeout detection in postgres 7.3.1 Tomasz Myrta 10:29
Re: SET TIMEOUT equivalent / was: Lock timeout detection Tomasz Myrta 10:31
Re: efficient count/join query Tomasz Myrta 10:48
Re: Lock timeout detection in postgres 7.3.1 Christoph Haller 11:39
Re: conversi ms-sql7 vs postgresql 7.3 Richard Huxton 11:46
Re: automatic time/user stamp - rule or trigger? Achilleus Mantzios 12:00
Re: efficient count/join query Gary Stainburn 12:09
Re: efficient count/join query Gary Stainburn 12:57
Re: PostgreSQL 7.3.1 multiple schema select query error: Achilleus Mantzios 13:03
Re: efficient count/join query Tomasz Myrta 13:26
Re: efficient count/join query Richard Huxton 13:36
prosgrees + java + trasnacciones jose antonio leo 13:49
Re: efficient count/join query Gary Stainburn 14:21
Re: efficient count/join query Tomasz Myrta 14:38
Re: "function has no parameter $1" - help. Daniel Schuchardt 16:52
On delete cascade not working Alexander Stanier 17:07
Re: which will be faster? w/ or w/o indices Josh Berkus 17:26
Re: bytea Steve Crawford 18:54
[No subject] Ehmann, Mary 19:00
Start and End Day of a Week Luis Magaña 20:57
DATABASE EXAMPLES? Eduardo 20:58
Re: [SQL] Start and End Day of a Week Luis Magaña 23:52

Feb. 8, 2003

Thread Author Time
plpgsql + dblink() question Frankie 05:41
query help/sugestions John Cavacas 05:50
Re: plpgsql + dblink() question Joe Conway 06:03
Re: query help/sugestions Roberto Mello 06:35
Re: query help/sugestions John Cavacas 06:56
Re: query help/sugestions John Cavacas 07:33
Design question: How to convert a given data structure to sql and the opposite. Hanan Hotmail 16:23
Re: query help/sugestions Roberto Mello 16:38
Re: query help/sugestions John Cavacas 17:27
PL/Pgsql trigger function problem. James C. Ousley 17:35
referencing column names properly Sill-II, Stephen 23:34

Feb. 9, 2003

Thread Author Time
Re: query help/sugestions Roberto Mello 02:15
Re: referencing column names properly Bruno Wolff III 04:38
Re: referencing column names properly Ross J. Reedstrom 05:50
Re: referencing column names properly Sill-II, Stephen 14:18
order by date desc but NULLs last A.M. 22:29
Re: referencing column names properly Ross J. Reedstrom 22:56
Re: order by date desc but NULLs last Ross J. Reedstrom 23:12
Re: order by date desc but NULLs last Tomasz Myrta 23:12
Re: How to delete duplicate record Tomasz Myrta 23:17

Feb. 10, 2003

Thread Author Time
Re: How to delete duplicate record Tomasz Myrta 00:36
How to delete duplicate record Abdul Wahab Dahalan 01:48
Re: plpgsql + dblink() question Frankie Lam 03:39
Re: conversi ms-sql7 vs postgresql 7.3 betty 05:10
PostgreSQL SQL Conformance 📎 postgresql 07:06
Re: How to delete duplicate record Stephan Szabo 07:11
Re: plpgsql + dblink() question Frankie Lam 07:47
index strategies val 10:25
Re: How to delete duplicate record greg 14:44
Re: Referential Integrity Tom Lane 15:09
Re: Referential Integrity Stephan Szabo 15:54
Re: Referential Integrity Alexander Stanier 16:09
problems with date and interval queries. john 18:05
Re: problems with date and interval queries. Stephan Szabo 18:14
Re: problems with date and interval queries. Tom Lane 18:21
Re: order by date desc but NULLs last Jean-Luc Lachance 18:32
Re: order by date desc but NULLs last Ross J. Reedstrom 18:52
Re: problems with date and interval queries. Stephan Szabo 19:03
Re: conversi ms-sql7 vs postgresql 7.3 greg 21:04
Re: conversi ms-sql7 vs postgresql 7.3 Josh Berkus 21:40

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