Postgres Pro
Downloads
Home   >   mailing lists

Re: Operator is not unique - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Operator is not unique
Date
Msg-id c73a31e0-3144-d9e6-d2d9-8cfaccd68c4b@aklaver.com
Whole thread Raw
In response to Re: Operator is not unique  (PegoraroF10 <marcos@f10.com.br>)
Responses Re: Operator is not unique
List pgsql-general
Tree view 
On 9/27/19 2:44 PM, PegoraroF10 wrote:
> oprname     oprkind     oprleft     oprright     oprresult     oprcode

> +     b     1700     2283     2283     pg_catalog.day_inc
> +     b     2283     1700     2283     pg_catalog.day_inc

Not sure if it will provide any useful information but try running:

select oprcode, pg_get_functiondef(oprcode)  from pg_operator where 
oprname = '+' and oprcode = 'pg_catalog.day_inc'::regproc;

-- 
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Operator is not unique
Next
From: Artjom Simon
Date:
Subject: Re: pgq is one of the most underrated pg related stuff