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
pgsql-novice by date
|Next:||From: Justin Long||Date: 2000-10-18 17:28:55|
|Subject: Thanks for all the answers!|
|Previous:||From: bmccoy||Date: 2000-10-18 17:17:48|
|Subject: Re: Stupid question: concatenating strings|