Call stored procedure using method name in a variable in postgres

Question

The following Statement show error

EXECUTE quote_ident('Calculate' || calc_type_row."Name") || '($1,$2)' USING calc_type_row."IntervalTypeId",'Meter';

Name, IntervalTypeId are column in a table.

Pavel Stehule · Accepted Answer · 2015-06-22 09:19:57Z

3

The statement EXECUTE is expecting valid SQL statement - in this case SELECT statement. So you are missing SELECT keyword:

EXECUTE format ('SELECT %I($1, $2)', 'Calculate' || calc_type."Name") USING ...

answered Jun 22, 2015 at 9:19

Pavel Stehule

46.6k6 gold badges103 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1