Skip to main content
Question

SQLExecutor:_'select st_srid(geom)' gives wrong result

  • May 5, 2018
  • 3 replies
  • 30 views

dollargis
Contributor
Forum|alt.badge.img+6

When I run the statement 'select st_srid(geom) as epsg from my.table' on the psql command prompt, it correctly returns 31468

 

When I do the same in the SQLExecutor transformer, in returns 0.

Doing the same exercise with 'select count(*) as my_counter', the results are identical.

What is wrong here? The docs?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

fmelizard
Safer
Forum|alt.badge.img+21
  • Safer
  • May 7, 2018

 

Hi @dollargis, does the query work for other tables?

 


steveatsafe
Safer
Forum|alt.badge.img+13

Hi @dollargis,

Both the SQLCreator and SQLExecutor seem to work for me in FME 2018.

What version of FME are you using?


dollargis
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • May 8, 2018

Sorry, my fault - I got confused with the huge number of tables and selected one for the test which indeed had no projection set