Stupid Monday Problem - Mailing list pgsql-sql

From Kenn Thompson
Subject Stupid Monday Problem
Date
Msg-id s8fae784.037@10.0.0.4
Whole thread Raw
Responses Re: Stupid Monday Problem
Re: Stupid Monday Problem
List pgsql-sql
Ok- here's the problem ( too little coffee?)...

This query runs under Access. I of course change a bit of the SQL ( removed the '#' and have played with quotes), but
can'tseem to get it to run.
 

What the #%$^& am I doing wrong here?

Kenn


SELECT oid FROM file_header WHERE expire_date < 04/16/00 
ADODB.Recordset.1 error '80004005' 

Error while executing the query; ERROR: Unable to identify an operator '<' for types 'date' and 'int4' You will have to
retypethis query using an explicit cast 
 






pgsql-sql by date:

Previous
From: "J.Post"
Date:
Subject: Connecting website with SQL-database.....
Next
From: Patrik Kudo
Date:
Subject: Re: Stupid Monday Problem