Re: [SQL] Values like ''

2003-12-09 Thread Stephan Szabo
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. -

Re: [SQL] Values like ''

2003-12-09 Thread Peter Eisentraut
Elielson Fontanezi wrote: > Why does the following query work on pgsql 7.2.3 and not in pgsql > 7.3.4? Please be more detailed on your idea of "works" and "does not work". ---(end of broadcast)--- TIP 7: don't forget to increase your free space

[SQL] Values like ''

2003-12-09 Thread Elielson Fontanezi
Hi folks!       Why does the following query work on pgsql 7.2.3 and not in pgsql 7.3.4?   SELECT cronograma_evento.nr_projeto ,cronograma_evento.dt_inic   ,cronograma_evento.nr_sala ,cronograma_evento.tm_hora_inicial   ,cronograma_evento.tm_hora_final ,cronograma_evento.cd_turma   ,cro