I see no problem. You get what you want.
Correct query is:
select '"' || foo || '"' as foo
from (select foo from a union select foo from b ) as bar;
Oleg
On Wed, 20 Apr 2005, Aaron Bingham wrote:
Hello all,
We noticed some very odd behavior today with Postgres 7.4.5
Running the following SQL:
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;
Produces this output:
foo
-------
"baz"
woof
(2 rows)
I would expect the following instead:
foo
-------
"baz"
"woof"
(2 rows)
Is this a known issue? Has it been fixed?
Thanks,
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@xxxxxxxxxx, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
