Re: AW: Re: MySQL and BerkleyDB (fwd) - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: AW: Re: MySQL and BerkleyDB (fwd)
Date
Msg-id 3A6CAFCB.DA142A1F@tm.ee
Whole thread Raw
In response to Re: AW: Re: MySQL and BerkleyDB (fwd)  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
The Hermit Hacker wrote:
> 
> sounds like something that should be handled at the application level
> though ... at least the concept of 'access to other db manufacturers' ...
> no?

If and when we will get functions that can return rowsets (IIRC Oracle's 
RETURN AND CONTINUE)the simplest case can be easily implemented by
having 
a user-defined method that just does the query for the whole table (or 
for rows where "field in (x,y,z)"

Then putting this in a view and then using it as a table should also 
be quite simple (or at least possible ;).

Only after that should we start optimizing ...

--------------
Hannu


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: AW: like and optimization
Next
From: Peter Mount
Date:
Subject: Re: FW: Postgresql on win32