Question

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


Badge

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?


3 replies

Userlevel 4
Badge +13

 

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

 

Badge +11

Hi @dollargis,

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

What version of FME are you using?

Badge

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

Reply