[BUGS] BUG #14903: problem with bool array - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      14903
Logged by:          Roman Morozov
Email address:      arclight1995@gmail.com
PostgreSQL version: 9.6.5
Operating system:   PostgreSQL 9.6.5 on x86_64-pc-linux-gnu, compiled
Description:

1) set value for field with type bool array:
update "ContractorImage"
set "States" =

'{f,f,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL}'
2) try to change first value of array:
update "ContractorImage" set "States"[0] = true

3) instead of '{t,f,null,...}' it becomes '{t,f,f,null,...}'. why doesd
first element have index 1 instead of 0 ?


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs