From: | Teodor Sigaev <teodor(at)stack(dot)net> |
---|---|
To: | Ryan Mahoney <ryan(at)paymentalliance(dot)net> |
Cc: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: integer array, push and pop |
Date: | 2002-10-22 08:07:23 |
Message-ID: | 3DB5073B.6070203@stack.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
--
Teodor Sigaev
teodor(at)stack(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paesold | 2002-10-22 08:21:08 | Re: Current CVS is broken |
Previous Message | Teodor Sigaev | 2002-10-22 07:57:43 | Current CVS is broken |