simple? query

From: Jan Verheyden <jan(dot)verheyden(at)uz(dot)kuleuven(dot)ac(dot)be>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: simple? query
Date: 2009-08-13 11:36:08
Message-ID: E30C7040DE22624185BAD4093190B54437BE5DB4C1@EX2007-MBX-2.uz.kuleuven.ac.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I was trying to run following query but doesn't work:

if (uid='janvleuven10') then
insert into test (registered) values ('1');
else
insert into test (registered) values ('0');
end if;

[cid:image001(dot)png(at)01CA1C1B(dot)03410D10]

Anyone an idea?

Regards,

Jan

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jasen Betts 2009-08-13 12:08:25 Re: mail alert
Previous Message Jorge Godoy 2009-08-13 00:58:42 Re: Month/year between two dates