Postgres Pro
Downloads
Home   >   mailing lists

proposal - function string_to_table - Mailing list pgsql-hackers

From Pavel Stehule
Subject proposal - function string_to_table
Date
Msg-id CAFj8pRD8HOpjq2TqeTBhSo_QkzjLOhXzGCpKJ4nCs7Y9SQkuPw@mail.gmail.com
Whole thread Raw
Responses Re: proposal - function string_to_table  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-hackers
Tree view
Hi

I propose new function string_to_table. This function is significantly faster (and simpler) variant of regexp_split_to_array function. There was same process years ago when we implemented string_agg as faster variant of array_to_string(array_agg()). string_to_table is faster variant (and little bit more intuitive alternative of unnest(string_to_array()).

string_to_table is about 15% faster than unnest(string_to_array()) and about 40% faster than regexp_split_to_array.

Initial patch is attached

Notes, comments?

Regards

Pavel
Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: It is not documented that pg_promote can exit standby mode
Next
From: Robert Haas
Date:
Subject: Re: Should we add xid_current() or a int8->xid cast?