Re: view creation question

From: Alban Hertroys <alban(at)magproductions(dot)nl>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Larry White <ljw1001(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: view creation question
Date: 2006-03-09 17:01:41
Message-ID: 44105F75.8020802@magproductions.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)magproductions(dot)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 //

In response to

Browse pgsql-general by date

  From Date Subject
Next Message gkoskenmaki 2006-03-09 17:21:45 ExtenDB
Previous Message Mongi LASSOUED 2006-03-09 16:31:07 posgresql server connection