pgsql-sql since 2002-12-13 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

Dec. 13, 2002

Thread Author Time
Re: function replace doesnt exist Rajesh Kumar Mallah. 10:56
Re: Stored Procedure Problem Rajesh Kumar Mallah. 11:01
order by and limit with multi-column index, bug? Harald Krake 14:34
Re: order by and limit with multi-column index, bug? Jakub Ouhrabka 14:47
Re: order by and limit with multi-column index, bug? Harald Krake 14:52
server terminated by a query in 7.3 Jie Liang 17:29
UPDATE comparing dates and non-dates data javier garcia 17:43
Re: server terminated by a query in 7.3 Frank van Vugt 17:47
A PL/PgSQL Question Ludwig Lim 17:50
Re: server terminated by a query in 7.3 Tom Lane 18:12
A Costly function + LIMIT Chris Gamache 18:14
Re: A Costly function + LIMIT Tom Lane 18:20
Re: server terminated by a query in 7.3 Jie Liang 18:33
Re: A PL/PgSQL Question Josh Berkus 19:41
Re: UPDATE comparing dates and non-dates data Josh Berkus 20:56
Re: UPDATE comparing dates and non-dates data Bret Hughes 21:32

Dec. 16, 2002

Thread Author Time
Re: ON DELETE CASCADE Tim Perdue 02:29
working around setQuerySnapshot limitations in functions Robert Treat 16:23
CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER Ludwig Lim 16:41
Re: CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER Michael Paesold 16:56
UPDATE with a SELECT and subSELECT(About comparing dates and non dates data) javier garcia 18:57

Dec. 17, 2002

Thread Author Time
Re: working around setQuerySnapshot limitations in functions Jakub Ouhrabka 00:12
Re: UPDATE with a SELECT and subSELECT(About comparing dates and non dates data) Christoph Haller 09:34
join and dynamic view Gary Stainburn 10:58
Re: join and dynamic view Christoph Haller 12:06
Re: join and dynamic view Gary Stainburn 12:23
Re: join and dynamic view Christoph Haller 13:06
Re: join and dynamic view Gary Stainburn 13:09
Re: join and dynamic view Tomasz Myrta 13:36
Re: join and dynamic view Christoph Haller 13:45
Re: join and dynamic view Gary Stainburn 14:11
Re: join and dynamic view Tomasz Myrta 14:12
Re: join and dynamic view Christoph Haller 14:15
Re: join and dynamic view Tomasz Myrta 14:31
Upgrade question - was Re: join and dynamic view Gary Stainburn 14:57
Re: Upgrade question - was Re: join and dynamic view Christoph Haller 15:09
Re: Upgrade question - was Re: join and dynamic view Andreas Joseph Krogh 15:23
handling error in a function Peter Gabriel 19:42

Dec. 18, 2002

Thread Author Time
pl/pgsql question Tim Perdue 04:12
Re: pl/pgsql question Tom Lane 04:26
Re: pl/pgsql question Ludwig Lim 04:29
Postgres V/S Oracle Prashanth - Kamath 04:50
Re: Postgres V/S Oracle Josh Berkus 05:17
Dynamic sql program using libpq Prashanth - Kamath 06:04
Re: handling error in a function Christoph Haller 09:04
Re: handling error in a function Tomasz Myrta 10:07
Re: Dynamic sql program using libpq 📎 Christoph Haller 10:21
Re: pl/pgsql question Tim Perdue 14:02
Error code for database down dnaren 15:52
references table(multiple columns go here) Gary Stainburn 16:25
Re: pl/pgsql question Josh Berkus 16:30
Re: pl/pgsql question Tim Perdue 16:44
Re: references table(multiple columns go here) Tomasz Myrta 16:46
Re: references table(multiple columns go here) Gary Stainburn 16:56
unsubscribe Kristopher Yates 17:07
Re: references table(multiple columns go here) Gary Stainburn 17:18
Re: references table(multiple columns go here) Tom Lane 17:50
Re: references table(multiple columns go here) Tomasz Myrta 18:17

Dec. 19, 2002

Thread Author Time
Re: references table(multiple columns go here) Gary Stainburn 09:28
Re: references table(multiple columns go here) Tomasz Myrta 09:58
Re: references table(multiple columns go here) Gary Stainburn 10:30
Re: references table(multiple columns go here) Tomasz Myrta 11:30
Re: references table(multiple columns go here) Gary Stainburn 11:37
unsubscribe david williams 12:32
Re: unsubscribe Christoph Haller 12:39
Re: unsubscribe Robert Treat 14:47
Re: references table(multiple columns go here) Tom Lane 15:17
Re: references table(multiple columns go here) Gary Stainburn 15:22
Perform a Select on an Oracle Database from PG val 15:37
Re: Perform a Select on an Oracle Database from PG Roberto Mello 16:05
Re: UPDATE with a SELECT and subSELECT(About comparing dates and non dates data) javier garcia 16:16

