I'm new to PostgreSQL. Using version 8.4.1.
Why doesn't this query work?
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),
SELECT date FROM user_persistent_authentication WHERE date < now();
Is there another way I have to compare date/times?
ERROR: operator does not exist: time with time zone > timestamp with time zone