Re: TypeInfoCache - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: TypeInfoCache
Date
Msg-id 1811.1198113944@sss.pgh.pa.us
Whole thread Raw
In response to Re: TypeInfoCache  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: TypeInfoCache  (Kris Jurka <books@ejurka.com>)
Re: TypeInfoCache  (Daniel Migowski <dmigowski@ikoffice.de>)
Re: TypeInfoCache  (Daniel Migowski <dmigowski@ikoffice.de>)
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: TypeInfoCache
Next
From: "Jan de Visser"
Date:
Subject: TypeInfoCache