Skip site navigation (1) Skip section navigation (2)

Re: Create interval using column value?

From: Larry Lennhoff <llennhoff-postgres(at)pexicom(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Create interval using column value?
Date: 2004-10-25 03:18:55
Message-ID: 6.0.2.0.0.20041024231819.03b5c540@localhost (view raw or flat)
Thread:
Lists: pgsql-sql
Thanks, that was exactly what I needed.

Larry

]At 11:11 PM 10/24/2004, Tom Lane wrote:
>Larry Lennhoff <llennhoff-postgres(at)pexicom(dot)com> writes:
> > What I want to do is find all the rows in
> > A which were built before now() - build_interval seconds ago.  If I could
> > just write this in SQL it would look something like:
>
> > SELECT A.id FROM A JOIN B ON (join_col) WHERE built_on < now() - interval
> > 'build_interval seconds';
>
>You are confused about the difference between a literal constant and an
>expression.   Try something like
>
>.. WHERE built_on < now() - build_interval * interval '1 second';
>
>which relies on the number-times-interval operator.
>
>                         regards, tom lane


In response to

pgsql-sql by date

Next:From: cristivoinicaruDate: 2004-10-25 08:13:37
Subject: sql
Previous:From: Michael GlaesemannDate: 2004-10-25 03:13:42
Subject: Re: Create interval using column value?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group