Re: Fwd: Re: [GENERAL] Extracting time from timestamp - Mailing list pgsql-hackers

From Shridhar Daithankar
Subject Re: Fwd: Re: [GENERAL] Extracting time from timestamp
Date
Msg-id 200303211241.21714.shridhar_daithankar@persistent.co.in
Whole thread Raw
In response to Re: Fwd: Re: [GENERAL] Extracting time from timestamp  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fwd: Re: [GENERAL] Extracting time from timestamp
Next
From: "Vadim Mikheev"
Date:
Subject: Re: Nested transactions: low level stuff