Re: [Phpgroupware-developers] Patches for PostgreSQL??

[Dani Oderbolz]

Chris Weiss wrote:

> I'm not sure about the pg status, but in the plain ol' SQL '' != NULL.  Seems
> to me that pg doing somehting wrong, if you save '' it should not be null in
> the table, it should be an empty string.
>  
No, I am not talking about an insert.
I am talking about the fact that when you do
where id='' you are in fact comparing a number (id is int or something) to
a string ('' is a string). But Postgres cannot (or wouldnt) convert '' 
to a number.
Therefore, I am converting it to NULL, which is valid.

Regards,
Dani