variables in ad hoc queries

From: Iain Barnett <iainspeed(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: variables in ad hoc queries
Date: 2009-09-29 12:06:31
Message-ID: A39A8D42-438F-48E5-84F9-F4190AAB2BCA@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;

or is it just not possible?

Iain

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brian Modra 2009-09-29 12:25:52 Re: query is taking longer time after a while
Previous Message tomrevam 2009-09-29 12:01:02 Re: query is taking longer time after a while