Problem creating stored procedure

From: "Ted Byers" <r(dot)ted(dot)byers(at)rogers(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Problem creating stored procedure
Date: 2005-12-27 17:41:44
Message-ID: 025001c60b0c$cdd5ece0$6401a8c0@RnDworkstation
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am puzzled. Can ayone explain why I get an error from Postgres on this simple stored procedure?

The following is from the pgAdmin III History window:
-- Executing query:
CREATE PROCEDURE addEntity (
fn IN VARCHAR,
ln IN VARCHAR,
ivar IN VARCHAR,
hi IN VARCHAR,
pw IN VARCHAR,
ea IN VARCHAR,
ad IN VARCHAR,
c IN VARCHAR,
p IN VARCHAR,
co IN VARCHAR,
pc IN VARCHAR
)
AS
DECLARE
varID INTEGER
BEGIN
SELECT int varID uid from uids where email_address=ea;
IF varID IS NOT NULL THEN
INSERT INTO addy (uid,address,city,province,country,postal_code)
VALUES (varID,ad,c,p,co,pc)
ELSE
INSERT INTO uids(family_name,first_name,initials,hid,pword,email_address)
VALUES (ln,fn,ivar,hi,pw,ea)
INSERT INTO addys(...) VALUES (currval('seq'),ad,c,p,co,pc)
END IF;
END
LANGUAGE 'sql' VOLATILE;

ERROR: syntax error at or near "PROCEDURE" at character 8

Judging from the examples in the manual (around page 600), my procedure ought to be fine, but clearly Postgres doesn't like it.

Thanks,

Ted

R.E. (Ted) Byers, Ph.D., Ed.D.
R & D Decision Support Software
http://www.randddecisionsupportsolutions.com/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Uwe C. Schroeder 2005-12-27 17:50:18 Re: Problem creating stored procedure
Previous Message Bruce Momjian 2005-12-27 17:34:34 Re: copy csv eclosed by analog quotes problem superuser ?