From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)hub(dot)org |
Subject: | Re: [SQL] char type seems the same as char(1) |
Date: | 1998-12-14 00:24:41 |
Message-ID: | 36745AC9.3EF6DB74@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> > Well, Tom Lockhart responded that "it's not a bug, it's a feature".
> > I still think it's broken --- and certainly the fact that quoting
> > affects the result (char and "char" act differently) is not good.
OK, I've committed changes to *both* trees prompted by the problems with
handling the single-byte character type.
One set of changes removes the double quotes from most data type fields
in pg_dump (they aren't really legal there in the SQL92 sense anyway).
pg_dump now writes "character" and "character varying" for the Postgres
internal types "bpchar" and "varchar" to be more compatible with
standard usage.
Another set of changes modifies the type matching for DEFAULT statements
to use the recently implemented implicit type coersion techniques. More
permutations of DEFAULT clauses should now be legal and handled.
Please test this stuff! Especially if you are set up to test the REL6_4
tree since I've done all testing on the main development tree.
btw, all regression tests pass on my machine.
> If we use char1 for internal tables, we should allow it externally, if
> only as char1. I will add it to the TODO list.
As what?
- Tom
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-12-14 00:45:33 | Re: [SQL] char type seems the same as char(1) |
Previous Message | Thomas G. Lockhart | 1998-12-13 20:35:15 | Re: [SQL] char type seems the same as char(1) |