Re: EXTRACT broken

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: EXTRACT broken
Дата
Msg-id Pine.LNX.4.30.0110122012400.648-100000@peter.localdomain
обсуждение исходный текст
Ответ на Re: EXTRACT broken  (Thomas Lockhart <lockhart@fourpalms.org>)
Ответы Re: EXTRACT broken  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Warning of OID wraparound
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Package support for Postgres