[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: PHP: query with parameter for SET
From:       Ray O'Donnell <ray () rodonnell ! ie>
Date:       2021-07-27 17:26:05
Message-ID: 6b74789d-abc6-24e6-ccb7-ef638e6560db () rodonnell ! ie
[Download RAW message or body]

On 27/07/2021 18:20, Pavel Stehule wrote:
> When you use client side prepared statements, then it can be possible. 
> But I don't know how it works in PHP.
> 
> Server side prepared statements are not possible in this case. "set" 
> statement has not execution plan. But you   You can use Adrian's 
> proposal, and you can prepare the query 'select set_config($1, false)'

Thanks Pavel - that makes sense.

Ray.



-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie


[prev in list] [next in list] [prev in thread] [next in thread]