Re: view creation question - Mailing list pgsql-general

Richard Huxton wrote:
> Larry White wrote:
>
> SELECT * FROM Tasks
> UNION ALL
> SELECT * FROM Issues;

In case you care about where a record originated from:

SELECT *, 'Tasks' AS source FROM Tasks
UNION ALL
SELECT *, 'Issues' AS source FROM Issues;

Regards,
--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
    7500 AK Enschede

// Integrate Your World //