> A related question is whether we could support some more
> standard names for data types (e.g., BIGINT, SMALLINT, etc.)
> But I'm not sure there is really any standard. I would be
> willing to work a little on these data types but I'd need
> someone to hint me on who else is doing stuff and, if possible,
> where to look first (and what known mistakes to avoid.)
postgres=> create table x (i smallint);
CREATE
postgres=> create table y (j bigint);
ERROR: Unable to locate type name 'bigint' in catalog
afaik we support the type names defined in SQL92 (like smallint),
historical names in Postgres, and some extensions. What more do we
need?
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California