Postgres Pro
Downloads
Home   >   mailing lists

Re: PREPARE dynamic SQL in plpgsql - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: PREPARE dynamic SQL in plpgsql
Date
Msg-id CAKFQuwbvT7TiE11sXrigumr-6mNO18vGw38DPMYwF5Mrwz-WDQ@mail.gmail.com
Whole thread Raw
In response to PREPARE dynamic SQL in plpgsql  (Koichi Suzuki <koichi.szk@gmail.com>)
List pgsql-hackers
Tree view
On Fri, Mar 11, 2016 at 4:45 PM, Koichi Suzuki <koichi.szk@gmail.com> wrote:
Hi,

Does someone know how to prepare a synamic SQL statement in plpgsql?

All the examples, PG documents describe only about preparing static SQL statement.


This is not an appropriate question for the -hackers list.  It is better asked on either -general or, more correctly, -novice.

It is also somewhat lacking in detail - including an example of what you've tried or read would be a nice touch.
​
David J.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Perl's newSViv() versus 64-bit ints?
Next
From: Jim Nasby
Date:
Subject: Re: Relation extension scalability