开发者

IBM Informix Spatial datablade LIneFromText function

开发者 https://www.devze.com 2022-12-25 15:15 出处:网络
I am using IBM-Informix for my school project as part of \"Informix on-campus\" ativity conduted by IBM.

I am using IBM-Informix for my school project as part of "Informix on-campus" ativity conduted by IBM.

however it is giving me error as "(USE31) - Too few points for geometry type in ST_LineFromText."开发者_如何转开发, in the second linefromtext function.


The problem in the second call to ST_LineFromText() is that you are attempting to pass parameters into it, which isn't possible. You have:

ST_LineFromText('linestring (0 0,v1.pre 0,v1.pre v1.post,0 v1.post,0 0 )',5)

The string contains 'v1.pre' which is not a valid number, etc. If you need to parameterize your query, you either need to generate the string with those values in place, or you need to use a different method. One crude but possible solution is:

ST_LineFromText('linestring (0 0,' || v1.pre || ' 0,' || v1.pre || ' ' ||
                v1.post || ',0 ' || v1.post || ',0 0 )', 5)

This may not do the job - but illustrates the problem.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号