[SQL] Null set

[Wei Weng]

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.



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly