The stupid question is the question not asked | |
PerlMonks |
Re^6: Matching alphabetic diacritics with Perl and Postgresqlby marinersk (Priest) |
on Jun 04, 2017 at 10:19 UTC ( [id://1192115]=note: print w/replies, xml ) | Need Help?? |
Also, a thought: If throughput efficiency is a trade-off you can afford, using an INSERTinto a staging table and then pulling it back out again might allow you to use Postgres as a 100% Postgres-compatible data filter, if it changes the data upon storage. Everything in engineering is a trade-off; the idea of introducing an execution inefficiency is naturally anathama to an engineer's way of looking at a problem, but if this approach causes a data translation to occur, putting the onus on Postgres to perform the translation for you does have the merit of adjusting perfectly each and every time Postgres changes the way it handles the data. Effectiveness is often more important than efficiency; if no more efficient solution can be found and if this does the job, it could also be used as a work-around until a more graceful solution can be found. I'd document the heck out of it, though. Have mercy on the poor next soul who has to touch the code.
In Section
Seekers of Perl Wisdom
|
|