Re: why oh why procedure - Mailing list pgsql-admin

On Fri, Apr 29, 2005 at 07:48:07AM +0700, dedy wrote:
>
> I want to create store procedure and the sql is
>
> CREATE PROCEDURE CARI_DATA

In PostgreSQL you'll need to use CREATE FUNCTION.  See also the
PL/pgSQL documentation to learn its syntax and capabilities.  Here
are links to documentation for the latest version:

http://www.postgresql.org/docs/8.0/interactive/sql-createfunction.html
http://www.postgresql.org/docs/8.0/interactive/plpgsql.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/