Re: Stupid question: concatenating strings

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: justinlong(at)strategicnetwork(dot)org
Cc: pgsql-novice(at)hub(dot)org
Subject: Re: Stupid question: concatenating strings
Date: 2000-10-18 17:21:48
Message-ID: 5547.971889708@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

The string concatenation operator in SQL is ||, not +.

Also, substr's start-index argument counts from 1 not 0. Otherwise
you've got the right idea...

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Justin Long 2000-10-18 17:28:55 Thanks for all the answers!
Previous Message bmccoy 2000-10-18 17:17:48 Re: Stupid question: concatenating strings