Re: cast of integer to bool doesn't work (anymore?)

Поиск
Список
Период
Сортировка
От Achilleus Mantzios
Тема Re: cast of integer to bool doesn't work (anymore?)
Дата
Msg-id Pine.LNX.4.44.0303211717480.2751-100000@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на Re: cast of integer to bool doesn't work (anymore?)  (Eric Veldhuyzen <ericv@xs4all.net>)
Список pgsql-sql
On Fri, 21 Mar 2003, Eric Veldhuyzen wrote:

> On Fri, Mar 21, 2003 at 04:46:17PM -0200, Achilleus Mantzios wrote:
> > 
> > Currently (7.3) all input can be handled if fed as text.
> > So what you can do is simply:
> > 
> >  my $sth = $dbh->prepare(
> >      "INSERT INTO object_def (name, meant_as_subobject) VALUES (?,?)");
> >  $sth->execute('test', '0');
> 
> Ah, thanks, that seems to work, with only minor modifications to our
> code. Is there any reason why integers are no longer convertable to
> booleans?

There has been some general rectification on the casting system in 7.3.*.

> 
> 

-- 
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-210-8981112
fax:    +30-210-8981877
email:  achill@matrix.gatewaynet.com       mantzios@softlab.ece.ntua.gr



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: cast of integer to bool doesn't work (anymore?)
Следующее
От:
Дата:
Сообщение: Re: explain