Postgres Pro
Downloads
Home   >   mailing lists

Re: Values like '' - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Values like ''
Date
Msg-id 20031209134923.D66223@megazone.bigpanda.com
Whole thread Raw
In response to Values like ''  (Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Faster performance when using where cust_id = '123' vs cust_id = 123. Does 7.4 fix this??
Next
From: Paul Thomas
Date:
Subject: Re: Fetch a single record