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

On Friday 21 Mar 2003 12:25 pm, Tom Lane wrote:
> "Shridhar Daithankar<shridhar_daithankar(at)persistent(dot)co(dot)in>"
<shridhar_daithankar(at)persistent(dot)co(dot)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