plpgsql string concatanation

El Vie 28 Nov 2003 09:04, escribió:

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.

Sorry for the stupid question. I got it, and it was always on MY FACE. :-(

CONCATENATION, why can't I think simple. ;-)

--
09:41:02 up 2 days, 16:05, 1 user, load average: 0.87, 1.19, 0.98
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------

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

El Vie 28 Nov 2003 09:44, Doug McNaught escribió:

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!

Exactly!!!!
That makes me fill even worst! :-(

As I said, it was in front of me, and the tree didn't let me see the
forest. :-)

--
09:43:01 up 2 days, 16:07, 1 user, load average: 1.14, 1.34, 1.07
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------

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

One thing that I always have to remind myself of is this:

string || NULL is NULL.
It is usually a good idea to use coalesce() unless you want this to happen.

Best wishes,
CHris Travers
----- Original Message -----
From: "Martin Marques" <martin@bugs.unl.edu.ar>

As I said, it was in front of me, and the tree didn't let me see the
forest. :-)

--
09:43:01 up 2 days, 16:07, 1 user, load average: 1.14, 1.34, 1.07
-----------------------------------------------------------------
Mart�n Marqu�s | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

One thing that I always have to remind myself of is this:

string || NULL is NULL.
It is usually a good idea to use coalesce() unless you want this to
happen.

See my recent post at

http://www.brasileiro.net/postgres/cookbook/view-one-recipe.adp?recipe_id=24725

(and in general, everyone here who hasn't looked at
http://www.brasileiro.net/postgres/cookbook/
should review all the great goodies posted there).

~Berend Tober

El Vie 28 Nov 2003 10:38, Chris Travers escribió:

One thing that I always have to remind myself of is this:

string || NULL is NULL.
It is usually a good idea to use coalesce() unless you want this to happen.

Pretty nice. :-)
Even though I don't have that problem, becuase the value comes from a PK
field.

--
11:24:01 up 2 days, 17:48, 1 user, load average: 0.56, 0.62, 0.63
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------