Re: plpgsql string concatanation - Mailing list pgsql-general

From Doug McNaught
Subject Re: plpgsql string concatanation
Date
Msg-id 874qwo7jdt.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to plpgsql string concatanation  (Martin Marques <martin@bugs.unl.edu.ar>)
Responses Re: plpgsql string concatanation  (Martin Marques <martin@bugs.unl.edu.ar>)
List pgsql-general
Martin Marques <martin@bugs.unl.edu.ar> writes:

> 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.

Oddly enough, your signature holds the key!

> --
>  09:01:02 up 2 days, 15:25,  1 user,  load average: 0.17, 0.20, 0.19
> -----------------------------------------------------------------
> Martín Marqués        | select 'mmarques' || '@' || 'unl.edu.ar'

-Doug

pgsql-general by date:

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