Select question

From: Darin Fisher <darinf(at)pfm(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Select question
Date: 2001-07-30 19:35:41
Message-ID: 3B65B70D.424D5E12@pfm.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Host do I use an alias in a where clause?

The following returns an error:

select locktime,interval,lockpid, extract(epoch from locktime)+interval
as nexttime from customer_monitors where (nexttime < (extract(epoch from
timestamp '2001-07-30 12:29:14-06')));

ERROR: Attribute 'nexttime' not found

Browse pgsql-novice by date

  From Date Subject
Next Message macky 2001-07-31 03:50:29 ----??? Random ???
Previous Message Mike Friesen 2001-07-30 19:15:30 Re: Postgresql & Redhat 6.2 = memory leak?