> 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