How to send values to a postgres function?

Question

I have a function with parameters of numerical type, I have done the query successfully, my problems is that I do not know how to pass several parameters within the IN, where id in(parameter). The id is of type BIGINT

From JAVA I have the following query:

select parametro1, parametro2, parametro3 from function_detalls ("parameters");

Where parameters is a string type 1,2,3,4,5,6,7, ....

My question is how can I pass this type of parameter to the function?

J Spratt · Accepted Answer · 2019-04-08 20:48:03Z

2

Pass an array to your function and use WHERE = ANY().

For example:

CREATE FUNCTION func_test(params text[])
RETURNS SETOF test
LANGUAGE PLPGSQL
AS $$
DECLARE
BEGIN
    RETURN QUERY
    SELECT * FROM test WHERE txt = ANY(params);
END;
$$

To call:

SELECT * FROM func_test(ARRAY['hello', 'world']);

DBFiddle to show it in action

answered Apr 8, 2019 at 20:48

J Spratt

2,0521 gold badge16 silver badges24 bronze badges

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

1 Comment

Maicoly Morocho Over a year ago

@J Spratt I lost a bit in your answer, the parameters to send is always volatile, that is, the size varies, as I do with an array of 1000?

Collectives™ on Stack Overflow

How to send values to a postgres function?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related