Yes, it is...It is so intelligent, you don't have to be... It does
the work you should do. It creates names automatically.

And then, you can have a bunch of "SHOW CREATE TABLE", and other
tools to find out the names of those auto-created columns....

SanTa

--- In firebird-support@yahoogroups.com, "Bill Oliver"
<bill.oliver@...> wrote:

>
> With MySQL, at least, they auto name the columns...
>
> mysql> CREATE VIEW V3 AS SELECT AVG(X), avg(x), avg(x) FROM T1;
> Query OK, 0 rows affected (0.00 sec)
>
>
> mysql> select * from v3;
> +--------+---------------+-----------------+
> | AVG(X) | My_exp_avg(x) | My_exp_1_avg(x) |
> +--------+---------------+-----------------+
> | NULL | NULL | NULL |
> +--------+---------------+-----------------+
> 1 row in set (0.00 sec)
>
>
> --- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@>
> wrote:
> >
> > Bill Oliver wrote:
> >
> > > My co-worker wonders why we check this case? It seems that

MySQL and

> > > Oracle let you create the view fine.
> >
> > I'm wondering what name do they assign to the view column? X?

AVG?

> > Something auto-generated? What if the sample would be a bit more
> > complicated, containing duplicated fields/expressions?
> >
> >
> > Dmitry
> >
>