Re: [GENERAL] maximal length of varchar

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'