
September 18th, 2012, 02:50 AM
|
|
Registered User
|
|
Join Date: Sep 2012
Posts: 2
Time spent in forums: 57 m 47 sec
Reputation Power: 0
|
|
I got an answer from another website:
"The easy way is to change your search_path to include inty.
If you really don't want to do that, you can write OPERATOR(inty.+)"
Quote: | Originally Posted by xoip Hello,
I'm having a problem accessing an extension's operator installed with a schema.
PostgreSQL version: 9.1
CREATE SCHEMA inty AUTHORIZATION psql_user;
CREATE EXTENSION intarray SCHEMA inty;
SELECT inty.uniq(ARRAY[1,2,3]); --> OK, result: {1,2,3}
How can I access the operator with inty schema?
SELECT ARRAY[1,2,3] + 10; --> returns "ERROR: operator does not exist: integer[] + integer" because the default operator (+) has other definition
SELECT ARRAY[1,2,3] fast.+ 10; --> NOT OK |
|