| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "movead(dot)li(at)highgo(dot)ca" <movead(dot)li(at)highgo(dot)ca> |
| Cc: | Justin Pryzby <pryzby(at)telsasoft(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: proposal - function string_to_table |
| Date: | 2020-07-06 05:05:37 |
| Message-ID: | CAFj8pRDTG8NvUQRn2M7ByK6BhrmJL81B-OOw3QmV_7WGgTLo5w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
ne 5. 7. 2020 v 13:30 odesílatel Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
napsal:
>
>
> pá 5. 6. 2020 v 13:55 odesílatel Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> napsal:
>
>> Hi
>>
>> čt 4. 6. 2020 v 11:49 odesílatel movead(dot)li(at)highgo(dot)ca <movead(dot)li(at)highgo(dot)ca>
>> napsal:
>>
>>> +{ oid => '2228', descr => 'split delimited text',
>>> + proname => 'string_to_table', prorows => '1000', proretset => 't',
>>> + prorettype => 'text', proargtypes => 'text text',
>>> + prosrc => 'text_to_table' },
>>> +{ oid => '2282', descr => 'split delimited text with null string',
>>> + proname => 'string_to_table', prorows => '1000', proretset => 't',
>>> + prorettype => 'text', proargtypes => 'text text text',
>>> + prosrc => 'text_to_table_null' },
>>>
>>> I go through the patch, and everything looks good to me. But I do not
>>> know
>>> why it needs a 'text_to_table_null()', it's ok to put a 'text_to_table'
>>> there, I think.
>>>
>>
>> It is a convention in Postgres - every SQL unique signature has its own
>> unique internal C function.
>>
>> I am sending a refreshed patch.
>>
>
> rebase
>
two fresh fix
a) remove garbage from patch that breaks doc
b) these functions should not be strict - be consistent with
string_to_array functions
Regards
Pavel
>
> Regards
>
> Pavel
>
>
>> Regards
>>
>> Pavel
>>
>>
>>
>>
>>>
>>> ------------------------------
>>> Regards,
>>> Highgo Software (Canada/China/Pakistan)
>>> URL : www.highgo.ca
>>> EMAIL: mailto:movead(dot)li(at)highgo(dot)ca
>>>
>>
| Attachment | Content-Type | Size |
|---|---|---|
| string_to_table-20200706-2.patch | text/x-patch | 12.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kyotaro Horiguchi | 2020-07-06 05:13:40 | Re: archive status ".ready" files may be created too early |
| Previous Message | Justin Pryzby | 2020-07-06 05:01:29 | "tuple concurrently updated" in pg_restore --jobs |