Re: A newbie question

And in fact you can even do:
SELECT myfunction()

if the function does not rely on data/parameters from a table, which would
be the case if there are no parameters at all to myfunction()

Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
terry(at)greatgulfhomes(dot)com
Fax: (416) 441-9085

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Oliver Elphick
> Sent: Wednesday, November 19, 2003 6:22 PM
> To: Brian H Mayo
> Cc: PostgreSQL general list
> Subject: Re: [GENERAL] A newbie question
>
>
> On Wed, 2003-11-19 at 02:43, Brian H Mayo wrote:
> > I am a newbie to PostgreSQL. I added plpgsql to the database and
> > wrote a function in the plpgsql language. How do I execute it?
> >
> > I read all of the manuals but I cannot seem to figure it out. I
> > pulled up the pgadmin III SQL and tried different
> combinations to run
> > the function. I tried PERFORM and EXECUTE; no good.
>
> You have done
>
> CREATE FUNCTION myfunction() ... LANGUAGE 'plpgsql';
>
> Now you can say
>
> SELECT myfunction() FROM mytable;
>
> --
> Oliver Elphick
> Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
> Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"To show forth thy lovingkindness in the morning, and
thy faithfulness every night." Psalms 92:2

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)