How to pass TEXT Array [ ] to a postgres function?

Question

I have this function which has been translated from oracle to postgres:

CREATE OR REPLACE FUNCTION myblah ( values TEXT[], evalues TEXT[], p_pid bigint, c_id bigint, pr_id bigint, p_name TEXT, p_use text default 'N') 
RETURNS VOID
AS $body$

and I am trying to call this function in order to test. But I am having issue inserting the array parameter, unsure of the syntax and cannot find anything to show me.

for example I am trying this but it is not acceptable syntax:

select myblah (TEXT['hello','whynot','jasmine'], 43423, 434234,534534,'fggffgfg','N');

the error is

ERROR:  syntax error at or near ","
LINE 1: select myblah(TEXT['hello','whynot','jasmin...

however removing the ',' does not work

user330315 · Accepted Answer · 2020-12-18 16:29:06Z

3

You need the array keyword:

select myblah (array['hello','whynot','jasmine'], 43423, 434234,534534,'fggffgfg','N');

answered Dec 18, 2020 at 16:29

user330315

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

Comments

Laurenz Albe · Accepted Answer · 2020-12-18 16:30:12Z

1

As the documentation will tell you, there are two options:

'{string 1,string 2}'

or

ARRAY['string1', 'string 2']

answered Dec 18, 2020 at 16:30

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Collectives™ on Stack Overflow

How to pass TEXT Array [ ] to a postgres function?

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