pgsql-sql since 2003-07-24 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

July 24, 2003

Thread Author Time
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Robert Treat 02:00
Re: obtuse plpgsql function needs Tom Lane 05:07
[No subject] Pavel Penak 06:46
Combine 'left outer join' and 'inner join' ext-thierry.templier 07:10
Problem using Subselect results oheinz 08:39
Re: Problem using Subselect results Christoph Haller 12:11
Re: Problem using Subselect results oheinz 13:01
Re: Problem using Subselect results Dmitry Tkach 14:54
PostgreSQL or pl/psSQL equivalent to MS SQL Server's xp_cmdshell? Trent.Mera 15:52
PostgreSQL or pl/psSQL equivalent to MS SQL Server's xp_cmdshell? Trent.Mera 17:29
Re: PostgreSQL or pl/psSQL equivalent to MS SQL Server's scott.marlowe 17:31
Re: min() and NaN Greg Stark 18:35
Re: min() and NaN Tom Lane 18:44
Re: obtuse plpgsql function needs elein 19:03
silly NULL question Dan Weeks 23:15
Re: silly NULL question Rod Taylor 23:25
Re: silly NULL question Dan Weeks 23:31

July 25, 2003

Thread Author Time
Equivalent to sql%rowcount or @@rowcount 📎 vijaykumar M 06:04
Re: Equivalent to sql%rowcount or @@rowcount Richard Huxton 08:05
[OT] Frontend recommendations ries 08:18
Re: Problem using Subselect results oheinz 09:01
Re: [OT] Frontend recommendations Richard Huxton 09:50
Re: [OT] Frontend recommendations Peter Childs 12:31
Query analyse Elielson Fontanezi 13:08
Re: Problem using Subselect results Tom Lane 13:45
Re: Problem using Subselect results Dmitry Tkach 14:23
Re: [OT] SUMMERY Frontend recommendations R. van Twisk 14:34
Re: Query analyse Stephan Szabo 15:49
Re: Query analyse Dmitry Tkach 16:05
locks and variable substitution gack 18:49
ERROR: DefineIndex: index function must be marked iscachable Elielson Fontanezi 19:09
Re: [SQL] ERROR: DefineIndex: index function must be marked iscachable Stephan Szabo 19:21
Re: ERROR: DefineIndex: index function must be marked iscachable Tomasz Myrta 19:22
Re: [SQL] ERROR: DefineIndex: index function must be Stephan Szabo 19:24
RES: [SQL] ERROR: DefineIndex: index function must be marked iscachable Elielson Fontanezi 19:27
Re: Query analyse Tom Lane 19:39
ERROR: DefineIndex: index function must be marked iscachable Elielson Fontanezi 19:43
Re: ERROR: DefineIndex: index function must be marked Stephan Szabo 19:47
Re: locks and variable substitution Eric Clark 19:57
RES: ERROR: DefineIndex: index function must be marked iscachable Elielson Fontanezi 20:20
Function index qeustion Jonathan Bartlett 20:26
Re: Odd problems with create rule Tomasz Myrta 21:08
Odd problems with create rule Jamie Lawrence 21:38
Re: Odd problems with create rule Jamie Lawrence 22:08
Re: Function index qeustion Tom Lane 23:41

July 26, 2003

Thread Author Time
Very strange 'now' behaviour in nested triggers. Denis Zaitsev 13:39
Re: Very strange 'now' behaviour in nested triggers. Richard Huxton 14:14
Re: Very strange 'now' behaviour in nested triggers. Tom Lane 14:31
Re: Very strange 'now' behaviour in nested triggers. Denis Zaitsev 19:58
Re: Very strange 'now' behaviour in nested triggers. Denis Zaitsev 20:01

July 27, 2003

Thread Author Time
Re: Very strange 'now' behaviour in nested triggers. Richard Huxton 07:47
Re: Very strange 'now' behaviour in nested triggers. Denis Zaitsev 11:09
Re: Very strange 'now' behaviour in nested triggers. Tom Lane 15:49

July 28, 2003

Thread Author Time
Re: Very strange 'now' behaviour in nested triggers. Roberto Mello 00:27
Re: Can a table have a reference to itself? Stephan Szabo 03:47
Using a compound primary key David Witham 03:59
join optimization problem Toby Tremayne 04:12
Re: Can a table have a reference to itself? Tom Lane 05:31
Re: Using a compound primary key Tom Lane 05:45
Re: Problem using Subselect results Bruno Wolff III 16:41
Re: Very strange 'now' behaviour in nested triggers. Dmitry Tkach 16:43
Re: Problem using Subselect results Josh Berkus 16:47
Re: Very strange 'now' behaviour in nested triggers. Tom Lane 16:52
Re: Very strange 'now' behaviour in nested triggers. Dmitry Tkach 17:06
Re: Very strange 'now' behaviour in nested triggers. Tom Lane 17:12
Re: Very strange 'now' behaviour in nested triggers. Dmitry Tkach 17:18
NEW and a subselect in a rule Denis Zaitsev 22:50

