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?
--
Wei Weng
Network Software Engineer
KenCast Inc.