Re: Varchar Indexing, Null Bytes - Mailing list pgsql-general

From Alvar Freude
Subject Re: Varchar Indexing, Null Bytes
Date
Msg-id 3A832643.B9BE8F57@merz-akademie.de
Whole thread Raw
In response to Varchar Indexing  (mitch <mitch@venux.net>)
List pgsql-general
Hi,

Tom Lane schrieb:
>
> mitch <mitch@venux.net> writes:
> > Is there a size limit on indexable varying character fields?
>
> 1/3rd page, about 2700 bytes, if you're using btree index.

and for the "text" data type?


other question:

is it possible to store 0-bytes in a text field?


Ciao
  Alvar

pgsql-general by date:

Previous
From: Alfonso Peniche
Date:
Subject: About SP's and parameters
Next
From: Alex Pilosov
Date:
Subject: Re: About SP's and parameters