I've hit a situation where I'm getting an unexpected set of results
from a cross
join that I've narrowed down to a table alias.
If I do (a has 4 rows, b has 1 row)
select a.field1, b.*
from a as maintable
cross join b
I get 16 rows returned. Is this expected behaviour or should an error
have been raised with the a. reference in the field list? postgres
7.2.3 on linux. (mssql and ingres both raise an error)
klint.