Whilst reading the documentation about using the PostGIS function ST_PixelAsCentroids() I was confused somewhat by this
(ST_PixelAsPoints(rast, 1)).* syntax and as a newbie to SQL I was wondering if someone could explain this convention and why it's used?
It's obviously used as a method to unbundle complex results but I don't even know what it is called to google it properly to get a formal understanding of it.
I realise this post may be better suited to a SQL forum on Stack but I'll see what GIS Stack conjures up.