Re: Dblink vs calling a function that returns void

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Boszormenyi Zoltan <zb(at)cybertec(dot)at>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Dblink vs calling a function that returns void
Date: 2010-03-29 16:12:36
Message-ID: 14708.1269879156@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Boszormenyi Zoltan <zb(at)cybertec(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2010-03-29 16:14:32 Re: Splitting text column tomultiple rows
Previous Message Raymond O'Donnell 2010-03-29 16:12:02 Re: help