Re: [SQL] More efficient DELETE ... ?

2000-09-29 Thread Bruce Momjian
Just a reminder that this is taken care of. It only WARNs in cases where we suspect they really made a mistake. test=> select * from pg_class s where pg_class.oid =34; NOTICE: Adding missing FROM-clause entry for table pg_class > Bruce Momjian <[EMAIL PROTECTED]> writes: > >

Re: [SQL] invoke an external shell script from a function

2000-09-29 Thread Joel Mc Graw
Peter Eisentraut wrote: > > Chau, Artemis writes: > > > Does anyone know how to invoke an external shell script from a function when > > it is called from a sql statement? > > If it's a C function, use system("file"). Is this the only way to do this? I would also like to have a trigger call a

[SQL] Transaction isolation level for plpgsql

2000-09-29 Thread Keith Wong
Hi all, Does anybody know the transaction isolation level default when a plpgsql stored procedure is called? Is it possible to set it? Or is this controlled by SPI? Cheers, Keith.

[SQL] timestamp difference in hours? (fwd)

2000-09-29 Thread Alessandro Rossi
-- Forwarded message -- Date: Sat, 23 Sep 2000 15:58:06 +0200 (CEST) From: Alessandro Rossi <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: timestamp difference in hours? I found in a post from Jeff MacDonald the following example: bignose=> \d foo Table "foo"

Re: [SQL] invoke an external shell script from a function

2000-09-29 Thread Peter Eisentraut
Chau, Artemis writes: > Does anyone know how to invoke an external shell script from a function when > it is called from a sql statement? If it's a C function, use system("file"). -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

[SQL] invoke an external shell script from a function

2000-09-29 Thread Chau, Artemis
Does anyone know how to invoke an external shell script from a function when it is called from a sql statement? -- Artemis Chau, Intel Corp.