Re: [JDBC] TypeInfoCache

From: Tom Lane <tgl(at)sss.pgh.pa.us>
Date: Wed Dec 19 2007 - 20:25:44 EST

Oliver Jowett <oliver@opencloud.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

---------------------------(end of broadcast)---------------------------

TIP 2: Don't 'kill -9' the postmaster Received on Wed Dec 19 20:27:48 2007