July 29, 2003

Thread Author Time
How can I to solute this problem? LEON 06:18
Re: How can I to solute this problem? Paul Thomas 07:23
unsubscribe [email protected] 📎 Subramaniam, Sankari (Cognizant) 11:07
Re: Problem using Subselect results oheinz 11:34
How can I to solute this problem? Christopher Browne 12:11
Re: How can I to solute this problem? Paul Thomas 12:37
Re: How can I to solute this problem? Achilleus Mantzios 13:23
unsubscribe Mark Roberts 14:04
length of recordset read through a cursor Knut P. Lehre 14:10
Re: Problem using Subselect results Tom Lane 15:00
Re: Problem using Subselect results Oliver Heinz 15:14
Unsubscribe Antony Gubert 15:14
Re: How can I to solute this problem? Achilleus Mantzios 16:09
transactions Viorel Dragomir 18:14
Re: transactions Josh Berkus 19:28
Does a the block of code within a stored procedure constitute a transaction? btober 20:16
Unsubscribe ww zz 20:46
Nonexistent NEW relation in some places of rules Denis Zaitsev 21:33
Re: Very strange 'now' behaviour in nested triggers. Denis Zaitsev 22:05
Re: Nonexistent NEW relation in some places of rules Tom Lane 22:32
Unsubscribe Vishal Charan (IT Fiji) 23:06

July 30, 2003

Thread Author Time
function returning setof performance question Mark Bronnimann 02:08
Re: Very strange 'now' behaviour in nested triggers. Bruce Momjian 02:20
Re: function returning setof performance question Rod Taylor 02:28
Re: function returning setof performance question Mark Bronnimann 02:57
Re: function returning setof performance question Joe Conway 03:51
time precision. Anagha Joshi 07:52
Re: Problem using Subselect results oheinz 08:52
Which cursor-related warnings should be errors? Peter Eisentraut 09:06
Re: time precision. Christoph Haller 09:08
Re: How can I to solute this problem? LEON 09:43
Re: [SQL] time precision. Stephan Szabo 09:45
now 7.2.3 - 7.3.3 A. Van Hook 10:06
Re: now 7.2.3 - 7.3.3 Peter Eisentraut 10:41
Re: How can I to solute this problem? Paul Thomas 11:25
select query that would join two databases Keith H.K. Lam (U1 Tech.) 11:28
Re: Very strange 'now' behaviour in nested triggers. Tom Lane 13:48
Re: now 7.2.3 - 7.3.3 Tom Lane 15:19
ALTER TABLE ... DROP CONSTRAINT Elielson Fontanezi 15:52
Re: ALTER TABLE ... DROP CONSTRAINT Andrew Gould 16:07
Re: ALTER TABLE ... DROP CONSTRAINT Rod Taylor 16:21
Re: [SQL] ALTER TABLE ... DROP CONSTRAINT Chad Thompson 16:25
Re: [SQL] ALTER TABLE ... DROP CONSTRAINT George Weaver 16:45
Re: [SQL] function returning setof performance question Josh Berkus 17:28
Re: Problem using Subselect results Josh Berkus 18:08
Re: [SQL] ALTER TABLE ... DROP CONSTRAINT Rajesh Kumar Mallah 19:25
Re: Fwd: Bad Join moment - how is this happening? Josh Berkus 19:25
One to many query question Dave Dribin 19:35
Re: Fwd: Bad Join moment - how is this happening? Richard Huxton 19:36
Re: Fwd: Bad Join moment - how is this happening? Josh Berkus 19:38
Re: Fwd: Bad Join moment - how is this happening? Stephan Szabo 19:39
Fwd: Bad Join moment - how is this happening? Jamie Lawrence 20:07
Re: One to many query question Eric Clark 20:11
Re: One to many query question Dave Dribin 20:27
Re: Nonexistent NEW relation in some places of rules Denis Zaitsev 21:02
Re: One to many query question Richard Poole 21:12
Re: One to many query question Richard Huxton 21:19
Re: One to many query question Dmitry Tkach 21:26
Re: One to many query question Chad Thompson 21:28
Re: One to many query question Eric Clark 21:42
Re: One to many query question Dave Dribin 22:33

July 31, 2003

