Is it possible to implement fuzzy search occurrences?
You need to choose from the database all the incomplete entry.
SELECT * FROM mytable where okpd2_code IN ('26.51.20')
Need to get all records that have more digits:
Inside IN can be a bunch of values. And it is necessary that everyone be treated in a similar way.
and so on. Is it possible to implement in Postgres? If so, how?
asked March 19th 20 at 08:36
as an option to use the regular season:
SELECT * FROM mytable where okpd2_code ~ '^(var1|var2|...|varN)'
SELECT * FROM mytable where okpd2_code ~ '^(26\.51\.20\.|22\.55\.20\.)'
Find more questions by tags PostgreSQL