Postgres Pro
Downloads
Home   >   mailing lists

Thread: ???Varchar()

???Varchar()

From
Tourtounis Sotiris
Date:
I have listened that through new Postgresql 7.2.2 version there is also
the capability of declaring a varchar type without declaring the maximum
number of storage e.g. create table A(att0 varchar(16)). Is is true?If
it's how is declared beacuse i can't manage it. Specifically i can't
declare create table A(att0 varchar()). Does anyone have any idea about
the subject.Thanks you !



                                                 SWTHRHS TOYRTOYNHS
                                                (tourtoun@csd.uch.gr)

Re: ???Varchar()

From
Martijn van Oosterhout
Date:
How about:

create table A(att0 text);

The length limit is something like 2TB or some such.

On Tue, Sep 10, 2002 at 12:19:34PM +0300, Tourtounis Sotiris wrote:
> I have listened that through new Postgresql 7.2.2 version there is also
> the capability of declaring a varchar type without declaring the maximum
> number of storage e.g. create table A(att0 varchar(16)). Is is true?If
> it's how is declared beacuse i can't manage it. Specifically i can't
> declare create table A(att0 varchar()). Does anyone have any idea about
> the subject.Thanks you !

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.

Re: ???Varchar()

From
"scott.marlowe"
Date:
Do it like this:

create table a (b varchar);

In this usage, varchar is pretty much an alias for text, but some database
front ends find it easier to accept type varchar than text.

On Tue, 10 Sep 2002, Tourtounis Sotiris wrote:

> I have listened that through new Postgresql 7.2.2 version there is also
> the capability of declaring a varchar type without declaring the maximum
> number of storage e.g. create table A(att0 varchar(16)). Is is true?If
> it's how is declared beacuse i can't manage it. Specifically i can't
> declare create table A(att0 varchar()). Does anyone have any idea about
> the subject.Thanks you !
>
>
>
>                                                  SWTHRHS TOYRTOYNHS
>                                                 (tourtoun@csd.uch.gr)
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>