To: pgsql-sql@postgresql.org
From: "Milen A. Radev" <milen@radev.net>
Subject: Re: Help with quotes in plpgsql
Date: Tue, 19 Dec 2006 22:22:09 +0200
Lines: 43
Message-ID: <458849F1.1050100@radev.net>
References: <Pine.LNX.4.64.0612191404580.30942@rray.drdc.mstc.ms.gov>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
User-Agent: Mozilla Thunderbird 1.5.0.8 (Windows/20061025)
In-Reply-To: <Pine.LNX.4.64.0612191404580.30942@rray.drdc.mstc.ms.gov>

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