Re: question about meaning of character varying without length

On Tue, Jun 16, 2009 at 12:24 AM, Konstantin Izmailov<pgfizm@gmail.com> wrote:
> Hello,
> I've found following description: "If character varying is used without
> length specifier, the type accepts strings of any size. The latter is a
> PostgreSQL extension."
>
> Does this mean that "character varying without length" is equivalent to
> "text" type. Are there any differences?
>
> I noticed that ODBC driver processes the type differently from "text".
>
> Please help!
> Konstantin

This question would be more appropriate for pgsql-general or maybe
pgsql-odbc, since it is not a question about the development of
PostgreSQL.

character varying and text are different types, but there's no real
difference between them.  I can't speak to what the ODBC driver does.

...Robert