On Tue, 19 Dec 2006, Milen A. Radev wrote:
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?
I'm using 8.1.0 but I don't think that's the problem
I have no problem creating the function but it will only substract 1 day
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate