UNIONS

Is this a bug or have I just not noticed a nuance with SQL

Assume I have create the two tables

create table foo (
id int4,
);

create table foo_child (
name text
) inherits (foo);

If I do

select id, name from foo_child union select id, null as name from foo;
it works

select id, null as text from foo union select id, name from foo_child;
fails with

unable to trasform {insert whatever type here} into unknown
Each UNION | EXCEPT | INTERSECT clause must have compatible target
types

If this isn't a bug, it would be nice to be a nice feature to be able to
coax a data type into an 'unknown' field...

I know it would make my life easier... :)

- Thomas Swan
- Graduate Student - Computer Science
- The University of Mississippi
-
- "People can be categorized into two fundamental
- groups, those that divide people into two groups
- and those that don't."-