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

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

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
PL/PGSQL TUTORIAL	Eduardo	23:53

Feb. 11, 2003

Thread	Author	Time
null foreign key column	Arunachalam Jaisankar	03:55
which type for primary key?	Rafal Kedziorski	09:16
Re: On delete cascade not working	Alexander Stanier	10:02
Re: which type for primary key?	Tomasz Myrta	10:55
Referential Integrity	Alexander Stanier	13:08
Problems with Transactions	Héctor Iturre	13:29
vacuum failure...	Michael Richards	15:01
Re: vacuum failure...	Tom Lane	15:43
PL/Pgsql trigger function issue..	James C. Ousley	15:49
Re: vacuum failure...	Michael Richards	16:27
Re: PL/Pgsql trigger function issue...	Peter Childs	16:31
Re: constrains questios ..	Johannes Lochmann	16:48
Re: constrains questios ..	Matthew Nuzum	17:41
Re: constrains questios ..	Johannes Lochmann	18:04
What's wrong with this identification configuration?	Wei Weng	21:26
anal about my syntax	James Cooper	22:26
What is wrong with this identification configuration?	Wei Weng	23:28
Working with very large datasets	Wilkinson Charlie E	23:42
adding not null constraints on columns	Susan	23:44

Feb. 12, 2003

Thread	Author	Time
Re: Working with very large datasets	Stephan Szabo	00:02
Re: Working with very large datasets	Lex Berezhny	00:33
Re: anal about my syntax	Josh Berkus	01:10
Re: What is wrong with this identification configuration?	Bruno Wolff III	01:45
Re: What is wrong with this identification configuration?	Wei Weng	02:45
Re: Lock timeout detection in postgres 7.3.1	Bruce Momjian	03:00
Re: What is wrong with this identification configuration?	Bruno Wolff III	03:46
Re: adding not null constraints on columns	Tom Lane	06:18
How to incorporate exec sql describe select list ( available in sql server in postgres)	Prashanth - Kamath	06:23
R: adding not null constraints on columns	Alessandro Pedrotti	07:49
timestamp	Daniel Jaenecke	08:46
Re: How to incorporate exec sql describe select list	Christoph Haller	08:54
timestamp	Daniel Jaenecke	09:09
Re: PL/Pgsql trigger function problem.	Christoph Haller	13:48
Re: Problems with Transactions	Christoph Haller	14:18
Sum of Intervals	Plant Thomas	14:37
Re: PL/Pgsql trigger function problem.	Jr.	14:59
Re: Sum of Intervals	Bruno Wolff III	15:37
Re: timestamp	Dmitry Tkach	17:55
How do you select from a table until a condition is met?	Nicholas Allen	18:10
Re: How do you select from a table until a condition is met?	Nicholas Allen	19:10
Re: How do you select from a table until a condition is met?	Bruno Wolff III	19:35
Re: How do you select from a table until a condition is met?	Nicholas Allen	19:55
Re: How do you select from a table until a condition is met?	Nicholas Allen	20:00
Re: How do you select from a table until a condition is met?	Bruno Wolff III	20:37
Re: How do you select from a table until a condition is met?	Dmitry Tkach	20:39
Re: null foreign key column	Bruno Wolff III	20:41
Re: timestamp	Larry Rosenman	20:45
Re: How do you select from a table until a condition is met?	Nicholas Allen	20:53
Re: How do you select from a table until a condition is met?	Dmitry Tkach	20:59
Re: Working with very large datasets	Wilkinson Charlie E	21:14
SQL Functions vs PL/PgSQL	Johnny Kristensen	21:51
Re: How do you select from a table until a condition is met?	Dmitry Tkach	22:04
Possible bug in Postgres? Followup to "How do you select from a table until a condition is met?"	Nicholas Allen	22:21
Re: null foreign key column	Dmitry Tkach	22:24
Re: null foreign key column	Vernon Wu	22:35
Re: How do you select from a table until a condition is met?	Dmitry Tkach	22:45
Re: null foreign key column	Wei Weng	23:03

Feb. 13, 2003

