Thread: possible array parsing bug

possible array parsing bug

From
Jeff Davis
Date:
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

From
Tom Lane
Date:
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