BUG #2661: select time with time zone not converting

The following bug has been logged online:

Bug reference: 2661
Logged by: Harry Hehl
Email address: harry(dot)hehl(at)diskstream(dot)com
PostgreSQL version: 8.1.3
Operating system: Linux
Description: select time with time zone not converting
Details:

The "select timestamp with time zone" is working as expected converting the
timestamp to the local time zone.

"select time with time zone" returns the same timezone.

Example:

CREATE TABLE test
(
mytime TIME (6) WITH TIME ZONE,
mytimestamp TIMESTAMP (6) WITH TIME ZONE
);

SET time zone -5;

INSERT INTO test VALUES ('00:00:00', '2006-02-01 00:00:00');

select * from test where mytimestamp = timestamp with time zone '2006-02-01
05:00:00-00';

-- returns inserted row.

select * from test where mytime = time with time zone '05:00:00-00';

-- nothing returned.

select timestamp with time zone '2006-02-01 05:00:00-00';

-- timestamptz
------------------------
-- 2006-02-01 00:00:00-05
--(1 row)

select time with time zone '05:00:00-00';
-- timetz
-------------
-- 05:00:00+00 This should be '00:00:00-05'
--(1 row)