Re: [pgsql-jdbc] dollar-quoted CREATE FUNCTION statement fails

Tom Lane schrieb:
 > Michael Paesold <mpaesold@gmx.at> writes:
 >> scan.l defines:
 >> dolq_start        [A-Za-z\200-\377_]
 >> dolq_cont        [A-Za-z\200-\377_0-9]
 >
 >> Some questions here:
 >> - What are the \200-\377 characters?
 >
 > Basically, that's going to cover any non-7-bit-ASCII character
 > (including multibyte characters).  I'm not sure if Java has an
 > equivalent of ctype.h's isascii() but that'd probably be what
 > you want to use.  Checking if the Unicode code point is > 127
 > would work too, if Java lets you do that.

Ok, CharUtils of commons-lang of Apache.org defines isAscii as simply as:

public static boolean isAscii(char ch) {
         return (ch < 128);
}

So something like this should do the trick:

public static boolean isDollarQuoteStartChar(char c) {
     return (c >= 'a' && c <= 'z') || (c >= 'A' && c <= 'Z')
             || (c == '_') || (c > 127);
}

(c > 127) should be the same as (c >= '\200'), but I find the first one
more readable. I am probably not used to reading hex numbers. ;-)

Thanks for your help.

Best Regards
Michael Paesold