[SQL] Help with quotes in plpgsql

[Richard Ray]

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

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

               http://www.postgresql.org/about/donate