On 04/10/12 11:09 PM, Atri Sharma wrote:
>> why not just implement it as....
>> >
>> >user application -> SQL -> PLjava FDW functions -> pljava code -> JDBC
>> >-> foreign database
>> >
>> >(and of course, back to return the data from said foreign database)
>> >
> Hi John,
>
> Hmm.That sounds good,but where does the FDW come in?Will the user
> application interact with the FDW,and FDW handle the SQL calls and
> everything else from there i.e. FDW wraps the entire process,right?
see dblink ofr an example API
http://www.postgresql.org/docs/current/static/dblink.html
the 'pljava fdw functions' are the publicly visible pljava functions
implementing your api... while my 'pljava code' are additional
functions/methods you use internally that aren't visible externally
--
john r pierce N 37, W 122
santa cruz ca mid-left coast