Re: Can't "EXTRACT" from a field?

On Thu, 22 Nov 2001, Brent Verner wrote:

> On 22 Nov 2001 at 10:02 (-0500), Marc G. Fournier wrote:
> |
> | Simple, really ... using v7.2b3 that hasn't been released yet ...
> |
> | traf_stats=# select EXTRACT(WEEK FROM TIMESTAMP runtime) from hourly_stats;
> | ERROR:  parser: parse error at or near "runtime"
>
> The following works for me (on 7.2b3).
>
>   create table test( id serial, tid timestamp default now() );
>   select extract(week from tid) from test;
>
>
> gram.y has
>   extract_list:  extract_arg FROM a_expr
>
> which appears to be in keeping with the sql99 def.
>   part2-         <extract expression> ::=
>   part2:              EXTRACT <left paren> <extract field>
>   part2-                  FROM <extract source> <right paren>
>
>
> I don't know if there was ever any other format for extract(), but
> things look normal from here.

ya, I hadn't clued in until fighting with it some more that if the fieldis
already a timestamp, yyou don't have to put it in as 'EXTRACT(WEEK FROM
TIMESTAMP tid) :(


> btw Marc, can you help me in getting archives of the various lists?

they are all at archives.postgresql.org ... no?