Postgres Pro
Downloads
Home   >   mailing lists

how is text-equality handled in postgresql? - Mailing list pgsql-general

From Gábor Farkas
Subject how is text-equality handled in postgresql?
Date
Msg-id CAPiPmQnAZ=v8Q9Na+DdmmFTGXB7d84+4QBnTr9sN0GjgQWQ8pw@mail.gmail.com
Whole thread Raw
Responses Re: how is text-equality handled in postgresql?  (Ivan Voras <ivoras@freebsd.org>)
Re: how is text-equality handled in postgresql?  (Vick Khera <vivek@khera.org>)
List pgsql-general
Tree view 
hi,

when i create an unique-constraint on a varchar field, how exactly
does postgresql compare the texts? i'm asking because in UNICODE there
are a lot of complexities about this..

or in other words, when are two varchars equal in postgres? when their
bytes are? or some algorithm is applied?

thanks,
gabor

pgsql-general by date:

Previous
From: Clemens Eisserer
Date:
Subject: Re: Why is wal_writer_delay limited to 10s?
Next
From: Ivan Voras
Date:
Subject: Re: how is text-equality handled in postgresql?