Hi everybody, I could not find any information on the passing arrays to the dblink remote call. By now I am using something like: select t.r from dblink( connection_name, 'select r from remote_stored_procedure( ARRAY[' || array_to_string( my_id_array, ',' ) || '] )' ) as t(r text); The construct works, but actually I want to be sure, that it will work even for arrays as long as 50000 values. And I do not know what is the limitation on the statement text size, when we pass it to the dblink call! Is there any better way to call a remote procedure that needs a large integer array as a parameter? If not, does dblink team suppose making dblink aware of remote call parameters? With best regards, Valentine Gogichashvili
