Postgres Pro
Downloads
Home   >   mailing lists

how to emulate a simple case of a view on unions - Mailing list pgsql-general

From Martin Weinberg
Subject how to emulate a simple case of a view on unions
Date
Msg-id 199909220159.VAA13479@osprey.astro.umass.edu
Whole thread Raw
Responses Re: [GENERAL] how to emulate a simple case of a view on unions  (Charles Tassell <ctassell@isn.net>)
List pgsql-general
Tree view 
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@astro.umass.edu
University of Massachusetts         http://www.astro.umass.edu/~weinberg/
Amherst, MA  01003-4525

pgsql-general by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [GENERAL] Mirror non-friendly site???
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Mirror non-friendly site???