Re: question about meaning of character varying without length - Mailing list pgsql-hackers

From Robert Haas
Subject Re: question about meaning of character varying without length
Date
Msg-id 603c8f070906152129n243aaaf3x2466fff6efd22413@mail.gmail.com
Whole thread Raw
In response to question about meaning of character varying without length  (Konstantin Izmailov <pgfizm@gmail.com>)
Responses Re: question about meaning of character varying without length  (Konstantin Izmailov <pgfizm@gmail.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [PATCH] backend: compare word-at-a-time in bcTruelen
Next
From: Robert Haas
Date:
Subject: Re: How to embed postgresql?