-------- Mensagem original --------
Assunto: Re: [Firebird-Architect] Re: RFC: Cross database queries
Data: Thu, 24 Jul 2008 22:27:38 -0300
De: Fabricio Araujo <fabricioaraujo_rj@...>
Para: Firebird-Architect@yahoogroups.com
Referências: <f8s5kv+2mjr@...>
<01b001c7d4e5$20535540$9902a8c0@martijnws>


Martijn Tonies wrote:

> > Well, first question - how does it look from SQL standard POV?
>
> AFAIK SQL stand. does not define external datasources nor external
> tables.
>
> AFAIK SQL:2003 defines only :
> <catalog>.<schema>

.<table>

>
> > With slightly modified (avoid '@' in favour of '.')
> I suggest also '.' instead of '@' like MS SQL for linked servers:
> <server>.<catalog>.<schema>.<table>
> (<datasource>..<table>)

.. <- the worst syntax I've ever seen.

I suggest that, if you have a higher level of syntax, you need to fill
on the lower ones. For example:

>>fb_mainserver.db_reports.default.customer_table

If you write fb_mainserver, you have to specify all the other levels. But:

>>security.app_rights

Means the schema security and table app_rights on the current database
on the actual server. You don't need to write the higher levels and is
equivalent
(considering we still are on database db_reports of fb_mainserver instance)
to

>>fb_mainserver.db_reports.security.app_rights

Just my 2 cents ;-)