Tag Info

New answers tagged


You can pass one paramter for one Checkbox and set the default value of the paramter as NULL in Stored procedure. So for 5 checkbox you can go for 5 optional parameter, while executing stored procedure pass only those parameter for which checkbox is checked. Pass 2 parameter incase two checkbox is checked and so on. Now in stored procedure, you can handle ...


I think you might be looking for the USING clause: EXECUTE format('SELECT COALESCE(%I,col,$1) FROM public.TableMix WHERE name = $2', ruleName) USING (username, whateverTheSecondParameterIs); You use $1, $2, etc for placement-parameters, passed by USING. You use %I for itentifiers expanded by format. Update: If you want to ...

Top 50 recent answers are included