pgsql-sql - September 2003

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

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
how to vacum Richard Sydney-Smith 12:43
Re: how to vacum Erik Thiele 12:56
Re: MINUS & ROWNUM in PostGres 📎 A.Bhuvaneswaran 12:57
Re: how to vacum Bruno Wolff III 13:07
Plz, what is the most "correct" method PipHans 16:01
Re: how to vacum Peter Eisentraut 19:46
change a field Patrick Meylemans 20:12
Re: how to vacum Martin Marques 20:39

Sept. 11, 2003

Thread Author Time
Re: MD5 function is not available ? Richard Huxton 08:34
MD5() function not available ?? Marek Lewczuk 08:37
MD5 function is not available ? Marek Lewczuk 08:38
Re: MD5 function is not available ? Tomasz Myrta 16:59

Sept. 12, 2003

Thread Author Time
How do I replace select ... into commands? Richard Sydney-Smith 02:33
Re: How do I replace select ... into commands? Stephan Szabo 02:46
Re: How do I replace select ... into commands? Richard Sydney-Smith 02:59
Re: How do I replace select ... into commands? Tom Lane 03:20
Re: How do I replace select ... into commands? Richard Sydney-Smith 05:06
how to call a function with row-type arg sad 05:31
Re: How do I replace select ... into commands? Richard Huxton 07:08
Re: how to call a function with row-type arg Richard Hall 13:35
createlang plpgsql failing on redhatlinux7.2 📎 vijaykumar M 13:49
Re: how to call a function with row-type arg Tom Lane 13:57
Re: createlang plpgsql failing on redhatlinux7.2 Richard Huxton 14:12
Re: createlang plpgsql failing on redhatlinux7.2 Robert Treat 15:49
Re: createlang plpgsql failing on redhatlinux7.2 Richard Huxton 16:18
Q: insert/update in same statement G. Ralph Kuntz, MD 17:55
Q: select query G. Ralph Kuntz, MD 17:58

Sept. 13, 2003

Thread Author Time
createlang problme vijaykumar M 05:46
Re: createlang problme Tom Lane 15:55
production parameters chester c young 18:10
Re: Q: select query Rod Taylor 18:17
Re: [BUGS] session variable Miko O'Sullivan 18:23
Re: Q: select query Manfred Koizar 18:52
sorting chester c young 19:47
Re: Q: insert/update in same statement Bruno Wolff III 20:22
Re: production parameters Gregory S. Williamson 20:50
Re: createlang plpgsql failing on redhatlinux7.2 Robert Treat 23:44

Sept. 14, 2003

Thread Author Time
A generic trigger? ow 01:13
Use derived expression in select statement Richard Sydney-Smith 04:25
Re: Use derived expression in select statement Tom Lane 04:38
Re: MD5() function not available ?? Dennis Bjorklund 05:12
Column Types Muhyiddin A.M Hayat 06:49
[No subject] Muhyiddin A.M Hayat 07:53
Re: Column Types Oliver Elphick 07:53
Re: A generic trigger? Peter Childs 08:26
Re: A generic trigger? ow 10:28
Linked Lists example. Rudi Starcevic 11:24
Re: A generic trigger? Tom Lane 17:30

Sept. 15, 2003

Thread Author Time
Re: change a field Peter Eisentraut 00:03
Re: Linked Lists example. Rudi Starcevic 00:05
Re: Linked Lists example. Rudi Starcevic 00:38
Re: change a field A.Bhuvaneswaran 04:57
Re: Plz, what is the most "correct" method Richard Huxton 08:33
Copy Command Error Richard Sydney-Smith 08:57
Re: Copy Command Error Richard Huxton 10:01
Re: change a field Bruno Wolff III 14:27
SET database TO ...? ow 14:46
Re: SET database TO ...? ow 15:33
Re: SET database TO ...? A.Bhuvaneswaran 15:35
Re: SET database TO ...? Tom Lane 16:15
Re: SET database TO ...? Achilleus Mantzios 20:08

Sept. 16, 2003

Thread Author Time
Array fields in Postgresql... Jagdeesh 19:49
A simple way to Create type ...? ow 21:04
Re: A simple way to Create type ...? ow 21:14
Re: A simple way to Create type ...? Christopher Browne 21:27
Re: A simple way to Create type ...? Rod Taylor 21:47
Re: A simple way to Create type ...? ow 22:13

Sept. 17, 2003

Thread Author Time
Re: A simple way to Create type ...? John DeSoi 02:39
sub query Martin Kuria 08:18
sub query Martin Kuria 08:19
Re: sub query Christoph Haller 08:38
Re: sub query Christoph Haller 08:54
Sort order with spaces? Kristian Jörg 09:47
Re: sub query Martin Kuria 09:57
Re: Sort order with spaces? Richard Huxton 10:44
Trigger order problems Richard Huxton 11:20
Re: sub query Christoph Haller 12:00
Re: Sort order with spaces? Kristian Jörg 12:30
Re: Sort order with spaces? Kristian Jörg 12:39
how to get decimal to date form wireless 12:50
Re: Sort order with spaces? Richard Huxton 13:50
Re: Sort order with spaces? Tom Lane 14:06
Re: Sort order with spaces? Kristian Jörg 14:26
Re: Sort order with spaces? Kristian Jörg 15:21
Triggers Help... tiagoalves 17:20
Trigger on view Kyle 19:46
Re: how to get decimal to date form Tomasz Myrta 20:24
cursors in plpgsql Tomasz Myrta 20:46
Re: cursors in plpgsql Tom Lane 21:13
Re: [BUGS] session variable Tom Lane 21:23
Need more examples (was "session variable") Miko O Sullivan 21:50
Re: Triggers Help... Gaetano Mendola 22:20

Sept. 18, 2003

Thread Author Time
transaction locking tom baker 05:07
Re: transaction locking Stephan Szabo 05:33
Re: cursors in plpgsql Tomasz Myrta 06:04
Re: transaction locking tom baker 18:11
Re: transaction locking Stephan Szabo 18:24
Unique Constraint Based on Date Range Andrew Milne 18:42
plpgsql triggers question -> foo := NEW ? Mihail Changalov 18:59
Re: how to get decimal to date form David Brown 19:14
Re: transaction locking tom baker 23:22

Sept. 19, 2003

Thread Author Time
Automated Backup Kumar 05:34
Datafiles for Databases Kumar 05:38
virus warning Tomasz Myrta 06:17

Browse Archives

Prev | Next