| From: | arclight1995(at)gmail(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Cc: | arclight1995(at)gmail(dot)com |
| Subject: | BUG #14903: problem with bool array |
| Date: | 2017-11-13 12:23:43 |
| Message-ID: | 20171113122343.1468.12937@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14903
Logged by: Roman Morozov
Email address: arclight1995(at)gmail(dot)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 ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2017-11-13 13:04:34 | Migration to pglister - Before |
| Previous Message | pavel.bazika | 2017-11-13 11:27:19 | BUG #14902: valgrind - problem in PQconnectdb - pqSaveParameterStatus reported |