Postgres Pro
Downloads
Home   >   mailing lists

Thread: Values like ''

Values like ''

From
Elielson Fontanezi
Date:
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
  ,cronograma_evento.cd_discipl ,locais_sala.cd_tipo_sala
FROM
 cronograma_evento, locais_sala
WHERE
  cronograma_evento.dt_crono = '1/12/2003'

  AND cronograma_evento.cd_local = ''
 
  AND cronograma_evento.cd_local = locais_sala.cd_local
  AND cronograma_evento.nr_sala =  locais_sala.nr_sala
ORDER BY
  cronograma_evento.nr_sala,
  cronograma_evento.tm_hora_inicial;
 
 
 
                        >\\\!/<   55 11 5080 9258
                        !_"""_!   Elielson Fontanezi
                        (O) (o)   PRODAM
--------------------oOOO--(_)--OOOo-----------------------
              Success usually comes to those
              who are too busy to be looking for it.
                 oooo0          0oooo
----------------(    )----------(    )--------------------
                 \  (            )  /
                  \_/            \_/
Attachment

Re: Values like ''

From
Peter Eisentraut
Date:
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".

Re: Values like ''

From
Stephan Szabo
Date:
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.