Received: from smtp.snet.net (smtp.snet.net [204.60.6.55]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f62Kpfa69766 for ; Mon, 2 Jul 2001 16:51:41 -0400 (EDT) (envelope-from wweng@kencast.com) Received: from pop.snet.net (pop.snet.net [204.60.6.9]) by smtp.snet.net (8.11.1/8.11.1/SNET-mx-1.4/D-1.10/O-1.7) with ESMTP id f62KpcC13657 for ; Mon, 2 Jul 2001 16:51:38 -0400 (EDT) Received: from [192.168.1.83] (167.95.252.64.snet.net [64.252.95.167]) by pop.snet.net (8.11.1/8.11.1/SNET-pop-1.5/D-1.8/O-1.6) with ESMTP id f62Kpcr08067 for ; Mon, 2 Jul 2001 16:51:38 -0400 (EDT) Subject: Null set From: Wei Weng To: pgsql-sql@postgresql.org Content-Type: text/plain X-Mailer: Evolution/0.10 (Preview Release) Date: 02 Jul 2001 17:57:34 -0400 Message-Id: <994111055.6586.4.camel@Monet> Mime-Version: 1.0 X-Archive-Number: 200107/9 X-Sequence-Number: 3790 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.