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