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."