Re: [SQL] I'm stuck - I just can't get this small FUNCT to run!

2010-11-03 Thread Tom Lane
Ralph Smith writes: > I'm also stuck on 7.4 for at least a few more months, but that's not > part of the problem. ... well, actually, it is; because newer versions give considerably more helpful syntax error messages. I tried plugging this function into a current version, and got syntax error

Re: [SQL] I'm stuck - I just can't get this small FUNCT to run!

2010-11-03 Thread bricklen
You appear to be missing a trailing semi-colons. On Wed, Nov 3, 2010 at 5:00 PM, Ralph Smith wrote: Here: >     vFieldName= ''offer_'' || ''$1'' and here: >   vBusID=daRec.bus_id -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://

[SQL] I'm stuck - I just can't get this small FUNCT to run!

2010-11-03 Thread Ralph Smith
I'm also stuck on 7.4 for at least a few more months, but that's not part of the problem. I've spent hours on this, cutting things out, etc., now I have to give it and me a break. Anything stand out to anyone? === FIRST the pgAdmin error message: