On Tue, Feb 7, 2012 at 8:03 AM, wrote:
>
> I have a SQL statement that I'm trying to convert from a SQL Anywhere
> function, but I'm getting a error. Can't seem to figure out why. Is the
> substring usage incorrect and if it is how do I accomplish this. I'm trying
> to step through the item
On 7 February 2012 15:03, wrote:
> How do I convert this to PostGres. I'm getting a error
> ERROR: syntax error at or near "("
> LINE 23: set chr = substr(lfeid,idx,1);
>
Assuming you are writing this as pl/pgsql code, the way you do your
variable assignments is wrong on two accounts. Find some
<<< text/html; charset="utf-8": Unrecognized >>>
<>