[pgpointcloud] Sorting a patch.

[Éric Lemoine]

On Thu, 2018-08-23 at 11:51 +0200, David Serret Mayer wrote:
> I have no idea how to sort a patch. I have tried this but it says:
> ERROR:  column "x" does not exist
> 
> select pc_sort(( select pa from patches where id=14 ),   x );

Have you tried something like the following?

select pc_sort(pa, '{X}'::text[]) from patches where id=14;


> Could somebody provide an example?
> Is sorting important performance wise for further queries?

I guess that depends on what you want to do.


> How do I sort "in place" a whole patch?

pc_sort returns a new (sorted) patch. If you want to update the patches
in your table you need to do an UPDATE.

-- 
Éric Lemoine
Oslandia
+33 1 86 95 95 55
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 488 bytes
Desc: This is a digitally signed message part
URL: <http://lists.osgeo.org/pipermail/pgpointcloud/attachments/20180823/375bea5f/attachment.sig>