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

Discussion for users on SQL related matters.

Search the Archives

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

Browse Archives

Prev | Next

Jan. 28, 2003

Thread Author Time
Cross-table constraints Rodger Donaldson 07:05
converting microsoft sql server 2000 sql-code for postgresql 7.2.1 william windels 10:08
Re: converting microsoft sql server 2000 sql-code for postgresql 7.2.1 Geraint Jones 10:27
Re: converting microsoft sql server 2000 sql-code for postgresql Bhuvan A 11:16
subselect return in where clause Michael Hostbaek 11:21
Re: converting microsoft sql server 2000 sql-code for postgresql 7.2.1 Rajesh Kumar Mallah. 11:58
import error Oliver Vecernik 13:26
Re: CR/LF conversion (was: import error) Oliver Vecernik 14:08
CSV import Oliver Vecernik 14:46
Re: import error Tom Lane 15:28
Re: CR/LF conversion (was: import error) Tom Lane 15:32
double linked list Juergen 15:44
Re: subselect return in where clause Tom Lane 15:56
Re: double linked list DA Morgan 16:45
Re: import error Achilleus Mantzios 17:43
Re: import error Achilleus Mantzios 17:47
Re: CR/LF conversion (was: import error) Achilleus Mantzios 18:20
Re: CSV import Achilleus Mantzios 19:01
Cross-database references Pedro Igor Craveiro e Silva 19:30
Problem with query Ricardo Javier Aranibar León 21:00
Re: converting microsoft sql server 2000 sql-code for postgresql Guy Fraser 21:58
Re: CSV import Guy Fraser 22:13
Re: converting microsoft sql server 2000 sql-code for postgresql 7.2.1 Jeff Eckermann 22:36
Re: Cross-database references Jason Turner 22:37
Re: CSV import Jeff Eckermann 22:45
Re: double linked list --CELKO-- 23:54

Jan. 29, 2003

Thread Author Time
LONG - Question on dealing w/ numerics David Durst 00:54
Re: Cross-database references Roberto Mello 01:28
Re: CSV import Jean-Luc Lachance 01:50
Re: converting microsoft sql server 2000 sql-code for postgresql Tom Lane 01:55
Re: Problem with query Tom Lane 02:18
Re: Problem with query Josh Berkus 02:45
Re: LONG - Question on dealing w/ numerics Josh Berkus 02:50
Re: LONG - Question on dealing w/ numerics Josh Berkus 02:54
Re: CSV import Rodger Donaldson 03:13
Re: LONG - Question on dealing w/ numerics Tom Lane 04:08
extracting constraints from schema Agnieszka Rutkowska 04:25
Re: converting microsoft sql server 2000 sql-code for postgresql Wei Weng 04:39
Re: CSV import Oliver Vecernik 05:50
Re: Cross-table constraints Stephan Szabo 06:03
Re: Cross-table constraints Rodger Donaldson 06:11
Re: Cross-table constraints Stephan Szabo 06:13
Re: Creating tables from within functions Stephan Szabo 06:44
USING INDEX Abdul Wahab Dahalan 07:27
COPY use in function with variable file name Sondaar Roelof 08:05
Re: Creating tables from within functions Sondaar Roelof 08:16
Re: Filter function Tom Lane 08:25
Re: Cross-table constraints Bruno Wolff III 08:28
Re: converting microsoft sql server 2000 sql-code for postgresql Bruno Wolff III 08:31
Re: LONG - Question on dealing w/ numerics Tom Lane 09:01
Re: LONG - Question on dealing w/ numerics David Durst 09:17
plpgsql: return results of a dynamic query Moritz Lennert 09:21
Re: CSV import Gary Stainburn 10:04
returning table from a function Seethalakshmi VB 10:52
Re: double linked list Juergen 12:12
Re: plpgsql: return results of a dynamic query Christoph Haller 13:00
Re: Please include hier-patch in next PostgreSQL version Rod Taylor 13:17
Re: plpgsql: return results of a dynamic query Moritz Lennert 13:24
help: triggers Tony Simbine 13:29
Re: double linked list Jan Hidders 13:48
Re: help: triggers Wei Weng 15:55
Inheritence and Integrity Neal Lindsay 19:56
Re: Inheritence and Integrity Stephan Szabo 20:19
Re: Inheritence and Integrity Neal Lindsay 20:39
Re: Inheritence and Integrity Stephan Szabo 20:49
Re: double linked list --CELKO-- 21:15
Re: double linked list Ryan 21:30

Jan. 30, 2003

Thread Author Time
Re: Inheritence and Integrity chester c young 06:27
Re: help: triggers Tony Simbine 08:20
Re: Filter function Evgen Potemkin 08:27
Question about passing User defined types to functions David Durst 10:18
Delete 1 Record of 2 Duplicate Records val 11:52
Re: double linked list Christoph Haller 13:10
Re: double linked list Christoph Haller 14:26
Re: double linked list Alan Gutierrez 14:30
Function executing twice Thiago Conti 14:54
Re: Filter function Tom Lane 14:56
Re: Delete 1 Record of 2 Duplicate Records greg 15:04
Re: Function executing twice Tambet Matiisen 15:15
Re: Question about passing User defined types to functions Christoph Haller 15:29
Re: Question about passing User defined types to functions Tom Lane 15:39
calculated expressions and index use Pavel Hlavnicka 15:54
Re: Delete 1 Record of 2 Duplicate Records Achilleus Mantzios 16:00
Re: calculated expressions and index use Arjen van der Meijden 16:13
Re: calculated expressions and index use Tom Lane 16:51
Re: double linked list --CELKO-- 19:13
Converting clarion Nasair Junior da Silva 20:36
Re: CSV import Chad Thompson 20:48
Re: CSV import Oliver Vecernik 22:31
Re: Converting clarion Oliver Vecernik 22:38

Jan. 31, 2003

Thread Author Time
How to rename and drop a column in pg7.3? Vernon Wu 01:15
Re: Delete 1 Record of 2 Duplicate Records Tom Lane 01:16
FW: Converting clarion Michael Weaver 02:19
Re: How to rename and drop a column in pg7.3? mallah 02:58
Re: checking data integrity in a recursive table Bruce Momjian 05:32
design review, FreshPorts change Dan Langille 05:33
how can i convert a substring to a date? joe.guyot 07:03
Re: calculated expressions and index use Pavel Hlavnicka 08:44
Postgres MD5 Function David Durst 09:34
Index File growing big. PRAGATI SAVAIKAR 11:29
Controlling access to Sequences Matthew Horoschun 12:47
Server access thru webmin Huub 14:42
Re: calculated expressions and index use Tom Lane 14:56
Re: CSV import Jean-Luc Lachance 15:27
how do i create a date from a substring??? joe.guyot 15:40
Re: calculated expressions and index use Pavel Hlavnicka 16:03
Which version is this? Wei Weng 16:43
Help with a query for charting Andrew Veitch 17:55
Re: Postgres MD5 Function Larry Rosenman 18:14
Re: Postgres MD5 Function Joe Conway 19:32
For each record in SELECT Luis Magaña 21:21

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

Browse Archives

Prev | Next