Documentation bug?

Thomas Kellerer wrote:

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)

I can't reproduce this on my PostgreSQL 9.4.1:

test=> select array[1,2,3] - 3;
ERROR: operator does not exist: integer[] - integer
LINE 1: select array[1,2,3] - 3;
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

Did you add casts or operators?

Yours,
Laurenz Albe

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

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

Maxim Boguk schrieb am 19.05.2015 um 13:33:

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

Ah, right - that was it. Completely forgot about that.

Sorry for the noise.

Thomas

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general