Re: EXTRACT broken - Mailing list pgsql-hackers

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

> > peter=# SELECT EXTRACT(DOW FROM TIME '20:38:40');
> > ERROR:  Interval units 'dow' not recognized
> > The expression is nonsensical, but so is the result.
>
> Hmm. Why is the result nonsensical? "day of week" does not have meaning
> for intervals, so it should not be recognized, right?

It's the "interval" part that's troubling me, since it appears nowhere in
the original expression.

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



pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: pg_client_encoding
Next
From: Gavin Sherry
Date:
Subject: Re: CLUSTER TODO item