Re: Fwd: Re: [GENERAL] Extracting time from timestamp

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: Fwd: Re: [GENERAL] Extracting time from timestamp
Дата
Msg-id 200303211241.21714.shridhar_daithankar@persistent.co.in
обсуждение исходный текст
Ответ на Re: Fwd: Re: [GENERAL] Extracting time from timestamp  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Friday 21 Mar 2003 12:25 pm, Tom Lane wrote:
> "Shridhar Daithankar<shridhar_daithankar@persistent.co.in>" 
<shridhar_daithankar@persistent.co.in> writes:
> > And What's so holy about "" if it is a function?
>
> The problem is that TIME(n) is a datatype name, not a function call,
> according to the SQL spec.  Likewise for TIMESTAMP(n), INTERVAL(n),
> NUMERIC(m,n), and maybe one or two other special cases I've forgotten.
>
> The SQL spec's love of special-purpose syntaxes is one of its worst
> features IMHO ...

In this case, I would vote for overload as SQL extension in postgresql if 
people feel it is feasible and/or sensible..
Shridhar


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Fwd: Re: [GENERAL] Extracting time from timestamp
Следующее
От: "Vadim Mikheev"
Дата:
Сообщение: Re: Nested transactions: low level stuff