From: | José Soares <jose(at)sferacarta(dot)com> |
---|---|
To: | guenther mair <mairg(at)efferd(dot)nettz(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] maximal length of varchar |
Date: | 1999-06-24 13:25:53 |
Message-ID: | 377231E1.CBF83290@sferacarta.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
prova=> create table a1(a varchar(99999));
ERROR: length for type 'varchar' cannot exceed 8064
prova=> create table a1(a varchar(8064));
CREATE
prova=> drop table a1;
DROP
prova=> create table a1(a varchar(8064),b varchar(8064));
CREATE
prova=> \d a1
Table = a1
+----------------------------------+----------------------------------+-------+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-------+
| a | varchar() |
8064 |
| b | varchar() |
8064 |
+----------------------------------+----------------------------------+-------+
prova=>
guenther mair ha scritto:
> i'm interested in knowing how the varchar type is
> limited. since there are no references to this it
> seems to me, as if there was no postgres-internal
> limit.
>
> is this limit posed just by the os/filesystem/memory?
>
> thanks in advance,
>
> guenther mair
>
> ______________________________________________________
>
> web.by - guenther mair
> via negrelli 14 negrellistr. - bolzano 39100 bozen
> via leopardi 11 leopardistr. - merano 39012 meran
> italia . italy . italien
> phone +39.0471.568 124 - fax +39.0471.568 129
> http://www.web.by.com/ - mail guenther(dot)mair(at)web(dot)by(dot)com
> ______________________________________________________
--
______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'
From | Date | Subject | |
---|---|---|---|
Next Message | guenther mair | 1999-06-24 13:51:47 | Re: [GENERAL] maximal length of varchar |
Previous Message | José Soares | 1999-06-24 13:14:07 | Re: [GENERAL] Datetime <> ODBC <> Access |