Reputation: 727
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
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