Re: why oh why procedure

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: dedy <slackman(at)unika(dot)ac(dot)id>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: why oh why procedure
Date: 2005-04-29 02:40:14
Message-ID: 20050429024014.GA68161@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mauri Sahlberg 2005-04-29 06:38:16 Re: Help desperately needed: reoccurring invalid page
Previous Message Enrico Weigelt 2005-04-29 02:18:34 Re: Database Encryption (now required by law in Italy)