question about meaning of character varying without length

From: Konstantin Izmailov <pgfizm(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: question about meaning of character varying without length
Date: 2009-06-16 04:24:22
Message-ID: 72746b5e0906152124q5e5ead44i32f22fbc2d7b1b40@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2009-06-16 04:24:46 Re: [PATCH] backend: compare word-at-a-time in bcTruelen
Previous Message Bruce YUAN 2009-06-16 04:13:38 How to embed postgresql?