On Wed, 2 Jan 2019, Tom Lane wrote:
'today' is special as a date input string, so you can use it as a literal: regression=# select 'today'::date; date ------------ 2019-01-02 (1 row) But it's not a SQL keyword, nor a function name, so you can't write it without quotes.
Tom, Now I understand. I tried it with quotes, too, but this was in the table definition, not as a selection criterion. I did not pick up this difference when reading about the date-time data types. Thanks very much for clarifying. Best regards, Rich
