PostgreSQL: Convert array-to-string, with delimiter

Question

Consider I have a function like (but the following does not work):

CREATE FUNCTION func(VARIADIC params character varying[]) 
RETURNS type1 AS
$BODY$
   SELECT * FROM func2('id', array_to_string($1,'###’)
$BODY$
LANGUAGE sql VOLATILE;

The signature of func2 is:

 func2(character varying, character varying)

Thus, what I am trying to do is convert the array from “func” into a long string that is delimited by say the characters “###”. I then want to pass the entire string as the second argument of func2.

What error do you get; or if no error, how does it "not work"? — araqnid
– araqnid, Commented Feb 7, 2012 at 15:40
You're missing a close-bracket and the single quote after '###' is a non-standard character rather than a regular quote. — araqnid
– araqnid, Commented Feb 7, 2012 at 15:56
Thanks so much... actually the problem was just the missing bracket. The quote is just when copy-pasting to stackoverflow editor. — Larry
– Larry, Commented Feb 7, 2012 at 16:05
BTW, the VARIADIC keyword does not make sense in your example. If there isn't more to it, just drop it. — Erwin Brandstetter
– Erwin Brandstetter, Commented Feb 8, 2012 at 11:18

Larry · Accepted Answer · 2013-03-18 14:29:36Z

2

Just to make clear, the answer to the above question is as follows:

CREATE FUNCTION func(VARIADIC params character varying[]) 
RETURNS type1 AS
$BODY$
   SELECT * FROM func2('id', array_to_string($1,'###’))
$BODY$
LANGUAGE sql VOLATILE;

answered Mar 18, 2013 at 14:29

Larry

12k15 gold badges64 silver badges86 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL: Convert array-to-string, with delimiter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related