simple? query - Mailing list 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;

Anyone an idea?

Regards,

Jan