PostgreSQL: Simple compare of date/times not wokring.

[Refringe]

I'm new to PostgreSQL. Using version 8.4.1.

CREATE TABLE user_persistent_authentication
(
  token character(128) NOT NULL,
  user_id bigint NOT NULL,
  date time with time zone NOT NULL DEFAULT now(),
  active boolean NOT NULL DEFAULT true,
  CONSTRAINT primary_key_user_persistent_authentication PRIMARY KEY (token),
)

Why doesn't this query work?

SELECT date FROM user_persistent_authentication WHERE date < now();

ERROR:  operator does not exist: time with time zone > timestamp with time zone

Is there another way I have to compare date/times?

[r937]

instead of TIME WITH TIME ZONE, maybe you want TIMESTAMP WITH TIME ZONE

note that the now() function returns TIMESTAMP WITH TIME ZONE

[Refringe]

I think I understand. You can't compare the two different datetime types.

Is there a PostgreSQL function that returns the current datetime as a TIME WITH TIME ZONE so it can be compared to my stored 'date' TIME WITH TIME ZONE?

[Refringe]

It seams this is what CURRENT_TIME is used for.
Thank you for your help.