Обсуждение: possible array parsing bug

Поиск
Список
Период
Сортировка

possible array parsing bug

От
Jeff Davis
Дата:
This does not look right to me:

=# select regexp_split_to_array('dsf,sdfsdf',',')::text[][1000000];
 regexp_split_to_array
-----------------------
 {dsf,sdfsdf}
(1 row)

Is this known?

Regards,
    Jeff Davis

Re: possible array parsing bug

От
Tom Lane
Дата:
Jeff Davis <pgsql@j-davis.com> writes:
> This does not look right to me:

> =# select regexp_split_to_array('dsf,sdfsdf',',')::text[][1000000];

Perhaps you meant to write

 select (regexp_split_to_array('dsf,sdfsdf',',')::text[])[1000000];

As-is, the [100000] is just useless decoration on the cast's target
type name.

            regards, tom lane