pgsql-bugs(at)postgresql(dot)org writes:
>> select arr[1:2] from temp
> Error: qrPgSql: Parameter '2' not found
What client frontend are you using? It looks like the frontend is
trying to interpret :2 as a parameter. I seem to recall that
psql had such a bug for a while during 7.0 development, but I
don't think it was in any release version.
BTW, I can't find any occurrence of such an error string in current
sources ...
regards, tom lane