how to emulate a simple case of a view on unions

From: Martin Weinberg <weinberg(at)osprey(dot)astro(dot)umass(dot)edu>
To: pgsql-general(at)hub(dot)org
Subject: how to emulate a simple case of a view on unions
Date: 1999-09-22 01:59:04
Message-ID: 199909220159.VAA13479@osprey.astro.umass.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I have four tables with identical fields and I would like
to automate the same query on each table and pool the
results.

Any suggestions on streamlining this?

Thanks!

--Martin

===========================================================================

Martin Weinberg Phone: (413) 545-3821
Dept. of Physics and Astronomy FAX: (413) 545-2117/0648
530 Graduate Research Tower weinberg(at)astro(dot)umass(dot)edu
University of Massachusetts http://www.astro.umass.edu/~weinberg/
Amherst, MA 01003-4525

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 1999-09-22 02:19:17 Re: [GENERAL] Mirror non-friendly site???
Previous Message The Hermit Hacker 1999-09-22 01:45:06 Re: [GENERAL] Mirror non-friendly site???