Re: "select ('{}'::text[])[1]" returns NULL -- is it correct?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: "select ('{}'::text[])[1]" returns NULL -- is it correct?
Дата
Msg-id 25231.1176213334@sss.pgh.pa.us
обсуждение исходный текст
Ответ на "select ('{}'::text[])[1]" returns NULL -- is it correct?  ("Nikolay Samokhvalov" <samokhvalov@gmail.com>)
Ответы Re: "select ('{}'::text[])[1]" returns NULL -- is it correct?  ("Nikolay Samokhvalov" <nikolay@samokhvalov.com>)
Список pgsql-hackers
"Nikolay Samokhvalov" <nikolay@samokhvalov.com> writes:
> I remember several cases when people (e.g. me :-) ) were spending some
> time trying to find an error in some pl/pgsql function and the reason
> lied in incorrect work with arrays (i.e. messages like "index is out
> of bounds" and "index cannot be negative number" would help, surely).

Well, if indexes *couldn't* be negative numbers then that might be
helpful, but they can.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: \da doesn't show result type
Следующее
От: Tom Lane
Дата:
Сообщение: Idle idea for a feature