How to define + operator for strings - Mailing list pgsql-general

From Andrus
Subject How to define + operator for strings
Date
Msg-id e2spis$30tr$1@news.hub.org
Whole thread Raw
Responses Re: How to define + operator for strings  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
I want to create portable code which runs in other dbms without
modification.

Unfortunately this other dbms uses + for string concatenation and has no way
to define operators.

How to define + operator as alias of || operator for strings  so I can use

SELECT firstname+ ' '+ lastname
...

in Postgres

Andrus.



pgsql-general by date:

Previous
From: Terry Lee Tucker
Date:
Subject: Re: For vim users: Syntax highlighting for PostgreSQL
Next
From: "A. Kretschmer"
Date:
Subject: Re: How to define + operator for strings