Re: How to create a new operator inpg for spec data type? - Mailing list pgsql-general

From Erik Wienhold
Subject Re: How to create a new operator inpg for spec data type?
Date
Msg-id 1793578543.67829.1675233431851@office.mailbox.org
Whole thread Raw
In response to How to create a new operator inpg for spec data type?  ("jacktby@gmail.com" <jacktby@gmail.com>)
List pgsql-general
> On 01/02/2023 06:40 CET jacktby@gmail.com <jacktby@gmail.com> wrote:
>
> I need to create a new operator like '<->' and its syntax is that text1 <-> text2,
> for the usage like this: 'a' <-> 'b' = 'a1b1', so how could I realize this one?
> Can you give me some exmaples.

https://www.postgresql.org/docs/current/sql-createoperator.html

But why use an operator and not just the function that you must create anyway?

--
Erik



pgsql-general by date:

Previous
From: Tony Shelver
Date:
Subject: Re: Best Open Source OS for Postgresql
Next
From: Brad White
Date:
Subject: Re: Best Open Source OS for Postgresql