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
