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@greatgulfhomes.com
Fax: (416) 441-9085
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.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.Elphick@lfix.co.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@postgresql.org)
