[Plproxy-users] Bug-report: RUN ON cannot take an integer, but only a function

[Igor Katson]

Greetings,

while having a conversation with Asko Oja, we have figured out, that the
following bug takes place. If we have a function similar to:

CREATE OR REPLACE FUNCTION test (argument1 int) RETURNS void AS $$
CLUSTER 'clustername';
RUN ON $1 -- or RUN ON argument1;
$$ language plproxy;

it does not work, and produces a syntax error, though RUN ON should
accept an integer. Consider the difference beetween
1899740818 and hastext(text) to understand. There is no difference in
the output, but there is one in the way this output was produces.

As a workaround, e.g coalsce($1) or coalesce(argument1) can be used,
which are actually the same in the result, but come from a function, and
not from an argument directly.

Best regards,
Igor Katson.