Skip site navigation (1) Skip section navigation (2)

Re: Need help (unterminated dollar-quoted string at or near "$$ LANGUAGE plpgsql IMMUTABLE; ")

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 (view raw or flat)
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.

In response to

pgsql-novice by date

Next:From: James David SmithDate: 2012-09-12 15:39:07
Subject: Interpolating Values
Previous:From: Rob RichardsonDate: 2012-09-10 13:24:04
Subject: Re: Need help (unterminated dollar-quoted string at or near "$$ LANGUAGE plpgsql IMMUTABLE; ")

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group