pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedValues like ''
3+ messages / 3 participants
[nested] [flat]
* Values like ''
@ 2003-12-05 19:18 Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
0 siblings, 2 replies; 3+ messages in thread
From: Elielson Fontanezi @ 2003-12-05 19:18 UTC (permalink / raw)
To: pgsql-sql
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
----------------( )----------( )--------------------
\ ( ) /
\_/ \_/
Attachments:
Notebook.jpg (image/jpeg, 2.9K) download
view image
* Re: Values like ''
@ 2003-12-09 19:49 Peter Eisentraut <peter_e@gmx.net>
parent: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Eisentraut @ 2003-12-09 19:49 UTC (permalink / raw)
To: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>; pgsql-sql
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".
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Values like ''
@ 2003-12-09 21:51 Stephan Szabo <sszabo@megazone.bigpanda.com>
parent: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
1 sibling, 0 replies; 3+ messages in thread
From: Stephan Szabo @ 2003-12-09 21:51 UTC (permalink / raw)
To: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>; +Cc: 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-12-09 21:51 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-12-05 19:18 Values like '' Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
2003-12-09 19:49 ` Peter Eisentraut <peter_e@gmx.net>
2003-12-09 21:51 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox