Strange interaction of union and expressions - Mailing list pgsql-general

From Aaron Bingham
Subject Strange interaction of union and expressions
Date
Msg-id l8d5spjr9j.fsf@lynx.cenix-bioscience.com
Whole thread Raw
Responses Re: Strange interaction of union and expressions
Re: Strange interaction of union and expressions
Re: Strange interaction of union and expressions
List pgsql-general
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,

--
--------------------------------------------------------------------
Aaron Bingham
Software Engineer
Cenix BioScience GmbH
--------------------------------------------------------------------


pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Regular expression. How to disable ALL meta-character in a regular expression
Next
From: Aaron Bingham
Date:
Subject: Re: Strange interaction of union and expressions