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])
