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
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 me in the dark forest
cedric
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 when bolean_column then 'f'::bool else
't'::bool end;
do work perfectly
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:
--
