Re: Adding time to DATE type

Bruce Momjian writes:

> Can someone give me a TODO summary for this issue?

* make 'text' constants default to text type (not unknown)

(I think not everyone's completely convinced on this issue, but I don't
recall anyone being firmly opposed to it.)

* add SQL interval syntax

> > On Fri, 17 Mar 2000, Bruce Momjian wrote:
> >
> > > test=> SELECT date('1/1/1992') + timespan('1 year');
> >
> > If I may point something out here, the correct syntax for this in SQL92 is
> >
> > SELECT DATE '1/1/1992' + INTERVAL '1 year'
> >
> > (Ignoring the fact that neither the date nor the interval strings have the
> > correct format.)
> >
> > This converts to a cast in PostgreSQL, which is fine, but the standard
> > makes a semantic distinction:
> >
> > CAST('2000-02-29' AS DATE)
> >
> > converts a character literal to date
> >
> > DATE '2000-02-29'
> >
> > *is* a date literal. Furthermore, just
> >
> > '2000-02-29'
> >
> > is not a date literal.
> >
> > I've been doing some lobbying to get rid of the "unknown" type because SQL
> > is perfectly clear about what "quote-stuff-quote" means (character type)
> > and in absence of any evidence to the contrary (such as a function only
> > taking date arguments, inserting it into a date field) it should be
> > treated as such. That will get rid of such embarrassments as
> >
> > SELECT 'a' LIKE 'a' -- try it
> >
> > Tom believes that this will create a pain for the odd data type crowd but
> > I don't think that this is so (or at least has to be so) whereas the
> > current behavior creates a pain for the normal data type crowd.
> >
> > Just my ideas.
> >
> >
> > --
> > Peter Eisentraut Sernanders v?g 10:115
> > peter_e(at)gmx(dot)net 75262 Uppsala
> > http://yi.org/peter-e/ Sweden
> >
> >
>
>
>

--
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden