pgsql-sql since 2003-08-22 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

Aug. 22, 2003

Thread Author Time
logging messages from inside pgPLSQL routine? Drew Wilson 00:21
Re: logging messages from inside pgPLSQL routine? Roberto Mello 01:21
Re: [SQL] "SELECT IN" Still Broken in 7.4b Christopher Kings-Lynne 01:40
date calculation MichaelHoeller 06:25
Re: Porting from PL/SQL to PLPGSQL denis 06:27
Re: "SELECT IN" Still Broken in 7.4b Bertrand Petit 06:32
Re: date calculation Tomasz Myrta 06:42
Joined deletes but one table being a subquery. Rajesh Kumar Mallah 10:01
Re: Joined deletes but one table being a subquery. Tomasz Myrta 10:23
Bug on parameter bigint in PL/PGSQL Michele Bendazzoli 11:59
Re: "SELECT IN" Still Broken in 7.4b Rod Taylor 12:36
Re: "SELECT IN" Still Broken in 7.4b Tom Lane 12:50
Re: date calculation Tom Lane 12:56
Re: Bug on parameter bigint in PL/PGSQL Stephan Szabo 13:00
Re: "SELECT IN" Still Broken in 7.4b Bertrand Petit 13:04
Re: Bug on parameter bigint in PL/PGSQL Richard Huxton 13:05
Re: Bug on parameter bigint in PL/PGSQL Michele Bendazzoli 14:24
Re: [SQL] "SELECT IN" Still Broken in 7.4b Shridhar Daithankar 15:11
Re: [SQL] "SELECT IN" Still Broken in 7.4b Greg Stark 15:28
Re: [SQL] "SELECT IN" Still Broken in 7.4b Stephan Szabo 15:47
composite type in a table floyds 19:32
Delete denied? Josh Berkus 23:24
Re: Delete denied? Josh Berkus 23:48
Re: Delete denied? Tom Lane 23:55

Aug. 23, 2003

Thread Author Time
Re: Delete denied? Stephan Szabo 01:22
Auto-update a field when record is changed Stuart 03:32
Re: Auto-update a field when record is changed Stephan Szabo 04:53
Re: Auto-update a field when record is changed Jamie Lawrence 05:16
Re: Joined deletes but one table being a subquery. Rajesh Kumar Mallah 09:30
Re: Delete denied? Jeff Eckermann 16:55

Aug. 24, 2003

Thread Author Time
Equality operators on NULL values Bertrand Petit 01:28
Re: Equality operators on NULL values Peter Eisentraut 08:43
Re: Which cursor-related warnings should be errors? Peter Eisentraut 21:10
Re: [SQL] "SELECT IN" Still Broken in 7.4b Tom Lane 21:37
Re: "SELECT IN" Still Broken in 7.4b Tom Lane 21:38

Aug. 25, 2003

Thread Author Time
Re: Joined deletes but one table being a subquery. Tomasz Myrta 05:59
Re: [ZODB-Dev] What are the ZopeDB limit? Michele Bendazzoli 07:12
Re: [ZODB-Dev] What are the ZopeDB limit? Michele Bendazzoli 07:16
Strange behavior with timestamptz George Weaver 18:18
Re: Strange behavior with timestamptz Tom Lane 20:59

Aug. 26, 2003

Thread Author Time
How to join from two tables at once? Joseph Shraibman 00:58
Re: Strange behavior with timestamptz George Weaver 02:51
Re: How to join from two tables at once? Stephan Szabo 03:12
Re: How to join from two tables at once? Ian Barwick 03:46
Re: postgres 7.1.3: why does the query plan ignore indexes? Bruce Momjian 04:17
Re: [ZODB-Dev] What are the ZopeDB limit? BenLaKnet 06:50
Re: [ZODB-Dev] What are the ZopeDB limit? Michele Bendazzoli 07:04
Restore deleted records Konstantin Petrenko 09:37
Re: Strange behavior with timestamptz George Weaver 12:28
Re: Strange behavior with timestamptz Tom Lane 13:08
Re: postgres 7.1.3: why does the query plan ignore indexes? Tom Lane 13:09
One-2-many relation - need distinct counts PS PS 13:54
Eliminating duplicate lists Richard Huxton 17:30
Fetch the required rows 📎 shyamperi 17:45
Re: Fetch the required rows Bruno Wolff III 18:13
regarding the same in db2 - fetch tuples 📎 shyamperi 18:44
Re: Restore deleted records CoL 20:02
smallint with postgresql Alessandro Depetro 23:22
smallint with postgresql Alessandro Depetro 23:24
smallfloat with postgresql Alessandro Depetro 23:31
Re: postgres 7.1.3: why does the query plan ignore indexes? Gaetano Mendola 23:32

Aug. 27, 2003

