Help with quotes in plpgsql - Mailing list pgsql-sql

From Richard Ray
Subject Help with quotes in plpgsql
Date
Msg-id Pine.LNX.4.64.0612191404580.30942@rray.drdc.mstc.ms.gov
Whole thread Raw
Responses Re: Help with quotes in plpgsql  ("Jim Buttafuoco" <jim@contactbda.com>)
Re: Help with quotes in plpgsql  ("Milen A. Radev" <milen@radev.net>)
Re: Help with quotes in plpgsql  ("Hector Villarreal" <HVillarreal@mynewplace.com>)
Re: Help with quotes in plpgsql  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List 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


pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Desc table
Next
From: "Jim Buttafuoco"
Date:
Subject: Re: Help with quotes in plpgsql