> On 01/02/2023 06:40 CET jacktby@xxxxxxxxx <jacktby@xxxxxxxxx> 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