Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group