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 [EMAIL PROTECTED] Fax: (416) 441-9085 > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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 > [EMAIL PROTECTED] > 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 [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
