pgsql-sql before 2003-02-20 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

Feb. 12, 2003

Thread Author Time
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
Re: convert from an integer to a date Frank Bax 21:43

Feb. 18, 2003

Thread Author Time
Re: Format Function Yudie 00:21
Re: DATABASE EXAMPLES? Will Trillich 03:19
Re: trigger after with cursor Christoph Haller 08:48
select from update from select? Dave Gomboc 08:57
How to make sequence skip existing key in table? Raymond Pau 10:01
" Adding missing FROM-clause entry for table .... " problem. Rajesh Kumar Mallah 10:04
Re: " Adding missing FROM-clause entry for table .... " problem. Christoph Haller 10:34
Re: " Adding missing FROM-clause entry for table .... " problem. Tomasz Myrta 10:43
Re: " Adding missing FROM-clause entry for table .... " problem. Tomasz Myrta 10:48
Re: trigger after with cursor betty 11:37
Re: " Adding missing FROM-clause entry for table .... " problem. Christoph Haller 11:51
Re: How to make sequence skip existing key in table? Bruno Wolff III 13:43
Re: " Adding missing FROM-clause entry for table .... " problem. Bruno Wolff III 14:12
Re: " Adding missing FROM-clause entry for table .... " problem. Tom Lane 15:40
Re: " Adding missing FROM-clause entry for table .... " problem. Tom Lane 15:50
Re: " Adding missing FROM-clause entry for table .... " problem. Jeff Eckermann 16:03
Re: " Adding missing FROM-clause entry for table .... " problem. Stephan Szabo 16:06
Re: Jeff Eckermann 16:07
Re: Trigger that will execute external program Hans-Jürgen Schönig 16:58
Re: How to make sequence skip existing key in table? Josh Berkus 17:07
Re: Drop temporary table only if it exists Jan Wieck 17:38
Rule Creates Duplicates retry Martin Davidsson 17:57
Re: Drop temporary table only if it exists Josh Berkus 18:28
Re: Trigger that will execute external program Jan Wieck 20:20
Re: trigger after with cursor Jeff Eckermann 20:21
Re: Drop temporary table only if it exists Jan Wieck 20:47
once again, sorting with Unicode JBJ 23:13

Feb. 19, 2003

Thread Author Time
point <-> polygon not supported? Scott Ding 00:12
Re: Drop temporary table only if it exists Josh Berkus 06:29
Re: Rule Creates Duplicates retry Tom Lane 07:39
Re: once again, sorting with Unicode Troy 10:49
Re: once again, sorting with Unicode Antti Haapala 12:37