On Thu, Nov 21, 2002 at 17:30:10 +0100, David Pradier <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org