Dec. 20, 2002

Thread Author Time
Help on (sub)-select Gary Stainburn 10:21
Re: UPDATE with a SELECT and subSELECT(About comparing dates and non dates data) Christoph Haller 10:22
Re: Help on (sub)-select Philip Warner 10:51
Re: Help on (sub)-select Gary Stainburn 11:48
Re: Help on (sub)-select Philip Warner 15:53
SQL select count(*) from "myTable" failed : Relation "mytable" does not exist Jeff Kowalczyk 19:36
Need help paging through record sets cmccormick 20:53
Re: Need help paging through record sets Steve Crawford 23:01

Dec. 21, 2002

Thread Author Time
Re: Need help paging through record sets Peter Galbavy 11:57
Re: Need help paging through record sets knut.suebert 18:32
Parameterized Views on 7.3 Terry Yapt 19:12

Dec. 22, 2002

Thread Author Time
Re: Password user postgres Tomasz Myrta 07:48
Re: create index on function - why? Philip Warner 10:18
Re: Password user postgres Mathieu Arnold 15:09
Re: Password user postgres Oliver Elphick 23:27

Dec. 23, 2002

Thread Author Time
save data from views 10:57
Re: save data from views 11:48
Password user postgres Arnaudo Massimo 14:22
Re: save data from views Achilleus Mantzios 15:09
DB2 to Postgresql conversion help. John Pauley 16:32
Re: DB2 to Postgresql conversion help. Joe Conway 17:13

Dec. 24, 2002

Thread Author Time
corresponding primary key for max(column)? Jason Pyeron 00:12
COPY command problems Nikola Ivacic 10:23
Re: COPY command problems Tom Lane 15:24
Re: COPY command problems Nikola Ivacic 15:55

Dec. 25, 2002

Thread Author Time
Re: Password user postgres Bhuvan A 09:03
Re: Password user postgres Arnaudo Massimo 19:05

Dec. 26, 2002

Thread Author Time
CREATE INDEX question Hans-Jürgen Schönig 12:24
Execution Plans and Casts Hans-Jürgen Schönig 12:49

Dec. 27, 2002

Thread Author Time
How can I use cursor in a trigger or function? dailiming 08:29
Re: COPY command problems Rajesh Kumar Mallah. 11:17
Reference integrity question Evgen Potemkin 13:32
Re: Stuck on SQL Query where a calculated value is used for a join. ScottRArndt 13:57

Dec. 28, 2002

Thread Author Time
COPY fails but INSERT works Gary Stainburn 15:13
Re: COPY fails but INSERT works Stephan Szabo 15:48
Re: COPY fails but INSERT works Gary Stainburn 17:23

Dec. 29, 2002

Thread Author Time
Multiple counts Colin Fox 04:55

Dec. 30, 2002

Thread Author Time
Doubts porting from Oracle to postgresql Senthil 08:22
batch example Campano, Troy 16:22
unsubscribe jrJAMES 17:09
unsubscribe Rajesh Krishnamoorthy 17:21
Re: batch example Thorsten Meinl 17:28
empty arrays floyds 17:40

Dec. 31, 2002

Thread Author Time
Slow self-join on a 100 million record table Mark Davies 15:46
plpgsql select into question J D 15:49
Re: Slow self-join on a 100 million record table Andrew J. Kelly 16:04
Re: plpgsql select into question Jie Liang 19:09

Jan. 1, 2003

Thread Author Time
Re: pg_dump problem Tomasz Myrta 11:34
Re: Implementing automatic updating of primary keys... Tomasz Myrta 12:41
Internal functions documented Daniel Bruce Lynes 21:54

Jan. 2, 2003

Thread Author Time
Re: Slow self-join on a 100 million record table Paul Thornett 03:30
bug? Minghann Ho 04:36
Re: empty arrays Tom Lane 06:04
Re: Slow self-join on a 100 million record table Tom Lane 06:06
Re: bug? Tom Lane 06:16
Re: Reference integrity question Stephan Szabo 09:42
PostgreSQL X Resin EE Pedro Igor 13:16
Re: empty arrays Steve Crawford 19:06
Adding a Primary Key to an exisiting table Maly Kaing 21:15
NULLL comparison in multiple column unique index Brian Walker 23:19

Jan. 3, 2003

Thread Author Time
Re: Adding a Primary Key to an exisiting table Bhuvan A 05:20
Re: NULLL comparison in multiple column unique index Manfred Koizar 13:10
Query Pedro Igor 13:46
Re: Query Stephan Szabo 15:57
Compiling pl/pgsql functions? Daniel Bruce Lynes 17:27

