why postgres functions returns result in one column?

Question

I have a simple PostgreSQL function which I aspect should return values into separate columns -115 and 101000005458E6258... but it returns one column where two values are separated by a comma -115,101000005458E6258.... What is wrong with my function?

CREATE OR REPLACE FUNCTION public.get_direction()
RETURNS TABLE(direction integer, geom geometry)             
AS $$
BEGIN
RETURN QUERY SELECT 
    heading-lag(heading) over (order by time) AS direction, a.geom AS geom 
    FROM public.mytable a 
    WHERE reg='125123' 
    GROUP BY heading, a.geom , a.time;
END; $$
LANGUAGE 'plpgsql';

I call the function

SELECT public.get_direction();

Thank you.

And you should call it like this: `select * from get_direction();`. — freakish, Jun 25 '20 at 14:10
It is a table function, so it should be used like a table in an SQL statement. — Laurenz Albe, Jun 25 '20 at 14:15

score 7 · Accepted Answer · answered Jun 25 '20 at 14:11

7

If you want the result as a set of columns, then you need:

SELECT * FROM public.get_direction();

answered Jun 25 '20 at 14:11

GMB

216,147
25
84
135

why postgres functions returns result in one column?

1 Answers1