Re: [BUGS] ERROR: invalid INTERVAL typmod: 0xc

2004-01-28 Thread Tom Lane
Darcy Buskermolen <[EMAIL PROTECTED]> writes: > The following query works in 7.3 but errors in 7.4.x as well as devel with > the above error > SELECT quote_ident(nspname) as namespace, format_type(pg_type.oid, typlen) as > type_name FROM pg_catalog.pg_type JOIN pg_catalog.pg_namespace ON > (pg

[BUGS] ERROR: invalid INTERVAL typmod: 0xc

2004-01-28 Thread Darcy Buskermolen
The following query works in 7.3 but errors in 7.4.x as well as devel with the above error SELECT quote_ident(nspname) as namespace, format_type(pg_type.oid, typlen) as type_name FROM pg_catalog.pg_type JOIN pg_catalog.pg_namespace ON (pg_namespace.oid = typnamespace) WHERE pg_type.oid = '1186

Re: [BUGS] BUG #1069: functions "lower()" and "upper()" not characterset-aware

2004-01-28 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > the functions "lower()" and "upper()" do not seem to work correctly with > ISO_8859_7 values > CREATE DATABASE mediagrk WITH TEMPLATE = template0 ENCODING = 'ISO_8859_7'; upper/lower are driven by the database locale, not the encoding. They

[BUGS] BUG #1069: functions "lower()" and "upper()" not characterset-aware

2004-01-28 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1069 Logged by: Interzone Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Linux 2.4.24 Description:functions "lower()" and "upper()" not characterset-aware Details: the function