2009/7/27 Tom Lane <t...@sss.pgh.pa.us>: > Pavel Stehule <pavel.steh...@gmail.com> writes: >> I tested implementation and it's about 30% faster than using regexp. > > In a real application, that's going to be negligible compared to all the > other costs involved in pushing the data around. And we still haven't > seen any in-the-field requests for this functionality, so even if the > gap were wider, I don't see the point of putting effort into it. >
This is just possible optimalisation - Maybe Merlin proposal is the best - we could add this technique to regexp_split_to_array - when is pattern empty, then we could to use direct char separation - without any new function or change of current function. And somebody, that use regexp_split_to_array now will have profit too. Pavel > regards, tom lane > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers