prova=> create table a1(a varchar(99999));ERROR: length for type 'varchar' cannot exceed 8064prova=> create table a1(a varchar(8064));CREATEprova=> drop table a1;DROPprova=> create table a1(a varchar(8064),b varchar(8064));CREATEprova=> \d a1Table = 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'