Re: Date Data Type - Mailing list pgsql-general

From Al Arduengo
Subject Re: Date Data Type
Date
Msg-id 87y9cm9zzn.fsf@austin.rr.com
Whole thread Raw
In response to Date Data Type  ("Jillian Carroll" <jillian@koskie.com>)
List pgsql-general
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@koskie.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@postgresql.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

pgsql-general by date:

Previous
From: Lynn David Newton
Date:
Subject: Re: explicit cast error
Next
From: Herbert Liechti
Date:
Subject: Re: two primairy key in one table ?