Michael Fuhr wrote:
You refer to shs.city.<column> in the select list, but in the from
clause you've aliased shs.city to city. As the SELECT documentation
says,
When an alias is provided, it completely hides the actual name
of the table or function; for example given FROM foo AS f, the
remainder of the SELECT must refer to this FROM item as f not foo.
Michael,
Thanks a lot for your very helpful answer (thanks to Stephan Szabo as
well). I've now changed my query as per your indications and indeed it
works ok.
Best regards,
Geert
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
