From: | "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com> |
---|---|
To: | Culley Harrelson <culleyharrelson(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: simple function syntax |
Date: | 2001-01-26 06:50:14 |
Message-ID: | 0101260150140P.08820@comptechnews |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)comptechnews(dot)com ---------
-- CompTechNews Message Board http://www.comptechnews.com/ --
-- CompTechServ Tech Services http://www.comptechserv.com/ --
---------- http://www.comptechnews.com/~reaster/ ------------
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lémery | 2001-01-26 07:06:15 | Re: Re: Load a database into memory |
Previous Message | Culley Harrelson | 2001-01-26 05:55:56 | simple function syntax |