#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2012
    Posts
    2
    Rep Power
    0

    How to access the extension's operator installed with schema ?


    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
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2012
    Posts
    2
    Rep 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.+)"


    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

IMN logo majestic logo threadwatch logo seochat tools logo