This is a function I am working on:
CREATE FUNCTION authenticate(int4) RETURN boolean
AS
'SELECT * INTO tmp FROM user WHERE user_id = id;
if SET_IS_NULL(tmp)
return false;
else
return true;'
LANGUAGE 'sql';
My question is: Is there a way to implement the SET_IS_NULL function in
pl/pgsql
I did something like
create function test() returns integer as
'
declare
msg varchar;
begin
msg := "test";
RAISE NOTICE "message is " || msg;
end'
language 'plpgsql';
The function compiled without any error, however, when I tried to run it
as select test(); it broke down with an erro