Re: Strange interaction of union and expressions

On Apr 20, 2005, at 1:24 PM, Aaron Bingham wrote:
> create table a (foo varchar);
> insert into a (foo) values ('baz');
> create table b (foo varchar);
> insert into b (foo) values ('woof');
> select '"' || foo || '"' as foo
>     from (select foo from a) as bar
>         union select foo from b;
>

No, it's doing what you asked.

You mean:

select '"' || foo || '"' from (select foo from a union select foo from
b) as subq;

Right?

-Kevin