wow...I will try to do it soon. I went to work and now back at home I
can test it.
"real" thanks to you both,
JP
On 21/09/2006, at 9:16, Norman Palardy wrote:
On Sep 21, 2006, at 1:11 AM, Norman Palardy wrote:
On Sep 21, 2006, at 12:39 AM, Juan Pablo Garcia wrote:
Thanks a lot!
This was a "shower time" solution.
I put the post before goint to shower, then while I´m wet I
already have the answers!
Will test it when dry :-)
JP
actually coalesce is probably the wrong function and you may need
something like
UPDATE musicians
SET leadguitarist = case musicianid = xxxx
when true then true
else false
end
WHERE .. whatever your criteria are for identifying the members
of the band ...
or something along those lines
like this (works)
create table musician (leadsinger boolean, id integer primary key)
insert into musician (leadsinger , id ) values ( 0, 1 )
insert into musician (leadsinger , id ) values ( 0, 2 )
insert into musician (leadsinger , id ) values ( 0, 3 )
update musician set leadsinger = case id = 2 when 1 then 1 else 0 end
(note the use of 0 and 1 as false and true)
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
