Re: plpgsql string concatanation

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: plpgsql string concatanation
Date: 2003-11-28 12:44:14
Message-ID: 874qwo7jdt.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin Marques 2003-11-28 12:45:24 Re: plpgsql string concatanation
Previous Message Martin Marques 2003-11-28 12:42:58 Re: plpgsql string concatanation