At 12:27 13/01/2006, you wrote:
Greetings!
Am I wrong or is it a real limitation of Ingres. Subselect does not work
when placed after FROM. Example:
CREATE TABLE X (Y INTEGER);
SELECT * FROM (SELECT * FROM X) AS YYY;
E_US0845 Table 'select' does not exist or is not owned by you.
Ingres does not (presently) support the use of select expressions in the
FROM clause. They are allowed in other (specified) places though. e.g. on
the right-hand side of comparison operators in the WHERE clause.
Every other database, even MySQL supports it.
It's no surprise that even something as trashy as MySQL can do it; it can't
be rocket science. I imagine the machinery to execute such a query is
already in Ingres; it is probably mainly a matter of extending the parser
to understand the syntax. I vaguely recall being told it's on the list of
things to do "real soon".
Roy Hann
www.rationalcommerce.com
_______________________________________________
Users mailing list
[email protected]
http://ingres.ca.com/mailman/listinfo/users
