[BUGS] "char" quoted in column information schema view

[Rainer J. H. Brandt]

Hi!

In the output below (seen with PostgreSQL 8.1.3 and 8.2.1),
is it intentional that "char" is quoted, or is it a bug?


Welcome to psql 8.1.3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
   \h for help with SQL commands
   \? for help with psql commands
   \g or terminate with semicolon to execute query
   \q to quit

exp=> select distinct data_type from information_schema.columns;
data_type 
--
 "char"
 ARRAY
 abstime
 anyarray
 bigint
 boolean
 bytea
 character
 character varying
 date
 inet
 integer
 name
 numeric
 oid
 real
 regproc
 smallint
 text
 time without time zone
 timestamp with time zone
 xid
(22 rows)




Greetings,
Rainer
-- 
--
Rainer J. H. Brandt
Brandt & Brandt Computer GmbH
Email: [EMAIL PROTECTED]
Mobile: +49 172 9593205

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [BUGS] "char" quoted in column information schema view

[Tom Lane]

"Rainer J. H. Brandt" <[EMAIL PROTECTED]> writes:
> In the output below (seen with PostgreSQL 8.1.3 and 8.2.1),
> is it intentional that "char" is quoted, or is it a bug?

It's intentional --- that type is not the same as CHAR(n).

regards, tom lane

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate