Re: pg7.3.4: pg_atoi: zero-length string

Поиск
Список
Период
Сортировка
От Rob Fielding
Тема Re: pg7.3.4: pg_atoi: zero-length string
Дата
Msg-id 3FA7996E.9020705@dsvr.net
обсуждение исходный текст
Ответ на Re: pg7.3.4: pg_atoi: zero-length string  (Andrew Sullivan <andrew@libertyrms.info>)
Ответы Re: pg7.3.4: pg_atoi: zero-length string
Re: pg7.3.4: pg_atoi: zero-length string
Список pgsql-general

Andrew Sullivan wrote:
> On Tue, Nov 04, 2003 at 11:21:35AM +0000, Rob Fielding wrote:
>
>>
>>Hi,
>>
>>We're currently experiencing a problem where SQL statements are failing
>>when entring a '' for not not-null integer columns:
>
>
> Yes.  This behaviour was made more compliant in 7.3.  It's in the
> release notes.
>
>
>>The above example in just one case where 'aid' can accept a null value.

I've found this is a feature of 7.3 to not treat a empty string as a
NULL integer type. Silly lazy me ;)

As it turned out it relatively trivial to fix the offending statements
on the few occasions where it has been valid to do this.

Consider this a non-issue.


Cheers,

--

Rob Fielding
Development
Designer Servers Ltd


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

Предыдущее
От: Victor Spång Arthursson
Дата:
Сообщение: Very strange selectproblem
Следующее
От: Csaba Nagy
Дата:
Сообщение: Re: Very strange selectproblem