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

Tom Lane schrieb:
> Michael Paesold <mpaesold(at)gmx(dot)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