On Nov 3, 2011, at 13:43, bricklen wrote:
> On Thu, Nov 3, 2011 at 10:29 AM, Edward W. Rouse
> wrote:
>> expire := '% days'::interval, limit;
>
> A couple ways spring to mind immediately. Using 10 as the example:
>
> expire := 10 * '1 day'::INTERVAL;
good.
> expire := ('10' || ' days')::IN
e the easy part.
Thanks.
> -Original Message-
> From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-
> ow...@postgresql.org] On Behalf Of bricklen
> Sent: Thursday, November 03, 2011 1:44 PM
> To: Edward W. Rouse
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] in
sql@postgresql.org
> Subject: Re: [SQL] intervals
>
> Hi Edward,
>
> "LIMIT" is a keyword, which is where you are getting your errors. Did
> you try a different variable name?
>
> Best,
>
> Jonathan
>
> On Nov 3, 2011, at 1:29 PM, Edward W. Rouse wrote:
&
Hi Edward,
"LIMIT" is a keyword, which is where you are getting your errors. Did you try
a different variable name?
Best,
Jonathan
On Nov 3, 2011, at 1:29 PM, Edward W. Rouse wrote:
> I am writing a procedure and am having a little difficulty with an interval.
> In the DECLARE section I have
On Thu, Nov 3, 2011 at 10:29 AM, Edward W. Rouse wrote:
> expire := '% days'::interval, limit;
A couple ways spring to mind immediately. Using 10 as the example:
expire := 10 * '1 day'::INTERVAL;
expire := ('10' || ' days')::INTERVAL;
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.o
I am writing a procedure and am having a little difficulty with an interval.
In the DECLARE section I have:
expire interval := '30 days'::interval;
which seems to work fine. In the BEGIN block I need to pull out the number
of days from a table and update the expire interval to that. But I can't
q
