"Dennis" <[EMAIL PROTECTED]> writes: > I am trying to return an array from a function and don't seem to be having > luck.
Seems to work for me ... what PG version are you using? regression=# create function parseString() returns varchar[] as regression-# 'begin return \'{abc,def,ghi}\'; end' language plpgsql; CREATE FUNCTION regression=# select parseString(); parsestring --------------- {abc,def,ghi} (1 row) regression=# create function foo() returns varchar as ' regression'# declare regression'# results varchar[]; regression'# tmpv varchar; regression'# begin regression'# results := parseString(); regression'# tmpv := results[1]; regression'# RAISE NOTICE '' tmpv = % '',tmpv; regression'# return tmpv; regression'# end' language plpgsql; CREATE FUNCTION regression=# select foo(); NOTICE: tmpv = abc foo ----- abc (1 row) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly