Re: Array Question

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