Re: [SQL] plpgsql bug(?) - Mailing list pgsql-sql

From Jan Wieck
Subject Re: [SQL] plpgsql bug(?)
Date
Msg-id 38735DBB.360E369B@debis.com
Whole thread Raw
In response to plpgsql bug(?)  (Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>)
List pgsql-sql
Kovacs Zoltan wrote:

> Dear Jan,
>
> The problem occurs with "vevõ = new.az", I think the plpgsql parser
> stops processing the field name "vevõ" because "õ" (code 245)
> is not a standard ASCII character, it is from the Latin2 set.
> I tried other non-international characters like "é" (code 233)
> without success.
>
> Could you please help, where to modify the sources to make this work?
> I am using version 6.5.2.
    Unfortunately I cannot reproduce that behaviour here. Seems    that your version of lex(1) has another
understandingof the    character class [:alnum:] than my one. I can use äöü    (a-diaeresis etc.), µ (greek my
character)and ³ (3    superscripted) too.
 
    I'm using flex-2.5.4 here. But I'm not really sure it is that    itself, maybe flex is using isalnum() from the
standardC    library inside. Then it would be more tricky.
 
    You can play around with the two character sets WS and WC    declared at the top of
    src/pl/plpgsql/src/scan.l
    They are slightly extended regular expressions (the class    notation inside).



Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #





pgsql-sql by date:

Previous
From: Kovacs Zoltan
Date:
Subject: plpgsql bug(?)
Next
From: Tom Lane
Date:
Subject: Re: [SQL] datetime fields have '60' in seconds field