Jan. 4, 2003

Thread Author Time
SQL to determine Tablenames, Primarykeys & Foreignkeys] Kevin Gordon 03:57
Re: Reference integrity question Stephan Szabo 15:16

Jan. 5, 2003

Thread Author Time
Deleting in order from a table pginfo 09:26
weighting (the results of) a query ? Peter Galbavy 10:41
Re: Deleting in order from a table Ludwig Lim 12:18

Jan. 6, 2003

Thread Author Time
Grant execute on functions; related objects permissions ? Cédric Dufour (public) 10:12
Re: Grant execute on functions; related objects permissions ? Tambet Matiisen 10:45
order by and aggregate Tomasz Myrta 12:44
Re: order by and aggregate Richard Huxton 13:41
Re: Grant execute on functions; related objects permissions ? Bruno Wolff III 13:50
Re: order by and aggregate Tomasz Myrta 14:09
Sorry, to many clients already cristi 14:12
Re: order by and aggregate dev 15:59
Re: order by and aggregate Tom Lane 16:34
Re: order by and aggregate Tomasz Myrta 16:35
Re: order by and aggregate Tom Lane 16:36
Re: order by and aggregate Tomasz Myrta 16:59
Re: order by and aggregate Tomasz Myrta 17:07
sub-select, view and sum() Gary Stainburn 17:29
Re: Sorry, to many clients already Robert Treat 18:20
Re: sub-select, view and sum() Stephan Szabo 18:31
Re: sub-select, view and sum() Gary Stainburn 22:29

Jan. 7, 2003

Thread Author Time
to_date confusion Richard Rowell 03:58
Re: Sorry, to many clients already Tambet Matiisen 08:46
SQL list table names alviN 10:46
Re: SQL list table names Adam Witney 11:03
Inherancing Nasair Junior da Silva 11:42
Re: [SQL] 7.3.1 index use / performance Tomasz Myrta 12:00
Re: Inherancing Adam Witney 12:02
Re: Inherancing Nasair Junior da Silva 12:09
Re: Inherancing Adam Witney 12:21
A problem about alter table jack 12:53
Re: A problem about alter table Tomasz Myrta 13:31
Re: A problem about alter table jack 14:06
Re: A problem about alter table Tomasz Myrta 14:29
insert rule doesn't see id field Ron Peterson 14:54
Re: insert rule doesn't see id field Ron Peterson 14:57
Re: A problem about alter table Jeff Eckermann 15:07
Re: [PERFORM] 7.3.1 index use / performance Stephan Szabo 15:27
7.3.1 index use / performance Achilleus Mantzios 15:39
Re: insert rule doesn't see id field Tom Lane 16:01
Re: weighting (the results of) a query ? Peter Galbavy 16:04
Re: weighting (the results of) a query ? Tom Lane 16:14
Re: [SQL] 7.3.1 index use / performance Achilleus Mantzios 16:21
Re: weighting (the results of) a query ? Peter Galbavy 16:25
Re: [SQL] [PERFORM] 7.3.1 index use / performance Tom Lane 16:29
Re: weighting (the results of) a query ? Tom Lane 16:34
Re: weighting (the results of) a query ? Peter Galbavy 16:45
Re: Inherancing Daniel Schuchardt 17:16
Re: [SQL] [PERFORM] 7.3.1 index use / performance Tom Lane 17:44
Re: 7.3.1 function problem: ERROR: cache lookup failed for type 0 Tom Lane 18:22
Re: 7.3.1 function problem: ERROR: cache lookup failed Joe Conway 18:39
Re: [SQL] [PERFORM] 7.3.1 index use / performance Tom Lane 18:39
Re: A problem about alter table Achilleus Mantzios 18:41
Re: [SQL] 7.3.1 index use / performance Rod Taylor 18:45
Re: [SQL] [PERFORM] 7.3.1 index use / performance Tom Lane 19:26
Re: [SQL] [PERFORM] 7.3.1 index use / performance 📎 Achilleus Mantzios 20:27
Re: [SQL] [PERFORM] 7.3.1 index use / performance 📎 Achilleus Mantzios 21:05
7.3.1 function problem: ERROR: cache lookup failed for type 0 Achilleus Mantzios 21:55
Re: 7.3.1 function problem: ERROR: cache lookup failed Achilleus Mantzios 22:32
Re: [SQL] [PERFORM] 7.3.1 index use / performance Achilleus Mantzios 22:38
Re: [SQL] [PERFORM] 7.3.1 index use / performance Achilleus Mantzios 22:51
double precision to numeric overflow error Thomas O'Connell 23:12
Re: [SQL] double precision to numeric overflow error Stephan Szabo 23:36

Browse Archives

Prev | Next