"James B. Byrne" <byrnejb@xxxxxxxxxxxxx> writes: > Given a datetime column, not null, is there a single syntax that > permits searching for all dates in a given year, year+month, and > year+month+day such that a single parameterised query can handle all > three circumstances? Try date_trunc() ... however, if you want the query to be indexable, it'll take a bit more work. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
