Re: SQL and function reference?
От
Tom Lane
Тема
Re: SQL and function reference?
Дата
Msg-id
23136.1106782489@sss.pgh.pa.us
Ответ на
Re: SQL and function reference? (Alexander Borkowski)
Список
Дерево обсуждения
SQL and function reference? "Rodolfo J. Paiz" <rpaiz@simpaticus.com>
Re: SQL and function reference? Alexander Borkowski <alexander.borkowski@abri.une.edu.au>
Re: SQL and function reference? "Rodolfo J. Paiz" <rpaiz@simpaticus.com>
Re: SQL and function reference? Michael Fuhr <mike@fuhr.org>
Re: SQL and function reference? "Rodolfo J. Paiz" <rpaiz@simpaticus.com>
Re: SQL and function reference? "Rodolfo J. Paiz" <rpaiz@simpaticus.com>
Re: SQL and function reference? Alexander Borkowski <alexander.borkowski@abri.une.edu.au>
Re: SQL and function reference? Tom Lane <tgl@sss.pgh.pa.us>
Re: SQL and function reference? Jason Dixon <jason@dixongroup.net>
Re: SQL and function reference? "Rodolfo J. Paiz" <rpaiz@simpaticus.com>
Alexander Borkowski writes: > How about: > select * > from flights > where date < cast(current_date + interval '30 days ago' as date); This is the hard way ... you can just add/subtract a date and an integer, instead: ... where date < (current_date - 30); regards, tom lane
В списке pgsql-novice по дате отправления
