On 29/09/2009 13:06, Iain Barnett wrote: > If I have a function that returns an integer, how can I use the > following code outside of a function block? > > declare > _myint int; > > begin > _myint := myfunction( ); > end; You can't use this code outside of a function - this just isn't valid SQL. You can of course use your function - select myfunction(); - though I'm sure you know that already. What exactly are you trying to achieve? Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
