Quick Links

String Concatnation

From:	Najm Hashmi <najm(at)mondo-live(dot)com>
To:	pgsql <pgsql-sql(at)postgresql(dot)org>
Subject:	String Concatnation
Date:	2001-02-10 21:03:03
Message-ID:	3A85AC87.FA5F3D4D@mondo-live.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

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

Responses

Re: String Concatnation at 2001-02-09 20:48:17 from Brett W. McCoy
Re: String Concatnation at 2001-02-09 21:21:08 from Stephan Szabo
Re: String Concatnation at 2001-02-09 22:11:28 from Jie Liang

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Ian Harding	2001-02-11 03:19:08	Re: plpgsql grief
Previous Message	Najm Hashmi	2001-02-10 20:23:15	Re: What's wrong with this function