Postgres Pro
Downloads
Home   >   mailing lists

Can't "EXTRACT" from a field? - Mailing list pgsql-hackers

From Marc G. Fournier
Subject Can't "EXTRACT" from a field?
Date
Msg-id 20011122100116.O64011-100000@earth.hub.org
Whole thread Raw
Responses Re: Can't "EXTRACT" from a field?
List pgsql-hackers
Tree view 
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"
traf_stats=# \d hourly_stats                Table "hourly_stats"  Column   |            Type             | Modifiers
------------+-----------------------------+-----------from_ip    | inet                        |to_ip      | inet
                |port       | integer                     |bytes      | bigint                      |runtime    |
timestamp(6)with time zone |no_records | integer                     |
 
Indexes: hourly_from_ip,        hourly_to_ip

pgsql-hackers by date:

Previous
From: Turbo Fredriksson
Date:
Subject: rServ and multiple columns in db to replicate
Next
From: Brent Verner
Date:
Subject: Re: Can't "EXTRACT" from a field?