Re: 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

Welcome to psql 8.2.0, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

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

No problems here. What version are you using?

--
Milen A. Radev