Re: Help with quotes in plpgsql

Hi Not sure about $1 parms : you may need to use a variable to set $1 to
then cast it as interval :

create or replace function test(integer) returns setof text as $$

declare

a record;

begin

select into a now() - ($1::text||'days')::interval;

return next a;

return;

end

$$ language 'plpgsql';

-----Original Message-----
From: pgsql-sql-owner(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of Richard Ray
Sent: Tuesday, December 19, 2006 12:10 PM
To: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] Help with quotes in plpgsql

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