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