From: | "Oliveiros d'Azevedo Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt> |
---|---|
To: | "Rob Richardson" <RDRichardson(at)rad-con(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Need help (unterminated dollar-quoted string at or near "$$ LANGUAGE plpgsql IMMUTABLE; ") |
Date: | 2012-09-10 13:44:39 |
Message-ID: | 90CC578398154D4BB83F1601C3DD7DA8@marktestcr.marktest.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
You're right, Rob, the text in-between the dollar signs is an identifier.
But, Unless I'm mistaken, nothing prevents the identifier from being empty...
Best,
Oliver
----- Original Message -----
From: Rob Richardson
To: pgsql-novice(at)postgresql(dot)org
Sent: Monday, September 10, 2012 2:24 PM
Subject: Re: [NOVICE] Need help (unterminated dollar-quoted string at or near "$$ LANGUAGE plpgsql IMMUTABLE; ")
That looks to me like an error from PostgreSQL rather than from InstallShield.
When I look at a function that works in my database, I see something like:
CREATE OR REPLACE some_function()
RETURNS integer AS
$BODY$
Begin
return 1;
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
So, I suggest putting something between the two dollar signs. I believe, but I'm not positive, that the text between the dollar signs is merely an identifier. If you don't have that identifier, I can imagine PostgreSQL getting confused.
Good luck!
RobR
P.S. Please keep in mind that this advice may be worth exactly what you have paid for it.
From | Date | Subject | |
---|---|---|---|
Next Message | James David Smith | 2012-09-12 15:39:07 | Interpolating Values |
Previous Message | Rob Richardson | 2012-09-10 13:24:04 | Re: Need help (unterminated dollar-quoted string at or near "$$ LANGUAGE plpgsql IMMUTABLE; ") |