sql - PostgreSQL outputs table formatted as array instead of table -


i experimenting functions in postgresql, , got working fine, there confusing. have header of function:

        create or replace function p.getevents(date)          returns table (when date,  participant varchar, helper varchar)          $$         begin             (....) 

and thought going return table (hence return table!) this:

when    |    participant    |    helper --------+-------------------+-----------         |                   | 

but instead returning me results looking array, such as:

(2015-03-21, participant, helper) (2015-04-10, participant, helper) 

isn't returns table right way build table output? how can force output table , not comma separated values?

use

select * getevent(current_date); 

because

select getevent(current_date); 

returns rows 1 column of pseudotype record.


Comments

Popular posts from this blog

angularjs - ADAL JS Angular- WebAPI add a new role claim to the token -

php - CakePHP HttpSockets send array of paramms -

node.js - Using Node without global install -