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

From: xoip <sorin(dot)mircioiu(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to access the extension's operator installed with schema ?
Date: 2012-09-14 13:34:13
Message-ID: 1347629653044-5724032.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-access-the-extension-s-operator-installed-with-schema-tp5724032.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2012-09-14 13:39:47 PL/pgSQL debugger and PostgreSQL 9.2
Previous Message Albe Laurenz 2012-09-14 13:22:02 Re: SQLSTATE[08006] [7] server closed the connection unexpectedly