Re: SELECT from multiple tables (not join though) - Mailing list pgsql-general

On Mon, Jan 10, 2005 at 12:47:53 -0500,
  Madison Kelly <linux@alteeve.com> wrote:
>
> The trick now is I need to know which table each result came from. I can
> add another column and record the table number and SELECT that at the
> same time but before I do I was wondering if I can do this more
> efficiently or elegantly.

You can add a constant to the select list in each of the subselects
that indicates which table is being used.