Thread	Author	Time
Re: null foreign key column	Dmitry Tkach	00:19
Re: anal about my syntax	Josh Berkus	00:59
dblink question please	Frankie Lam	01:52
Re: Possible bug in Postgres? Followup to "How do you select from a table until a condition is met?"	Bruno Wolff III	02:19
Re: dblink question please	Joe Conway	04:19
Re: dblink question please	Frankie Lam	04:32
Re: What's wrong with this identification configuration?	Tom Lane	05:22
Re: dblink question please	Joe Conway	05:22
Re: dblink question please	Frankie Lam	07:25
UNION or UNION ALL	Abdul Wahab Dahalan	08:52
Re: SQL Functions vs PL/PgSQL	Tomasz Myrta	09:21
Re: Possible bug in Postgres? Followup to "How do you select from a table until a condition is met?"	Nicholas Allen	09:40
Re: Possible bug in Postgres? Followup to "How do you select	Peter Childs	09:58
Re: Possible bug in Postgres? Followup to "How do you select	Nicholas Allen	10:04
Re: Possible bug in Postgres? Followup to "How do you select	Peter Childs	10:25
Debugging postmaster to fix possible bug in Postgres? Followup to "How do you select	Nicholas Allen	10:39
Table Pivot	V. Cekvenich	10:48
Re: UNION or UNION ALL	Tomasz Myrta	12:04
Re: dblink question please	Joe Conway	12:30
Re: Debugging postmaster to fix possible bug in Postgres? Followup to "How do you select	Tom Lane	15:17
Generating serial number column	Mintoo Lall	16:21
pg_restore fails when restoring a database view	piuschan	16:35
Re: Generating serial number column	Gary Stainburn	16:40
table Pivot	V. Cekvenich	16:45
Re: SQL Functions vs PL/PgSQL	Josh Berkus	17:02
Re: Debugging postmaster to fix possible bug in Postgres? Followup to "How do you select	Nicholas Allen	17:28
Re: SQL Functions vs PL/PgSQL	Roberto Mello	18:50
Re: Debugging postmaster to fix possible bug in Postgres?	Stephan Szabo	19:27
Re: Debugging postmaster to fix possible bug in Postgres? Followup to "How do you select	Manfred Koizar	19:39
Re: Debugging postmaster to fix possible bug in Postgres? Followup to "How do you select	Nicholas Allen	20:51
PL/PGSQL EDITOR	Eduardo	21:20
Extending Datatype	Wei Weng	21:54
Re: Debugging postmaster to fix possible bug in Postgres? Followup	Dmitry Tkach	22:50
postmaster -i & establishes three connections why?	Jeff Lu	23:00
Re: Debugging postmaster to fix possible bug in Postgres? Followup	Manfred Koizar	23:01
Re: Extending Datatype	Bruce Momjian	23:06
Re: Debugging postmaster to fix possible bug in Postgres? Followup	Tom Lane	23:48

Feb. 14, 2003

