Re: [GENERAL] simple update on boolean

2007-12-06 Thread Cedric Boudin
Ivan Sergio Borgonovo wrote: > On Thu, 06 Dec 2007 13:38:31 +0100 > Cedric Boudin <[EMAIL PROTECTED]> wrote: > > >> It was indeed a forest problem. >> both: >> >> set bolean_column= not bolean_column >> and >> set bolean_column= case w

Re: [GENERAL] simple update on boolean

2007-12-06 Thread Cedric Boudin
Cedric Boudin wrote: > Most honourable members of the list, > > this is a simple one, but I can't find the solution ( probably a > forest/tree problem). > > update table set bolean_column = set_it_to_its_inverse where fk = > some_value; > > or join

[GENERAL] simple update on boolean

2007-12-06 Thread Cedric Boudin
Most honourable members of the list, this is a simple one, but I can't find the solution ( probably a forest/tree problem). update table set bolean_column = set_it_to_its_inverse where fk = some_value; or join me in the dark forest cedric ---(end of broadcast)-

[GENERAL] scrollable cursor in functions

2007-11-30 Thread Cedric Boudin
Dear members of the list, on a server 8.1.9 I try to do this: ++ create or replace function dummy() returns void as $$ DECLARE liahona SCROLL CURSOR with hold FOR SELECT * FROM album ; BEGIN --DECLARE liahona SCROLL CURSOR with hold FOR SELECT * FROM album ; -- Set up a cursor: -- Fetch