Call function of integer[] with single integer

Question

I have the floowing function signature in PostgreSQL:

func1(plist integer[])

i want to send this function an intager variable. basicly make a call:

select * from func1(var_integer)

How can I do that? It expect integer[] not integer. Is there some sort of conversion?

Edit:

when I do: select * from func1(var_integer::integer[])

I get:

cannot cast type integer to integer[]

Elad · Accepted Answer · 2017-09-17 07:44:33Z

1

Try:

select * from func1(array_agg(var_integer))

The function array_agg(expression) returns array of the argument type. Thus if var_integer is of type integer the result type of array_agg(var_integer) is integer[]

answered Sep 17, 2017 at 7:44

Elad

8945 silver badges15 bronze badges

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

Comments

Craig Ringer · Accepted Answer · 2017-09-17 11:09:14Z

1

There's no need for array_agg here, and it won't work in more complex contexts.

Use the array constructor syntax.

select * from func1(ARRAY[var_integer])

answered Sep 17, 2017 at 11:09

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

Collectives™ on Stack Overflow

Call function of integer[] with single integer

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related