Received: from lin.local.lan ([216.221.221.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id e9UFa1C33333 for ; Mon, 30 Oct 2000 10:36:02 -0500 (EST) (envelope-from najm@mondo-live.com) Received: from mondo-live.com (IDENT:najm@ll51.local2.lan [192.168.2.51]) by lin.local.lan (8.9.3/8.8.7) with ESMTP id MAA08459 for ; Mon, 30 Oct 2000 12:55:35 GMT Message-ID: <39FEE7B2.31B1D2FB@mondo-live.com> Date: Tue, 31 Oct 2000 10:39:31 -0500 From: Najm Hashmi X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0BOOT i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Need help! parse erro Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/12 X-Sequence-Number: 12 Hi every one, I have just strated to use postgres. I wrote a vert simple pl/pgsql function as given below: CREATE FUNCTION add_new_user(varchar(32),char(8),varchar(128),varchar(128),varchar(32), varchar(32)) RETURNS boolean AS' DECLARE oldUser RECORD; USR ALIAS FOR $1; PWORD ALIAS FOR $2; EMAIL ALIAS FOR $3; ADDR ALIAS FOR $4; CITY ALIAS FOR $5; CNTRY ALIAS FOR $6; BEGIN SELECT INTO oldUser * FROM users where username=USR AND password= PWORD; IF FOUND THEN RETURN ''f''; ELSE INSERT INTO USERS(username,password,email,address,city,country) values(USR,PWORD,EMAIL,ADDR,CITY,CNTRY); RETURN ''t''; END IF; END;' LANGUAGE 'plpgsql'; When I run it I get the following error: najdb=# select add_new_user('najm'::varchar,'najm1234'::char,'najmh@whatever'::varchar,'123street'::varchar,'mtl'::varchar,'canada'::varchar); ERROR: parser: parse error at or near "$1" Someone, please help me out here. I would also appreciate if you all "wizards" out there could send me some more complex examples of plpgsql functions and triggers sinece postgres docs doesn't have any good ones. Thank you all for all your help. Regards. Najm.