Reformat output of PostgreSQL function data [duplicate]

Question

I have created following function in PostgreSQL database

CREATE or REPLACE FUNCTION getSR15ReportData(value text) 
RETURNS  TABLE(
    userid integer,
    username varchar(50)
) AS -- text AS --
$body$
DECLARE
    fullsql TEXT;
    records RECORD;
    exeQuery TEXT;
BEGIN

fullsql:= 'SELECT userid, username from user_index where status='''value'''';

exeQuery := 'SELECT * FROM (' || fullsql || ') AS records';

RETURN QUERY EXECUTE exeQuery;

END
$body$
LANGUAGE plpgsql;

It's giving me output as follow:

getdate
--------------
501,alexanda
502,cathie

But I need output like:

userid  username
------|---------
501,alexanda
502,cathie

seems he separated the questions but still references the reformatting of the output in his other question. — Zerkz
– Zerkz, Commented Dec 18, 2013 at 15:55

Community · Accepted Answer · 2017-05-23 10:32:19Z

0

I was silly about this question. It was so simple. Thanks a_horse_with_no_name. He has solved this on my another question Get data from PostgreSQL function to java

Just need to call the function:

SELECT * FROM getdata('active')

The full query will look like:

SELECT usr.username 
FROM cust_invoice_index as inv
 JOIN (SELECT * FROM getdata('active')) as usr ON usr.userid=inv.userid_edit

edited May 23, 2017 at 10:32

CommunityBot

11 silver badge

answered Dec 18, 2013 at 16:07

ray

4,27011 gold badges38 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

Reformat output of PostgreSQL function data [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related