Postgres Pro
Downloads
Home   >   mailing lists

Re: Dynamic prepare possible in plpgsql? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Dynamic prepare possible in plpgsql?
Date
Msg-id 11208.1177980742@sss.pgh.pa.us
Whole thread Raw
In response to Dynamic prepare possible in plpgsql?  ("Collin Peters" <cadiolis@gmail.com>)
Responses Re: Dynamic prepare possible in plpgsql?  ("Collin Peters" <cadiolis@gmail.com>)
List pgsql-sql
Tree view 
"Collin Peters" <cadiolis@gmail.com> writes:
> Is it possible to have a dynamic PREPARE statement in plpgsql?

Well, you could use plpgsql's EXECUTE to run SQL PREPARE and EXECUTE
commands, but it seems awfully brute-force.  What do you really need
to accomplish here?
        regards, tom lane

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: "is not distinct from" syntax error?
Next
From: "Collin Peters"
Date:
Subject: Re: Dynamic prepare possible in plpgsql?