Обсуждение: Version 8.1

Hi,

I have this SQL working very well in 8.0:

{SELECT *, tabpes.cod, tabpes.nome
FROM fincli_pesaut
WHERE TRUE
AND id_cli = '001/12'
AND id_pes = tabpes.id}

Why don´t work in 8.1?
ERROR:  missing FROM-clause entry for table "tabpes"

[]s
Diego Ziquinatti

Diego wrote:
> Why don´t work in 8.1?

Because it is violating the SQL standard and 8.1 is stricter in that
regard.

> ERROR:  missing FROM-clause entry for table "tabpes"

So add that table to the FROM clause.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/