Joe Conway <mail@joeconway.com> writes:
> Darko Prenosil wrote:
>> Unfortunately any other way ends up with first selecting *ALL* records from
>> host ! If there is no such limitation I'll be pretty satisfied with dblink,
>> and will newer ask for "cross-db-queries" again !!!
> Yeah, this is why a proper implementation following the spec is needed.
> If the external access was part of the backend, then the planner could
> be taught to push down qualifiers to the external source where
> appropriate (I think -- maybe Tom will comment on this).
Yes, the newer version of SQL-MED has APIs that allow this sort of thing
to be done. Of course, it's another huge chunk of work beyond basic
SQL-MED ... but at least the roadmap is there, and when we get to the
end of the road we might even find other DBMSes that can speak the same
language. If we invent our own spec the chance of handling cross-DBMS
queries intelligently is nil :-(
regards, tom lane