Hi All,

 

I wish to return an array of values. Assume, I have a table called contacts. I want to display all the names available from a column in the UI. Hence I need to return that column as an array of values. Please correct me if there is any other solution exist.

 

Here is the code, I’m trying to execute:

 

CREATE OR REPLACE FUNCTION get_all_names()

RETURNS TEXT[] AS '

DECLARE

group_data TEXT[];

BEGIN

--SELECT display_name INTO group_data FROM contacts;

RETURN group_data;

END;

'LANGUAGE 'plpgsql';

 

During compilation, I got the below error:

 

ERROR:  array value must start with "{" or dimension information

CONTEXT:  PL/pgSQL function "get_all_ names " line 4 at SQL statement

 

Regards,

Siva.