Re: [GENERAL] R: aggregate over tables in different schema

2010-01-11 Thread Ivan Sergio Borgonovo
On Sun, 10 Jan 2010 10:49:48 +0100 Vincenzo Romano vincenzo.rom...@notorand.it 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

[GENERAL] R: aggregate over tables in different schema

2010-01-10 Thread Vincenzo Romano
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