create function with dollar quoted body

From: Jack Douglas <jack(at)douglastechnology(dot)co(dot)uk>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: create function with dollar quoted body
Date: 2012-03-09 20:06:19
Message-ID: 4F5A62BB.9000206@douglastechnology.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I don't know if this is a netbeans problem or a jdbc problem, but when
executing a 'CREATE FUNCTION' script with the body dollar quoted, an
error results.

Reading around this seems to be to do with the script being parsed for
semicolons as line terminators even inside dollar-quoted strings? Or
perhaps not?

Any pointers much appreciated

Thanks
Jack

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message otran 2012-03-09 21:25:20 oid int issue with CachedRowSet upgrading from JDBC 8.4 to 9.1
Previous Message Stefan Reiser 2012-03-08 00:02:17 Re: Updatable query and column aliases