regression=# select '{124,567,66}'::int[] + 345;
?column?
------------------
{124,567,66,345}
(1 row)
regression=# select '{124,567,66}'::int[] + '{345,1}'::int[];
?column?
--------------------
{124,567,66,345,1}
(1 row)
select '{124,567,66}'::int[] - 567;
?column?
----------
{124,66}
(1 row)
regression=# select '{124,567,66}'::int[] - '{567,66}';
?column?
----------
{124}
(1 row)
Ryan Mahoney wrote:
Hi Oleg (and pgsql hackers!),
Recently I encountered a problem attempting to use the integer array
function for pushing an integer onto an integer array field.
Can you write an example of a sql statement for pushing a single value onto
an integer array and for popping a specific value off of an integer array?
I see the function in the documentation, but the actual statement syntax to
use is not clear to me.
Thanks for any help you can provide!
Ryan Mahoney
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
--
Teodor Sigaev
[EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