Thread Author Time
Unsubscribe 2000info 00:25
[No subject] Vishal Charan (IT Fiji) 01:18
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Bruce Momjian 04:12
Re: One to many query question Christoph Haller 07:42
Re: NEW and a subselect in a rule Christoph Haller 08:00
Unsubscribe rute solipa 08:35
Re: Fwd: Bad Join moment - how is this happening? Christoph Haller 09:30
problem in database backup 📎 vijaykumar M 11:13
Re: problem in database backup Tomasz Myrta 11:40
Re: problem in database backup 📎 vijaykumar M 11:59
Re: problem in database backup Richard Huxton 11:59
Problem login to phpPgAdmin 2.x and 3.x Rado Petrik 12:12
converting interval to timestamp teknokrat 16:05
RI_ConstraintTrigger_11264756 Charles Hauser 19:18
EXTERNAL storage and substring on long strings Scott Cain 19:26
Re: EXTERNAL storage and substring on long strings Tom Lane 19:44
Re: EXTERNAL storage and substring on long strings Scott Cain 20:20
Re: EXTERNAL storage and substring on long strings Joe Conway 20:31
Re: EXTERNAL storage and substring on long strings Tom Lane 20:32
Re: EXTERNAL storage and substring on long strings Scott Cain 20:39
Re: EXTERNAL storage and substring on long strings Scott Cain 20:41
Re: EXTERNAL storage and substring on long strings Joe Conway 20:49
Re: EXTERNAL storage and substring on long strings Tom Lane 20:58
Re: EXTERNAL storage and substring on long strings Joe Conway 21:03
Re: EXTERNAL storage and substring on long strings Scott Cain 21:11
Re: EXTERNAL storage and substring on long strings Ron Johnson 21:21
Problem with looping on a table function result Alexander M. Pravking 22:32

Aug. 1, 2003

Thread Author Time
Re: join optimization problem Rod Taylor 00:33
Re: join optimization problem Tom Lane 00:36
Re: Does a the block of code within a stored procedure constitute Rod Taylor 00:37
Re: select query that would join two databases Rod Taylor 00:39
Using contrib/fulltext on multiple tables Eric Johnson 00:54
Re: Does a the block of code within a stored procedure constitute a transaction? btober 01:28
Re: length of recordset read through a cursor Christoph Haller 11:25
Re: converting interval to timestamp Mike Rylander 12:41
duplicate dates Jodi Kanter 15:56
Re: duplicate dates Christopher Browne 15:57
Re: Fwd: Bad Join moment - how is this happening? Jamie Lawrence 17:02
What day is it - when it isn't NOW()? tomg 18:27
Re: What day is it - when it isn't NOW()? Rod Taylor 18:28
Re: What day is it - when it isn't NOW()? Josh Berkus 18:28
Re: What day is it - when it isn't NOW()? tomg 18:53
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Robert Treat 19:16
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Josh Berkus 20:06
Re: NEW and a subselect in a rule Denis Zaitsev 20:12
backend cpu usage? [7.2] george young 20:23
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Richard Poole 20:26
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Josh Berkus 21:02
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Bruce Momjian 21:31
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Josh Berkus 21:39
Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Bruce Momjian 21:44
Re: backend cpu usage? [7.2] Tom Lane 22:21

Aug. 2, 2003

Thread Author Time
Efficient deletions? Bertrand Petit 00:21
Re: Efficient deletions? A.Bhuvaneswaran 07:21

Aug. 3, 2003

Thread Author Time
Re: join optimization problem Toby Tremayne 10:20
Re: join optimization problem Toby Tremayne 10:21
Re: join optimization problem Rod Taylor 13:04
Re: join optimization problem Tom Lane 16:19

Aug. 4, 2003

Thread Author Time
How to check: is some key referenced from sometable evl 08:17
Re: Problem with looping on a table function result Christoph Haller 09:26
Re: EXTERNAL storage and substring on long strings Scott Cain 15:25
Re: [SQL] EXTERNAL storage and substring on long strings Tom Lane 15:53
Re: [SQL] EXTERNAL storage and substring on long strings Richard Huxton 15:55
Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain 16:14
Re: [SQL] EXTERNAL storage and substring on long strings Shridhar Daithankar 16:19
Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain 16:25
Re: [SQL] EXTERNAL storage and substring on long strings Matt Clark 16:56
Re: [SQL] EXTERNAL storage and substring on long strings Joe Conway 20:29

Aug. 5, 2003

Thread Author Time
Timestamp in PG - 7.1 & 7.2 Anagha Joshi 10:21
Re: length of recordset read through a cursor Knut P. Lehre 11:13
Re: length of recordset read through a cursor Christoph Haller 12:22
Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain 15:01

Browse Archives

Prev | Next