Re: Which casts should be implicit

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "PostgreSQL Development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Which casts should be implicit
Date: 2002-07-26 02:38:24
Message-ID: GNELIHDDFBOCMGBFGEFOOEFMCDAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> date -> timestamp[tz]: I'm suspicious of this one, but it's hard to
> explain. The definition to fill in the time component with zeros is
> reasonable, but it's not the same thing as casting integers to floats
> because dates really represent a time span of 24 hours and timestamps an
> indivisible point in time. I suggest making this non-implicit, for
> conformance with SQL and for general consistency between the date/time
> types.

Althought I'm sure there's _loads_ of people using this conversion,
including me in various random places in the codebase.

Chris

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Cameron Hutchison 2002-07-26 03:21:50 Re: CREATE SYNONYM suggestions
Previous Message Christopher Kings-Lynne 2002-07-26 02:30:43 Re: Oracle Decode Function