[BUGS] BUG #1277: plpgsql EXECUTE bug in beta3

2004-10-03 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1277 Logged by: Tom Hebbron Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Beta Operating system: n/a Description:plpgsql EXECUTE bug in beta3 Details: In beta2, the following script runs as exp

Re: [BUGS] semicolon not required on END statement

2004-10-03 Thread Neil Conway
Bruce Momjian wrote: Improved wording that doesn't telegraph, "Look at me!": Each declaration and each statement within a block is terminated by a semicolon, though the final END that concludes a function does not require one. Patch applied. -Neil ---

Re: [BUGS] 8.0b3: problems with ILIKE and ~* on multibyte-chars

2004-10-03 Thread Tom Lane
peter pilsl <[EMAIL PROTECTED]> writes: > the caseinsensitive patternmatch-operators seems not to work with > multibyte, while lower() and upper()-functions finally works perfect. It looks to me like iwchareq() in src/backend/utils/adt/like.c still needs work to handle multibyte characters in a s

[BUGS] 8.0b3: problems with ILIKE and ~* on multibyte-chars

2004-10-03 Thread peter pilsl
8.0 beta3 the caseinsensitive patternmatch-operators seems not to work with multibyte, while lower() and upper()-functions finally works perfect. provided the correct locale-setting on initdb (LC_CTYPE=de_AT.UTF-8 in the example) the following happens: example : test=# \l List of dat