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

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

pgsql-jdbc by date

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

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