IT_info
IT_info

Reputation: 727

Return type of a procedure in plpgsql

I am using postgres with postgis and i have a table with geometry data. Now i would like to write a procedure in plpgsql that loop through the rows and store each geometry value in array.

What return typeshall i use to return an array full of geometry values?

Upvotes: 1

Views: 241

Answers (1)

vyegorov
vyegorov

Reputation: 22865

Why not to use geometry[] type?


EDIT

You can use any of the existing PostgreSQL types for arrays, per documentation:

Arrays of any built-in or user-defined base type, enum type, or composite type can be created.

Upvotes: 2

Related Questions