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

[Chris Weiss]

yeah, they started actually adhering to datatype conventions.... whoever
decided ''==0 in the first place should be shot.

Brian Johnson (address@hidden) wrote:
>
> The 'cause' is postgresl 7.3
>
> They decided to change how they handle empty fields in this version
>
>
>
> Thomas Viehmann (address@hidden) wrote:
> >
> >Hi.
> >
> >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.
> >This is not the problem. For some reason or other, a vast amount of
> >queries have '' when accessing integer fields in postgresql.
> >This also seems to affect 0.9.14, not sure what the cause is, though.
> >
> >Cheers
> >
> >T.
> >
>
>
>
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>