Date Data Type - Mailing list pgsql-general

From Jillian Carroll
Subject Date Data Type
Date
Msg-id DCEBJACNIMLDFIOHMAJCAEEBCIAA.jillian@koskie.com
Whole thread Raw
In response to Re: database backup  (Curt Sampson <cjs@cynic.net>)
List pgsql-general
I have a database upon which I am trying to do the following query:

select newsitem, category, link, datebox
from news_tbl
order by entered desc

It is very straightforward.  Newsitem, Category and Link are all text data
types and datebox is date data type.

The query only works when datebox is not included.

I am running Postgres 7.2 on Redhad 7.2.

Is there a problem with the date data type?

--
Jillian




pgsql-general by date:

Previous
From: Curt Sampson
Date:
Subject: Re: database backup
Next
From: Bruce Momjian
Date:
Subject: Re: database backup