Re: How to create a new operator inpg for spec data type?

From: Erik Wienhold <ewie(at)ewie(dot)name>
To: "jacktby(at)gmail(dot)com" <jacktby(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How to create a new operator inpg for spec data type?
Date: 2023-02-01 06:37:11
Message-ID: 1793578543.67829.1675233431851@office.mailbox.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On 01/02/2023 06:40 CET jacktby(at)gmail(dot)com <jacktby(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brad White 2023-02-01 06:39:45 Re: Best Open Source OS for Postgresql
Previous Message Tony Shelver 2023-02-01 06:19:54 Re: Best Open Source OS for Postgresql