how is text-equality handled in postgresql?

From: Gábor Farkas <gabor(dot)farkas(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how is text-equality handled in postgresql?
Date: 2014-01-15 09:10:27
Message-ID: CAPiPmQnAZ=v8Q9Na+DdmmFTGXB7d84+4QBnTr9sN0GjgQWQ8pw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Voras 2014-01-15 10:39:42 Re: how is text-equality handled in postgresql?
Previous Message Clemens Eisserer 2014-01-15 08:56:14 Re: Why is wal_writer_delay limited to 10s?