Re: [GENERAL] maximal length of varchar
| От | José Soares |
|---|---|
| Тема | Re: [GENERAL] maximal length of varchar |
| Дата | |
| Msg-id | 377231E1.CBF83290@sferacarta.com обсуждение исходный текст |
| Ответ на | maximal length of varchar (guenther mair <mairg@efferd.nettz.com>) |
| Ответы |
Re: [GENERAL] maximal length of varchar
|
| Список | 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=>
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.mair@web.by.com
______________________________________________________
--
______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'
В списке pgsql-general по дате отправления: