Skip to main content
Solved

Extract more recent rows in Postgis

  • October 14, 2018
  • 1 reply
  • 5 views

mr_fme
Enthusiast
Forum|alt.badge.img+9

Hi,

I´m record data from DWG files, but there is some versions of the same file...for example: V1, V2, V3...

What the best way for extract the more recent version by file? I need to create one field called last_date? How I can to extract the last date for example?

Thank´s

Best answer by takashi

Hi @mr_fme, if you can consider the records having the latest "last_date" as the recent version ones, you can extract them by setting "WHERE Clause" parameter in the PostGIS reader feature type. For example:

last_date = (select max(last_date) from my_table)

View original
Did this help you find an answer to your question?

1 reply

takashi
Evangelist
  • Best Answer
  • October 14, 2018

Hi @mr_fme, if you can consider the records having the latest "last_date" as the recent version ones, you can extract them by setting "WHERE Clause" parameter in the PostGIS reader feature type. For example:

last_date = (select max(last_date) from my_table)


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings