============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Raphael Finkel
Your email address : raphael@cs.uky.edu
Category : runtime: back-end: SQL
Severity : non-critical
Summary: Can't add nth element of array that has n-1 elts.
System Configuration
--------------------
Operating System : Linux 2.0.36 ELF Slackware
PostgreSQL version : 6.4.2
Compiler used : egcs-2.90.29egcs-2.90.29
Hardware:
---------
Linux zonker 2.0.36 #2 Sun Jan 10 17:51:07 EST 1999 i686 unknown
Versions of other tools:
------------------------
--------------------------------------------------------------------------
Problem Description:
--------------------
How can I add an nth element to an array column
that already has n-1 elements? The UPDATE command seems to fail:
database=> UPDATE myTable
SET who[2] = 'raphael'
WHERE letter='alpha';
database-> ERROR: array_set: array bound exceeded
--------------------------------------------------------------------------
Test Case:
----------
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------