Re: [GENERAL] Problem creating stored procedure

2005-12-27 Thread Michael Fuhr
On Tue, Dec 27, 2005 at 12:41:44PM -0500, Ted Byers wrote: > I am puzzled. Can ayone explain why I get an error from Postgres > on this simple stored procedure? There are several mistakes in the code you posted: * PostgreSQL doesn't have a CREATE PROCEDURE command. Use CREATE FUNCTION. * You

Re: [GENERAL] Problem creating stored procedure

2005-12-27 Thread Jaime Casanova
On 12/27/05, Ted Byers <[EMAIL PROTECTED]> wrote: > 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 ( one reason could be that PROCEDURE

Re: [GENERAL] Problem creating stored procedure

2005-12-27 Thread Uwe C. Schroeder
Try CREATE FUNCTION . On Tuesday 27 December 2005 09:41, Ted Byers wrote: > 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 ( > f