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/