Re: EXTRACT broken - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: EXTRACT broken
Date
Msg-id Pine.LNX.4.30.0110122012400.648-100000@peter.localdomain
Whole thread Raw
In response to Re: EXTRACT broken  (Thomas Lockhart <lockhart@fourpalms.org>)
Responses Re: EXTRACT broken
List pgsql-hackers
Thomas Lockhart writes:

> Oh yeah. We don't have a date_part(units, time) function defined, so it
> is getting converted to interval (which in other contexts *does* have
> some usefulness as a "time equivalent").

You're going to have an extremely hard time convincing me of that.

> We could fairly easily define a date_part() for the time and timetz data
> types.

I had figured that time would be cast to timestamp.  Which is probably
what it used to do.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Warning of OID wraparound
Next
From: Tom Lane
Date:
Subject: Re: Package support for Postgres