"George Pavlov" <gpavlov@xxxxxxxxxxxxxx> writes: > yes, but int8 is a clearly documented while preceding certain "magic" > datatype names with underscores is not. i really don't have much of a > problem with this, but little things like this contribute to people > coming from other DBMSs developing opinions that "this open-source stuff > does weird, undocumented things" (not that commercial DBMSs don't do > weird stuff :). Undocumented? Read the CREATE TYPE manual page. I'll agree it's pretty ugly, but it's not worth changing ... especially since a change would break some legacy application code. regards, tom lane