On 02/08/07, Darren Duncan <[EMAIL PROTECTED]> wrote: > > What do you think would be the most common scenarios of a cross-database > query?
Speaking only theoretically for now but one "use case" I can vaguely imagine would be something we are working on right now: We have a large SQL Server database with many individual records and we are now building a PostgresQL 8.1 database on another machine to contain statistics about these records (e.g. for each hour in the life of the database, how many records of each type were created or updated). One is derived from the other and contains aggregates of records but maybe when we'll get the web interface to dig the stats database we might want to be able to say "list all records in the main db which were counted by a particular record in the stats DB". HTH, --Amos
