PostgreSQL dollar-quoted strings - what am I missing

trying example in thread http://www.dbvis.com/forum/message.jspa?messageID=7405 I'm still getting PostgreSQL error: [Error Code: 0, SQL State: 42601] ERROR: unterminated dollar-quoted string at or near "$$ Have variable identifier prefix/suffix to: '${' and '}$' using: Product: DbVisualizer Personal 8.0.10 Build: #1766 (2012/07/10 21:25) Java VM: Java HotSpot(TM) 64-Bit Server VM Java Version: 1.7.0_05 Java Vendor: Oracle Corporation OS Name: Windows 7 OS Arch: amd64 OS Version: 6.1 PostgreSQL Native Driver ------------------------ Version: 9.1-902 JDBC 4 Files: postgresql.jar Reference: http://jdbc.postgresql.org TIA, JimPP

Hi Jim, Since the CREATE FUNCTION statement includes semicolons (statement delimiters), you need to use Execute Buffer instead of Execute, or enclose the statement in SQL Block delimiters, use the @delimiter command to temporarily change the statement delimiter, or use the Procedure Editor to edit the function. Please see these sections of the Users Guide for more info about all of these options: http://www.dbvis.com/doc/main/doc/ug/sqlCommander/sqlCommander.html#mozTocId958847 http://www.dbvis.com/doc/main/doc/ug/sqlCommander/sqlCommander.html#mozTocId652495 http://www.dbvis.com/doc/main/doc/ug/sqlCommander/sqlCommander.html#mozTocId437790 http://www.dbvis.com/doc/main/doc/ug/procEditor/procEditor.html I hope one of these alternatives suits your needs. Best Regards, Hans

Hans, got it. I was not using SQL block delimiters. BTW, congratulations on great V9.0 upgrade! -Jim

Hi Jim, Great that it works now, and I'm glad you like 9.0. Best Regards, Hans