Re: dblink syntax question for remotely invoking void-returning procedures

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Ian Sollars <ian(dot)sollars(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dblink syntax question for remotely invoking void-returning procedures
Date: 2009-01-26 14:07:24
Message-ID: b42b73150901260607i16e213b7k308178f22500f1a9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 1/24/09, Ian Sollars <ian(dot)sollars(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-01-26 14:12:11 Re: where (x,y,z) in ((x1,y1, z1), (x1,y1, z1), (x1,y1, z1), (x2,y2, z2)) (not) optimized
Previous Message Filip Rembiałkowski 2009-01-26 13:58:53 Re: where (x,y,z) in ((x1,y1, z1), (x1,y1, z1), (x1,y1, z1), (x2,y2, z2)) (not) optimized