Re: question about meaning of character varying without length

From: Konstantin Izmailov <pgfizm(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: question about meaning of character varying without length
Date: 2009-06-16 04:45:09
Message-ID: 72746b5e0906152145h75070074ka345484cc0032c13@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)com> wrote:

> On Tue, Jun 16, 2009 at 12:24 AM, Konstantin Izmailov<pgfizm(at)gmail(dot)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
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2009-06-16 04:47:56 Re: question about meaning of character varying without length
Previous Message Robert Haas 2009-06-16 04:31:56 Re: How to embed postgresql?