Thread	Author	Time
Re: SQL Functions vs PL/PgSQL	Tom Lane	00:06
Timezone conversion	Jeff Boes	01:04
Returning result sets.	Michael Weaver	01:44
Re: [SQL] Returning result sets.	Joe Conway	01:57
Re: dblink question please	Frankie Lam	02:59
Re: PL/PGSQL EDITOR	Frankie Lam	03:24
Re: PL/PGSQL EDITOR	Josh Berkus	03:49
Passing arrays	Michael Weaver	04:09
Re: [SQL] Passing arrays	Josh Berkus	04:14
rownum	chester c young	04:38
Re: rownum	Josh Berkus	04:56
Re: [SQL] Passing arrays	Stephan Szabo	04:57
Re: rownum	Tom Lane	05:20
Re: dblink question please	Joe Conway	05:51
Re: Extending Datatype	Wei Weng	05:52
Re: [SQL] Passing arrays	Michael Weaver	08:09
Re: PL/PGSQL EDITOR	Tomasz Myrta	08:33
Re: Passing arrays	David Durst	08:57
Re: SQL Functions vs PL/PgSQL	Johnny Kristensen	09:12
Re: Passing arrays	Michael Weaver	09:29
Re: Table Pivot	Christoph Haller	09:48
Re: rownum	Richard Huxton	10:10
Re: Table Pivot	Gary Stainburn	12:02
Re: [SQL] Passing arrays	Achilleus Mantzios	12:10
Re: sub-query optimization	Tomasz Myrta	12:24
Re: Extending Datatype	Bruce Momjian	12:38
Re: sub-query optimization	Tomasz Myrta	12:59
Re: Passing arrays 📎	Achilleus Mantzios	13:17
Drop temporary table only if it exists	Mintoo Lall	15:34
Re: Table Pivot	Joe Conway	15:35
Re: rownum	Joe Conway	15:42
Re: [SQL] Passing arrays	Joe Conway	15:48
Re: rownum	Tom Lane	16:21
Re: PL/PGSQL EDITOR	Tambet Matiisen	16:25
Re: Drop temporary table only if it exists	Josh Berkus	17:48
Re: Timezone conversion	Stephan Szabo	18:00
Re: Drop temporary table only if it exists	Mintoo Lall	18:12
sub-query optimization	Brad Hilton	18:22
Re: sub-query optimization	Brad Hilton	18:38
Re: Drop temporary table only if it exists	greg	18:41
Re: sub-query optimization	jasiek	19:21
Re: PL/PGSQL EDITOR	Johannes Lochmann	19:31
Re: sub-query optimization	Brad Hilton	19:42
Re: sub-query optimization	Stephan Szabo	20:04
Re: PL/PGSQL EDITOR	Eduardo	20:57
Re: Timezone conversion	Tom Lane	21:08
Re: postmaster -i & establishes three connections why?	Robert Treat	21:31
convert from an integer to a date	STashlitsky	21:33
Re: sub-query optimization	Tom Lane	22:08
Re: sub-query optimization	Brad Hilton	22:26
Re: sub-query optimization	Brad Hilton	22:39
[No subject]	George	23:43

Feb. 15, 2003

Thread	Author	Time
Re: sub-query optimization	Tomasz Myrta	01:52
Re: rownum	chester c young	04:54
Re: sub-query optimization	jasiek	08:45

Feb. 16, 2003

Thread	Author	Time
is current_timestamp unique for a transaction?	Alan Gutierrez	03:49
Re: is current_timestamp unique for a transaction?	Rod Taylor	04:24
Re: [SQL] is current_timestamp unique for a transaction?	Bruno Wolff III	04:28
select from update from select?	Dave Gomboc	12:16
Fwd: Re: Table Pivot	V. Cekvenich	16:51
Re: select from update from select?	Dima Tkach	17:07
Re: Table Pivot	Vic Cekvenich	17:12
Re: Table Pivot	Vic Cekvenich	17:14
Re: Trigger that will execute external program	Tomasz Myrta	23:18

Feb. 17, 2003

Thread	Author	Time
Re: Table Pivot	Joe Conway	04:02
trigger after with cursor	betty	04:57
Trigger that will execute external program	David Loh	06:16
Re: [SQL] is current_timestamp unique for a transaction?	Rajesh Kumar Mallah	07:10
Re: trigger after with cursor	betty	10:25
Special Date/Time Inputs	Tomasz Myrta	10:53
Re: Special Date/Time Inputs	A.Bhuvaneswaran	12:12
Re: Special Date/Time Inputs	Tomasz Myrta	12:17
Re: Special Date/Time Inputs	Tomasz Myrta	12:19
[No subject]	iafmgc	14:32
Re: rownum	Terry Yapt	16:25
Re: sub-query optimization	Brad Hilton	17:20
Re: sub-query optimization	Tomasz Myrta	18:11
Re: PL/PGSQL EDITOR	Josh Berkus	19:52
Re: convert from an integer to a date	Miquel van Smoorenburg	19:52
Returning multiple rows from plpgsql function	Mintoo Lall	20:07
Re: Returning multiple rows from plpgsql function	Stephan Szabo	20:18
Format Function	Yudie	20:56
Re: Format Function	Josh Berkus	20:56
Re:	Tomasz Myrta	21:01
Re: select from update from select?	Tambet Matiisen	21:22

Browse Archives

Prev | Next