Re: integer array, push and pop

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 majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
> 

-- 
Teodor Sigaev
teodor@stack.net