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 [EMAIL PROTECTED] so that your
> > message can get through to the mailing list cleanly
> >
>
> --
> Teodor Sigaev
> [EMAIL PROTECTED]
>
>
>
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
