Postgres Pro
Downloads
Home   >   mailing lists

String Concatnation - Mailing list pgsql-sql

From Najm Hashmi
Subject String Concatnation
Date
Msg-id 3A85AC87.FA5F3D4D@mondo-live.com
Whole thread Raw
Responses Re: String Concatnation  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
Re: String Concatnation  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: String Concatnation  (Jie Liang <jliang@ipinc.com>)
List pgsql-sql
Tree view 
Hi,How can I concatnate   two varialbles, seperated by a |,  that are type text
together?
v, v1 text;
some work
then
res:= v ||''|''|| v1;
this syntex does not work in plpgsql??
Any ideas how to do it ???
Thanks.
Najm

pgsql-sql by date:

Previous
From: Najm Hashmi
Date:
Subject: Re: What's wrong with this function
Next
From:
Date:
Subject: Re: What's wrong with this function