Re: execute block like Firebird does

From: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: execute block like Firebird does
Date: 2018-02-11 16:41:43
Message-ID: 9fa5f7c2-b6ca-ccfd-fded-284359f973c4@gelassene-pferde.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 02/11/18 06:57, PegoraroF10 wrote:
> I know we could create a function but we have several hundred of these
> blocks running, so ... it would be a huge work to do.
> So, there is a way to run a dynamic sql which returns a set of records ?

But don't you need to touch the code of those blocks anyway? Could you
write automating code to prepend the function header?

--
+49 (0)1578-772 37 37
+41 (0)78 947 36 21
SIP/iptel.org: thiemo.kellner
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/lookup?op=get&search=0xCA167FB0E717AFFC

Attachment Content-Type Size
thiemo.vcf text/x-vcard 693 bytes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2018-02-11 17:16:53 Re: New Copy Formats - avro/orc/parquet
Previous Message Fabrízio de Royes Mello 2018-02-11 16:23:29 Re: execute block like Firebird does