Shouldn't EXTRACT treat TIME and TIMESTAMP the same when you are extracting time elements?
--- Allan.
test=# SELECT EXTRACT(MICROSECONDS FROM TIMESTAMP '2001-01-01 17:12:28.5');date_part
----------- 500000
(1 row)
test=# SELECT EXTRACT(MICROSECONDS FROM TIME '17:12:28.5');date_part
----------- 28500000
(1 row)
===
Name : postgresql Relocations: (not relocateable)
Version : 7.1.2 Vendor: (none)
Release : 4PGDG Build Date: Wed Jun 13 22:18:46 2001Install date: Fri Jun 29 20:43:51 2001
Build Host: lowen.wgcr.org
Group : Applications/Databases Source RPM: postgresql-7.1.2-4PGDG.src.rpm
Size : 4426307 License: BSD
URL : http://www.postgresql.org/
Summary : PostgreSQL client programs and libraries.