Thanks guys, I appreciate the help.

I can enter a tracker if you think this is a feature we want to add
to Firebird in the future. I asked my co-worker about this, and he
put it in the category of "midly annoying". I guess you get used to a
certain database, and its sql dialect, and then when something is
missing it bugs you.

If you get used to something else to start with, you never notice the
missing feature. ;-)

-bill

--- In firebird-support@yahoogroups.com, "Sandor Tamas"
<sandortamas@...> wrote:

>
> 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
> > >
> >
>