Re: Values like ''

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Elielson Fontanezi <ElielsonF(at)prodam(dot)sp(dot)gov(dot)br>
Cc: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Values like ''
Date: 2003-12-09 21:51:19
Message-ID: 20031209134923.D66223@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, 5 Dec 2003, Elielson Fontanezi wrote:

> AND cronograma_evento.cd_local = ''

Is cd_local an integer type? If so, '' no longer works as an integer
(IIRC it used to mean 0). The exact error message and possibly schema
information would be useful if that's not what's going on.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Paul Thomas 2003-12-10 00:11:29 Re: Fetch a single record
Previous Message Peter Eisentraut 2003-12-09 21:45:46 Re: Faster performance when using where cust_id = '123' vs cust_id = 123. Does 7.4 fix this??