| From: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Can't "EXTRACT" from a field? |
| Date: | 2001-11-22 15:02:44 |
| Message-ID: | 20011122100116.O64011-100000@earth.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brent Verner | 2001-11-22 15:57:31 | Re: Can't "EXTRACT" from a field? |
| Previous Message | Turbo Fredriksson | 2001-11-22 14:45:57 | rServ and multiple columns in db to replicate |