Call table-returning function on each row in Postgres

Question

I have a table with an unknown amount of rows, let's say

-----
geom
-----
0123
3216
6549
...

And a function that returns table:

> select * from myFunc('line(1 2, 3 4, 5 6)'::geometry);
----------
val1 val2
----------
10   98
75   65

So I want to call this function for each row in the table above and union them. How do I do this?

Mike T · Accepted Answer · 2014-04-10 21:31:36Z

1

If myFunc is a set-returning function, you can move it from the FROM part to the SELECT part, while referencing each member of the set returning record type that you want.

SELECT the_table_with_geom.some_primary_key,
       (myFunc(geom)).val1, (myFunc(geom)).val2
FROM the_table_with_geom;

answered Apr 10, 2014 at 21:31

Mike T

44.3k18 gold badges166 silver badges213 bronze badges

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

Collectives™ on Stack Overflow

Call table-returning function on each row in Postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related