Thread Author Time
Re: postgres 7.1.3: why does the query plan ignore indexes? Bruce Momjian 04:22
Re: postgres 7.1.3: why does the query plan ignore indexes? Tom Lane 04:27
How to return a record set from function. Kumar 07:18
Canceling other backend's query daq 09:12
[OT?]*_fsm_* parameters in postgresql.conf: which versions supports them? Marco Vezzoli 11:47
Re: Restore deleted records Bruno Wolff III 12:36
script to create a sample database Popeanga Marian 13:04
Re: How to return a record set from function. Richard Huxton 13:50
Re: Canceling other backend's query Bruce Momjian 14:46
Re: How to return a record set from function. Stephan Szabo 15:11
Q: Multicolumn lookup, Join or Sub-query ? Richard A. DeVenezia 15:30
Re: Canceling other backend's query scott.marlowe 15:31
length of array Chris Faulkner 19:49
Re: One-2-many relation - need distinct counts Richard Huxton 19:51

Aug. 28, 2003

Thread Author Time
Re: length of array Joe Conway 00:40
Re: How to optimize this query ? ProgHome 01:01
Re: How to return a record set from function. Joe Conway 01:02
Re: How to optimize this query ? Stephan Szabo 01:18
Re: [OT?]*_fsm_* parameters in postgresql.conf: which versions supports them? Bruno Wolff III 03:19
Re: smallfloat with postgresql Bruno Wolff III 03:42
lock row in table Daniel Michał 08:23
Re: lock row in table Yudha Setiawan 10:42
Re: lock row in table Daniel 12:14
interval conversion Brett Dikeman 13:23
Re: lock row in table Tom Lane 13:38
Re: length of array Chris Faulkner 14:37
Re: interval conversion Tomasz Myrta 14:40
Re: interval conversion Brett Dikeman 15:45
Re: length of array Joe Conway 21:27
BEFORE UPDATE Triggers Chris Anderson 21:48
Forcing a trigger to run Michael A Nachbaur 22:47
Re: How to join from two tables at once? Joseph Shraibman 23:52

Aug. 29, 2003

Thread Author Time
Migrating Stored Procedures from MS SQL Server Kumar 05:24
Re: Migrating Stored Procedures from MS SQL Server David Witham 05:31
Unique constraints for a list Anuradha Ratnaweera 05:50
Re: [SQL] Unique constraints for a list Richard Huxton 08:52
Select Match on PostgreSQL. 📎 Laurent Patureau 10:41
Re: Select Match on PostgreSQL. Oleg Bartunov 12:29

Aug. 30, 2003

Thread Author Time
Re: BEFORE UPDATE Triggers Jan Wieck 02:50
Getting the return type right for SETOF Dan Langille 20:42
Re: Getting the return type right for SETOF Stephan Szabo 20:59
Re: BEFORE UPDATE Triggers Tom Lane 21:56

Aug. 31, 2003

Thread Author Time
Re: Getting the return type right for SETOF Dan Langille 01:16

Sept. 1, 2003

Thread Author Time
Re: BEFORE UPDATE Triggers Jan Wieck 02:12
MINUS & ROWNUM in PostGres Jomon Skariah 13:47
session variable sad 14:11
Re: session variable Bruce Momjian 16:57
Re: disabling triggers weigelt 17:57
Trigger functions w/o pgsql ? weigelt 18:10
Re: disabling triggers chester c young 20:35
running aggregates Glenn 20:46
Re: Trigger functions w/o pgsql ? Peter Eisentraut 22:00

Sept. 2, 2003

Thread Author Time
Re: session variable Bupp Phillips 01:28
unsubscribe Rute Solipa 08:29
Unnamed Cursor return Kumar 09:01
Change column data type Senthil Kumar S 09:50
Fw: Change column data type Kumar 10:57
Re: session variable sad 12:29
Re: session variable Andreas Pflug 12:40
Re: [BUGS] session variable sad 13:13
Re: Unnamed Cursor return Tom Lane 14:05
Re: session variable Andreas Pflug 22:51

Sept. 3, 2003

Thread Author Time
Like phrase Michał Wróblewski (Muerte) 08:17
Re: Like phrase Tomasz Myrta 08:51
Re: [BUGS] session variable Peter Eisentraut 17:40
unsubscribe Antony Gubert 17:46
Re: session variable Bruce Momjian 17:55
Re: [BUGS] session variable Bruce Momjian 20:42

Sept. 4, 2003

Thread Author Time
Help me 📎 Yaroslav Ulyanov 07:46
pg_type and type names sad 10:56
Re: Fw: Change column data type scott.marlowe 15:16
Re: MINUS & ROWNUM in PostGres Rod Taylor 19:50
Re: running aggregates Tomasz Myrta 19:56
Re: Help me George Weaver 20:48

Sept. 5, 2003

