ST_GeomFromGeoJSON()

lybhrwn742lybhrwn742 Vertica Customer ✭
in General Discussion

Hi, during COPY this function returns an error if the polygon is invalid.
We want to insert the row even if an error occur. that is, to insert a null instead of the polygon.
What can we do in order to solve the problem?
We tried to wrap this function with user-defined function but we didn't find an option to catch the exception.

Thank you !

Answers

  • Ariel_CaryAriel_Cary Vertica Employee Employee

    There is no workaround to that problem right now. But we do understand it can be useful to optionally have ST_GeomFromGeoJSON return null on failure. We're considering adding such option in future releases.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...