|
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: Notebook.jpg>>
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
