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

From Tom Lane
Subject Re: Dblink vs calling a function that returns void
Date
Msg-id 14708.1269879156@sss.pgh.pa.us
Whole thread Raw
In response to Dblink vs calling a function that returns void  (Boszormenyi Zoltan <zb@cybertec.at>)
Responses Re: Dblink vs calling a function that returns void  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
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:

select * from public.dblink('import', 'SELECT import.add_one_word(''word'', true)') as x(x void);

            regards, tom lane

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: help
Next
From: Pavel Stehule
Date:
Subject: Re: Splitting text column tomultiple rows