Josh Berkus <j...@agliodbs.com> writes: > I was noticing that, where we have a function which has two versions, > timestamp and timestamptz (for example, date_trunc()), if I use a DATE > timestamptz is the default cast. Shouldn't timestamp without time zone > be the default? Is this something we can fix without an overhaul of the > type casting system?
timestamptz is a preferred type, so no you probably can't change that without breaking a lot of stuff. It's not immediately clear to me why that's wrong anyway. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers