PostgreSQL: Getting result of a function in a single column in PostgreSQL -


trying display result in form of table different columns, getting result in single column.

--my function

create or replace function test1()        returns table ( "fname" varchar(20),"lname" varchar(20),"a-b" bigint,"c-d" bigint, "e-f" bigint )     $body$   begin   return query   select tb."fname",tb."lname",count(tb."city"='a-b' or null) "a-b",      count(tb."city"='c-d' or null) "c-d",      count(tb."city"='e-f' or null) "e-f"   "table1" tb      tb."city" in ('a-b','c-d','e-f')     group 1,2   order 1,2;     end   $body$   language plpgsql;   

in instead of

select test1() 

do

select * test1() 

Comments

Popular posts from this blog

Android layout hidden on keyboard show -

google app engine - 403 Forbidden POST - Flask WTForms -

c - Why would PK11_GenerateRandom() return an error -8023? -