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

From Konstantin Izmailov
Subject Re: question about meaning of character varying without length
Date
Msg-id 72746b5e0906152145h75070074ka345484cc0032c13@mail.gmail.com
Whole thread Raw
In response to Re: question about meaning of character varying without length  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: question about meaning of character varying without length
List pgsql-hackers
I have tried to send to pgsql-general twice, each time it returns error: "Relay access denied (state 14)." Will try to post to pgsql-odbc.

Thank you!

On Mon, Jun 15, 2009 at 9:29 PM, Robert Haas <robertmhaas@gmail.com> wrote:
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: How to embed postgresql?
Next
From: Robert Haas
Date:
Subject: Re: question about meaning of character varying without length