| From: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
|---|---|
| To: | Najm Hashmi <najm(at)mondo-live(dot)com> |
| Cc: | pgsql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: String Concatnation |
| Date: | 2001-02-09 20:48:17 |
| Message-ID: | Pine.LNX.4.30.0102091547350.5021-100000@chapelperilous.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Sat, 10 Feb 2001, Najm Hashmi wrote:
> How can I concatnate two varialbles, seperated by a |, that are type text
> together?
> v, v1 text;
> some work
> then
> res:= v ||''|''|| v1;
What error is it giving? Do you need to be using two single quotes in the
statement?
-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
There is a certain impertinence in allowing oneself to be burned for an opinion.
-- Anatole France
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mark proctor | 2001-02-09 21:03:03 | Re: What's wrong with this function |
| Previous Message | plpgsql | 2001-02-09 20:23:00 | PL/PGSQL Cook Book |