On Tue, Dec 14, 2010 at 7:17 PM, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
> You can cross query a schema but not a database.
>
> So you can create:
>
> create table fire.foo()
> create table ice.foo()
>
> And they are isolated from each other physically and logically but you
> can query them both:
>
> SELECT fire.*, ice.* join on (id)
Why would anyone in a random scenario want to have independent
schema's to cross query? I'm just trying to see how this would be
useful in any scenario.