On Tue, May 19, 2015 at 7:39 PM, Thomas Kellerer <spam_ea...@gmx.net> wrote:

> Hello all,
>
> I just noticed that you can do something like this (using 9.4.1):
>
>    select array[1,2,3] - 3
>
> which is doing the same thing as:
>
>    select array_remove(array[1,2,3],3)
>
> but the minus is not documented as an array operator:
> http://www.postgresql.org/docs/current/static/functions-array.html
>
> Is that an oversight in the documentation or isn't the minus supposed to
> work like that in the first place?
>

​You very likely have an intarray extension installed​:​
http://www.postgresql.org/docs/9.4/interactive/intarray.html
int[] - int  operator documented in the extension documentation as it's a
part of the extension but not part of the PostgreSQL core.​



-- 
Maxim Boguk
Senior Postgresql DBA
http://www.postgresql-consulting.ru/ <http://www.postgresql-consulting.com/>

Phone RU: +7 910 405 4718
Phone AU: +61 45 218 5678

LinkedIn: http://www.linkedin.com/pub/maksym-boguk/80/b99/b1b
Skype: maxim.boguk
Jabber: maxim.bo...@gmail.com
МойКруг: http://mboguk.moikrug.ru/

"People problems are solved with people.
If people cannot solve the problem, try technology.
People will then wish they'd listened at the first stage."

Reply via email to