Oliver Jowett <oliver(at)opencloud(dot)com> writes: > Daniel Migowski wrote: >> I think a VARCHAR(50) and text are not interchangeable. > But a "varchar" (with no limit) and "text" *are* interchangeable, which > is why we identify text as VARCHAR But note that varchar-with-no-limit is itself a Postgres-ism: it's not allowed by the standard. regards, tom lane