Re: plpgsql string concatanation - Mailing list pgsql-general

From Joerg Erdmenger
Subject Re: plpgsql string concatanation
Date
Msg-id 200311281349.12525.joe@woerd.com
Whole thread Raw
In response to plpgsql string concatanation  (Martin Marques <martin@bugs.unl.edu.ar>)
List pgsql-general
> Is it posible to do string concatanation in plpgsql?
>
> Somthing like:
>
> sec := ''some string here'' . NEW.id;
>
> Is there a way to do this? I need te value of that new string for things
> that come after, and couldn't find much in the PL documentation.
String concatenation is done via the '||' operator see
http://www.postgresql.org/docs/current/static/functions-string.html

Joerg


pgsql-general by date:

Previous
From: Martin Marques
Date:
Subject: Re: plpgsql string concatanation
Next
From: "Chris Travers"
Date:
Subject: Re: plpgsql string concatanation