Re: Dblink vs calling a function that returns void - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Dblink vs calling a function that returns void
Date
Msg-id b42b73151003300924u4d192a8ao99b168e2d07b2702@mail.gmail.com
Whole thread Raw
In response to Re: Dblink vs calling a function that returns void  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Dblink vs calling a function that returns void
List pgsql-general
On Mon, Mar 29, 2010 at 12:12 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Boszormenyi Zoltan <zb@cybertec.at> writes:
>> I need to call a function via dblink that returns a void, i.e.
>> technically nothing.
>
> You're overthinking the problem.  Imagine void is just a datatype
> (which it is...)  This should work:

but it isn't! void returning functions may not be queried over the
binary protocol (why?), so if you used dblink w/void returning
functions, and dblink later supported binary results, your code would
break (i'm sure such a thing would be optional, but the point stands).

merlin

pgsql-general by date:

Previous
From: Joshua Berry
Date:
Subject: Re: User action accounting
Next
From: Mike Toews
Date:
Subject: Converting time interval to double precision of time unit