On Sun, 10 Jan 2010 10:49:48 +0100
Vincenzo Romano wrote:
> Try using inheritance.
One of the things I didn't mention is: I've to join these tables
with other tables that may or may not (public) belong to the same
schema.
select sum(i.qty) from s1.list_items li
join public.item i on i.itemid=
Try using inheritance.
Il giorno 10 gen, 2010 2:30 m., "Ivan Sergio Borgonovo" <
m...@webthatworks.it> ha scritto:
I've tables in different schemas all with the same name and
structure.
I'd like to compute an aggregate on the union of those tables.
I don't know the schemas in advance.
The list of