Thread Author Time
Porting from Oracl to Postgres Jomon Skariah 04:24
Re: Help me Yaroslav Ulyanov 06:57
Transactions ID Yaroslav Ulyanov 07:01
Fw: Transactions ID Yaroslav Ulyanov 07:10
Re: Change column data type Richard Huxton 08:15
Re: Fw: Transactions ID Richard Huxton 08:17
Re: Porting from Oracl to Postgres Rod Taylor 13:57
Re: Porting from Oracl to Postgres Richard Huxton 14:12
Re: Porting from Oracl to Postgres Jeff Eckermann 14:29
recursive sql floyds 17:41

Sept. 6, 2003

Thread Author Time
Name the Parameters Kumar 04:42
Re: recursive sql sad 05:05
Re: Name the Parameters Ian Barwick 05:21
SQL subqueries newbie help Alexei Chetroi 11:07
Re: SQL subqueries newbie help Bruno Wolff III 15:41
Re: SQL subqueries newbie help Rod Taylor 17:21

Sept. 7, 2003

Thread Author Time
Re: recursive sql (using the sort_key method) Mark Stosberg 00:38
Re: SQL subqueries newbie help Alexei Chetroi 11:42
Re: SQL subqueries newbie help Rod Taylor 13:09
Re: SQL subqueries newbie help Alexei Chetroi 14:19
Re: SQL subqueries newbie help Tom Lane 14:22

Sept. 8, 2003

Thread Author Time
Re: MINUS & ROWNUM in PostGres Kris Jurka 08:21
plPGSQL bug in function creation Marek Lewczuk 08:32
Re: [GENERAL] plPGSQL bug in function creation Richard Huxton 12:09
Re: [SQL] [GENERAL] plPGSQL bug in function creation George Weaver 12:41
Re: MINUS & ROWNUM in PostGres Jomon Skariah 13:44
Re: MINUS & ROWNUM in PostGres Rod Taylor 14:11
Re: [GENERAL] plPGSQL bug in function creation Dennis Gearon 14:15
Re: [SQL] plPGSQL bug in function creation Tom Lane 14:19
plpgsql doesn't coerce boolean expressions to boolean Tom Lane 15:40
Re: [HACKERS] plpgsql doesn't coerce boolean expressions to boolean Andrew Dunstan 16:10
Re: plpgsql doesn't coerce boolean expressions to boolean Andreas Pflug 16:20
Re: plpgsql doesn't coerce boolean expressions to boolean Doug McNaught 16:35
Re: plpgsql doesn't coerce boolean expressions to boolean Tom Lane 16:47
Re: plpgsql doesn't coerce boolean expressions to boolean Doug McNaught 16:56
Re: plpgsql doesn't coerce boolean expressions to boolean Andreas Pflug 16:57
Re: plpgsql doesn't coerce boolean expressions to boolean Andrew Dunstan 18:27
Re: plpgsql doesn't coerce boolean expressions to boolean Tom Lane 20:28
undefine currval() Chris Gamache 21:12
Re: plpgsql doesn't coerce boolean expressions to boolean Andrew Dunstan 21:31
Re: undefine currval() Tom Lane 21:33
Re: undefine currval() Bruce Momjian 22:41
Re: undefine currval() scott.marlowe 23:03
Re: undefine currval() Tom Lane 23:35

Sept. 9, 2003

Thread Author Time
Re: MINUS & ROWNUM in PostGres Jomon Skariah 04:14
Re: plpgsql doesn't coerce boolean expressions to boolean R. van Twisk 06:43
Re: Conversion from Sybase ASA Viorel Dragomir 07:06
Conversion from Sybase ASA Richard Sydney-Smith 07:06
Re: Conversion from Sybase ASA Ian Barwick 07:17
How can I optimize this query Jainendra Kumar P 08:09
Re: undefine currval() Achilleus Mantzios 12:07
Re: MINUS & ROWNUM in PostGres Rod Taylor 12:19
Re: undefine currval() scott.marlowe 13:13
Re: plpgsql doesn't coerce boolean expressions to boolean Manfred Koizar 14:56
Re: plpgsql doesn't coerce boolean expressions to boolean Richard Hall 15:27
Re: plpgsql doesn't coerce boolean expressions to boolean Tom Lane 15:54
Re: [HACKERS] plpgsql doesn't coerce boolean expressions to boolean Jan Wieck 17:14
Re: [HACKERS] plpgsql doesn't coerce boolean expressions to boolean Tom Lane 17:32
contrib/ltree floyds 17:45
Re: plpgsql doesn't coerce boolean expressions to boolean Andrew Dunstan 17:51
Re: [HACKERS] plpgsql doesn't coerce boolean expressions to boolean Bruce Momjian 17:57
Test, please ignore Roberto João Lopes Garcia 21:56

Sept. 10, 2003

Thread Author Time
Re: contrib/ltree Barry Lind 00:27
Re: [HACKERS] plpgsql doesn't coerce boolean expressions to boolean Jan Wieck 01:56
Re: How can I optimize this query Bruno Wolff III 03:17

Browse Archives

Prev | Next