On Tue, Sep 29, 2009 at 8:06 AM, Iain Barnett <iainsp...@gmail.com> 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...all postgresql functions can be used in queries:

select * from myfunction();

What you are probably bumping into is that previously to 8.4, plpgsql
functions could not be called the short way:
select myfunction();

If this is your problem, the workarounds are to adjust the query, wrap
it with an sql function, or upgrade to 8.4.

merlin

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to