Re: Documentation bug?

[Maxim Boguk <maxim.boguk@xxxxxxxxx>]

On Tue, May 19, 2015 at 7:39 PM, Thomas Kellerer <spam_eater@xxxxxxx> 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/

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.boguk@xxxxxxxxx
МойКруг: 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."