Postgresql WHERE with age()函数[重复]

不能在中引用别名 WHERE 哪里 SELECT .

可以使用子查询:

SELECT * 
FROM (SELECT date, AGE(now(), date) as t1
      FROM dates) sub
WHERE sub.t1 > interval '0::seconds';

或者 LATERAL (我最喜欢的方式):

SELECT date, s.t1
FROM dates
,LATERAL (SELECT AGE(now(), date) as t1) AS s
WHERE s.t1 > interval '0::seconds';

或重复表达(违反 DRY principle ):

SELECT date, AGE(now(), date) as t1
FROM dates
WHERE AGE(now(), date) > interval '0::seconds';

至于计算 AGE date > now() .

相关文章:

PostgreSQL: using a calculated column in the same query

MySQL - Search into a custom Column

Why do “linq to sql” queries starts with the FROM keyword unlike regular SQL queries?

如果你很匆忙,并且在日期上有一个(有序的)索引,不要这样做。

SELECT date, AGE(now(), date) AS t1
FROM dates
WHERE date > now();

我说 now() ,因为你做了,但也许你想 CURRENT_DATE 相反

create index dates_date on dates(date);