On Thu, Nov 21, 2002 at 17:30:10 +0100, David Pradier <dpradier@apartia.fr> wrote:
> Hi!
>
> I'm new on this list, my name is David Pradier, and i'm french.
>
> I'm currently trying the new postgresql 7.3rc1, and i've noticed that if
> i compared an integer to an empty string, i ran in an error.
>
> Is this a bug or a feature of the new 7.3 version ?
> Is there a purpose ?
What number do you expect '' to represent?
Probably you either want to use:
= '0'
or
is null
depending on what you are really trying to do.