Hello All-

I need to extract a result from a postgres database and PHP.
I need to get everything greater than today's date.
I'm comparing it against a timestamp field that can have something like
'2006-12-30 05:47:35.089-05' or NULL.
Basically:
SELECT * from table_name
WHERE timestamp_field is >= today

I want the NULL values in the result set as well...

Thanks in advance

ZMAN

ZMAN wrote:
> Hello All-
>
> I need to extract a result from a postgres database and PHP.
> I need to get everything greater than today's date.
> I'm comparing it against a timestamp field that can have something
> like '2006-12-30 05:47:35.089-05' or NULL.
> Basically:
> SELECT * from table_name
> WHERE timestamp_field is >= today
>
> I want the NULL values in the result set as well...
>

Euhm, not sure about postgres, in MySQL this works:
WHERE timestamp_field >= NOW() OR timestamp_field IS NULL
--
Rik Wasmus

Post removed (X-No-Archive: yes)

"Rik" <luiheidsgoeroe [at] hotmail.com> wrote in message
news:2f214$45a74d46$8259c69c$7798 [at] news2.tudelft.nl...
> ZMAN wrote:
>> Hello All-
>>
>> I need to extract a result from a postgres database and PHP.
>> I need to get everything greater than today's date.
>> I'm comparing it against a timestamp field that can have something
>> like '2006-12-30 05:47:35.089-05' or NULL.
>> Basically:
>> SELECT * from table_name
>> WHERE timestamp_field is >= today
>>
>> I want the NULL values in the result set as well...
>>
>
> Euhm, not sure about postgres, in MySQL this works:
> WHERE timestamp_field >= NOW() OR timestamp_field IS NULL
> --
> Rik Wasmus
>
>

Thank you for your response. Stupid me, its "IS" NULL I was doing =
NULL.
It works great thanks very much!!