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: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
Thanks, that was exactly what I needed.


]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 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-2017 The PostgreSQL Global Development Group