Re: Date Data Type

Does the output not even include the column header? If it does, it
would seem your datebox column has nothing but NULLs in it. Can you
ever get it to provide values from the datebox column? If it does
*not* show, it would probably be necessary to have a copy of at least
part of the table in question.

Rgds,
-Al Arduengo

jillian(at)koskie(dot)com ("Jillian Carroll") writes:

> 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
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>

--
"Place your hand on a hot stove for a minute and it seems like
an hour. Sit with a pretty girl for an hour and it seems like a
minute. That's relativity." -Albert Einstein