On Tue, May 27, 2008 at 9:43 AM, Bill Oliver <bill.oliver@...> wrote:

> My co-worker wonders why we check this case? It seems that MySQL and
> Oracle let you create the view fine. Is this an Firebird

> SQL> CREATE VIEW V2 AS SELECT AVG(X) FROM T1;
> Statement failed, SQLSTATE = 42000
> Dynamic SQL Error
> -SQL error code = -607
> -Invalid command
> -must specify column name for view select expression
> SQL>

On oracle I get this:

ORA-00998: must name this expression with a column alias


--
Saludos,
PP