need substring based on delimiter
| От | Gauthier, Dave |
|---|---|
| Тема | need substring based on delimiter |
| Дата | |
| Msg-id | 0AD01C53605506449BA127FB8B99E5E11802C11E@FMSMSX105.amr.corp.intel.com обсуждение исходный текст |
| Ответы |
Re: need substring based on delimiter
|
| Список | pgsql-general |
Hi:
I want to create a string from the first 3 elements of a csv (for example). The csv is longer than 3 elements. Example...
aaa,bbb,ccc,ddd,eee,fff,ggg
I want the string "aaa,bbb,ccc".
Tried splitting this to an array (precursor to appending elements 1,2,3), but failed to be able to reference the elements returned...
stdb_a0=# select string_to_array('aaa,bbb,ccc,ddd,eee,fff,ggg',',');
string_to_array
-------------------------------
{aaa,bbb,ccc,ddd,eee,fff,ggg}
(1 row)
stdb_a0=# select string_to_array('aaa,bbb,ccc,ddd,eee,fff,ggg',',')[1];
ERROR: syntax error at or near "["
If there was a way "position" would return the pos of the 3rd comma, I could use sustring. But I don't think it can :-(
В списке pgsql-general по дате отправления: