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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | cristivoinicaru | 2004-10-25 08:13:37 | sql |
Previous Message | Michael Glaesemann | 2004-10-25 03:13:42 | Re: Create interval using column value? |