Help with quotes in plpgsql

From: Richard Ray <rray(at)mstc(dot)state(dot)ms(dot)us>
To: pgsql-sql(at)postgresql(dot)org
Subject: Help with quotes in plpgsql
Date: 2006-12-19 20:09:37
Message-ID: Pine.LNX.4.64.0612191404580.30942@rray.drdc.mstc.ms.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

How should this be properly quoted

create or replace function test(integer) returns setof text as $$
declare
a record;
begin
select into a now() - interval '$1 day';
return next a;
return;
end
$$ language 'plpgsql';

I'm not having a lot of luck
Thanks
Richard

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Hector Villarreal 2006-12-19 20:17:46 Re: Help with quotes in plpgsql
Previous Message Richard Huxton 2006-12-19 19:53:45 Re: Desc table