Re: simple function syntax - Mailing list pgsql-general

From Robert B. Easter
Subject Re: simple function syntax
Date
Msg-id 0101260150140P.08820@comptechnews
Whole thread Raw
In response to simple function syntax  (Culley Harrelson <culleyharrelson@yahoo.com>)
List pgsql-general
Load the procedural language from the shell:

createlang plsql <dbname>

On Friday 26 January 2001 00:55, Culley Harrelson wrote:
> OK trying to write my first function and its blowing
> up at compile.  What's wrong with this:
>
> CREATE FUNCTION test_function(int4) RETURNS int4 AS '
>     DECLARE
>         test ALIAS FOR $1;
>     BEGIN
>         RETURN test;
>     END;
> ' LANGUAGE 'plpgsql';
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - Buy the things you want at great prices.
> http://auctions.yahoo.com/

--
-------- Robert B. Easter  reaster@comptechnews.com ---------
-- CompTechNews Message Board http://www.comptechnews.com/ --
-- CompTechServ Tech Services http://www.comptechserv.com/ --
---------- http://www.comptechnews.com/~reaster/ ------------

pgsql-general by date:

Previous
From: Culley Harrelson
Date:
Subject: simple function syntax
Next
From: Guillaume Lémery
Date:
Subject: Re: Re: Load a database into memory