BUG in EXTRACT(MICROSECONDS...)? - Mailing list pgsql-sql

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.