The documentation reads as follows:
"An array value can be replaced completely:
UPDATE sal_emp SET pay_by_quarter = '{25000,25000,27000,27000}'
WHERE name = 'Carol';
or updated at a single element:
UPDATE sal_emp SET pay_by_quarter[4] = 15000
WHERE name = 'Bill';
or updated in a slice:
UPDATE sal_emp SET pay_by_quarter[1:2] = '{27000,27000}'
WHERE name = 'Carol'; "
I try this simple statement and get the same error:
UPDATE chist SET broker[10] = 195 WHERE code = 'AAATMOUS000';
Any ideas?
Thanks...
On Friday 29 October 2004 10:07 pm, Tom Lane saith:
> Terry Lee Tucker <terry@esc1.com> writes:
> > array[x] = <some_value>;
> >
> > This will not compile. I get the following error:
> > ERROR: syntax error at or near "["
>
> plpgsql can do this since 7.4. What PG version are you running?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--
Work: 1-336-372-6812
Cell: 1-336-363-4719
email: terry@esc1.com
