Re: CONCAT function

On Tuesday 16 September 2003 13:45, Marek Lewczuk wrote:
> Hello,
> As I'm in the middle of the migration process form mysql to pg I found
> that there is no CONCAT function which is available in mysql. Can
> anybody tell me how to implement this function using plPERL or plPGSQL
> language ?

You want to use the || operator, e.g. 'hello' || ' ' || 'world'

Full details of operators and functions can be found in the "data types"
section of the documentation.

--
  Richard Huxton
  Archonet Ltd