Re: Error when comparing an integer to an empty string.

Поиск
Список
Период
Сортировка
От David Pradier
Тема Re: Error when comparing an integer to an empty string.
Дата
Msg-id 20021122090242.GA27817@apartia.fr
обсуждение исходный текст
Ответ на Re: Error when comparing an integer to an empty string.  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-hackers
> > 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.

It's because it comes from a perl building of the request.
Typically : '$youpee'
When $youpee is undef, it's no problem in 7.2, and the request returns
false.
Now it raises an error.
(Ok, i've understood it was on purpose ; i give these info only for the
background :-)

Best regards,
David

-- 
dpradier@apartia.fr


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Fw: Missing file from CVS?
Следующее
От: Masaru Sugawara
Дата:
Сообщение: connectby with schema