Re: integer array, push and pop
От | Ryan Mahoney |
---|---|
Тема | Re: integer array, push and pop |
Дата | |
Msg-id | 1035297666.1086.78.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: integer array, push and pop (Teodor Sigaev <teodor@stack.net>) |
Список | pgsql-hackers |
This is excellent! Thanks so much! -r On Tue, 2002-10-22 at 04:07, Teodor Sigaev wrote: > 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 > > >
В списке pgsql-hackers по дате отправления: