Re: dblink syntax question for remotely invoking void-returning procedures - Mailing list pgsql-general

From Merlin Moncure
Subject Re: dblink syntax question for remotely invoking void-returning procedures
Date
Msg-id b42b73150901260607i16e213b7k308178f22500f1a9@mail.gmail.com
Whole thread Raw
In response to dblink syntax question for remotely invoking void-returning procedures  (Ian Sollars <ian.sollars@gmail.com>)
Responses Re: dblink syntax question for remotely invoking void-returning procedures  (Asko Oja <ascoja@gmail.com>)
List pgsql-general
On 1/24/09, Ian Sollars <ian.sollars@gmail.com> wrote:
> Hello everyone,
>
> I've got some questions about dblink that I couldn't find answers to in the
> documentation. Any help would be much appreciated.
>
> I need to invoke a function on a remote server that returns either void or
> text, and I'm trying to find a nice way of doing it.
>

did you try this?
perform * from dblink('test', 'select inserttest()') as t1(test text);

Anyways, I never write void returning functions.  Another problem with
them (for example) is that they can't be called using the binary query
protocol.  These are minor nits since the workaround is easy.

merlin

pgsql-general by date:

Previous
From: Filip Rembiałkowski
Date:
Subject: Re: where (x,y,z) in ((x1,y1, z1), (x1,y1, z1), (x1,y1, z1), (x2,y2, z2)) (not) optimized
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: where (x,y,z) in ((x1,y1, z1), (x1,y1, z1), (x1,y1, z1), (x2,y2, z2)) (not) optimized