On Sat, 16 Jul 2005, [ISO-8859-2] Ji Nmec wrote:
> There's a problem with PostgreSQL 8.0.3 SELECT. All tables exist, all
> columns exist, I have no idea where's the problem :/ PostgreSQL
> reports this error: ERROR: relation "fieldx" does not exist...
>
> SELECT fieldx.field_id, COUNT(optionx.option_id) AS field_options
> FROM c_custom_fields AS fieldx, j_product_groups_fields AS join_table
> LEFT JOIN c_custom_fields_options AS optionx ON optionx.field_id = fieldx.field_id
Our reading of the spec is that fieldx is not in scope for that left
join's on condition since effectively join has higher precedence than
comma separating items in the from list.