pgsql-sql since 2003-08-18 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. 18, 2003

Thread Author Time
Reverse pattern match. Moonstruck 07:05
Re: Reverse pattern match. Rod Taylor 23:05
Re: Reverse pattern match. Josh Berkus 23:11

Aug. 19, 2003

Thread Author Time
Inheritance or no inheritance, there is a question Vernon Smith 03:59
Re: Inheritance or no inheritance, there is a question Josh Berkus 04:36
Re: Changing data type must recreate all views? Peter Eisentraut 07:53
Configuring Problem on Solaris............ Chidananda 08:32
postgres 7.1.3: why does the query plan ignore indexes? Marco Vezzoli 08:43
Migration from db2 to postgres' 📎 shyamperi 10:52
link toward pgsql-sql is missing on the left menu at http://archives.postgresql.org/ Richard NAGY 12:26
Re: Migration from db2 to postgres' Tim Andersen 12:43
Query problem Rado Petrik 13:02
Re: postgres 7.1.3: why does the query plan ignore indexes? Tom Lane 13:26
Re: postgres 7.1.3: why does the query plan ignore indexes? Marco Vezzoli 13:41
Re: Query problem Richard Huxton 14:21
Re: Query problem Bruno Wolff III 15:50

Aug. 20, 2003

Thread Author Time
Re: Inheritance or no inheritance, there is a question Josh Berkus 00:12
Re: Reverse pattern match. Moonstruck 06:42
Re: Wicked screensaver zakkr 06:57
Porting from PL/SQL to PLPGSQL Jomon Skariah 09:45
Re: Inheritance or no inheritance, there is a question David Fetter 15:11
Re: "SELECT IN" Still Broken in 7.4b Stephan Szabo 16:27
Re: "SELECT IN" Still Broken in 7.4b Mike Winter 16:45
Re: "SELECT IN" Still Broken in 7.4b Rod Taylor 17:09
Re: "SELECT IN" Still Broken in 7.4b Rod Taylor 17:10
Before/After Trigger User Switching Aasmund Midttun Godal 17:12
Re: "SELECT IN" Still Broken in 7.4b Stephan Szabo 17:41
Re: "SELECT IN" Still Broken in 7.4b Mike Winter 18:51
Re: "SELECT IN" Still Broken in 7.4b Joe Conway 19:24
Table conversion query... George McQuade 19:31
Re: Before/After Trigger User Switching Aasmund Midttun Godal 19:34
Re: Before/After Trigger User Switching Tom Lane 20:12
Re: Table conversion query... Joe Conway 20:19
Re: "SELECT IN" Still Broken in 7.4b Tom Lane 20:32
Re: Before/After Trigger User Switching Aasmund Midttun Godal 20:33
Re: "SELECT IN" Still Broken in 7.4b Rod Taylor 20:41
Re: Before/After Trigger User Switching Tom Lane 20:53
problem with automatic altering of groups Matthias Nagl 21:09
Re: Porting from PL/SQL to PLPGSQL Roberto Mello 21:12
Re: Configuring Problem on Solaris............ LAIN Lucas TECHTEL 21:16
problem with automatic altering of groups Matthias Nagl 21:18
Re: Configuring Problem on Solaris............ Peter Eisentraut 21:18
Re: Table conversion query... George McQuade 21:28
Re: problem with automatic altering of groups Josh Berkus 21:32
Re: "SELECT IN" Still Broken in 7.4b Stephan Szabo 21:55
Re: [Newbie] migrating a stored procedure from MSSQL to postgresql Richard Hall 22:28
Re: Table conversion query... Joe Conway 23:57

Aug. 21, 2003

Thread Author Time
URGENT : free result (libpq++ API) Anagha Joshi 05:57
Re: URGENT : free result (libpq++ API) Stephan Szabo 06:11
Re: "SELECT IN" Still Broken in 7.4b Oleg Bartunov 07:38
Re: "SELECT IN" Still Broken in 7.4b Dani Oderbolz 10:05
Re: "SELECT IN" Still Broken in 7.4b Stephan Szabo 17:28
Re: [SQL] "SELECT IN" Still Broken in 7.4b Tom Lane 20:42
Re: [SQL] "SELECT IN" Still Broken in 7.4b Stephan Szabo 21:07
Re: [SQL] "SELECT IN" Still Broken in 7.4b Manfred Koizar 21:18
Re: [SQL] "SELECT IN" Still Broken in 7.4b Josh Berkus 21:19
Re: [SQL] "SELECT IN" Still Broken in 7.4b Tom Lane 21:46
Re: [SQL] "SELECT IN" Still Broken in 7.4b Joe Conway 22:01
Re: [SQL] "SELECT IN" Still Broken in 7.4b Tom Lane 22:17

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

Browse Archives

Prev | Next