Re: How to add a new operator for parser?

From: jacktby jacktby <jacktby(at)gmail(dot)com>
To: Julien Rouhaud <rjuju123(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: How to add a new operator for parser?
Date: 2023-08-06 05:37:42
Message-ID: E37C26B2-A527-4222-BB7E-1632476352FE@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> 2023年8月6日 13:18,Julien Rouhaud <rjuju123(at)gmail(dot)com> 写道:
>
> On Sun, 6 Aug 2023, 12:34 jacktby jacktby, <jacktby(at)gmail(dot)com <mailto:jacktby(at)gmail(dot)com>> wrote:
>> I’m trying to add a new operator for my pg application like greater_equals called “<~>", how many files I need to
>> modify and how to do it? Can you give me an example?
>
>
> you can look at some contrib for some examples of custom operator (and custom datatype) implementation, like citext or btree_gin/gist
I need to build a new datatype. It can contains different datatypes, like ‘(1,’a’,2.0)’,it’s a (interger,string,float) tuple type, and Then I need to add operator for it. How should I do?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Julien Rouhaud 2023-08-06 07:25:23 Re: How to add a new operator for parser?
Previous Message Masahiko Sawada 2023-08-06 05:35:06 logical decoding issue with concurrent ALTER TYPE