Re: how is text-equality handled in postgresql?

From: Vick Khera <vivek(at)khera(dot)org>
To: Gábor Farkas <gabor(dot)farkas(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: how is text-equality handled in postgresql?
Date: 2014-01-15 16:41:19
Message-ID: CALd+dcfoW1ciPB429xOcDqX=uVJ3-SDE3phAEgoU5c4Dzsc74Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jan 15, 2014 at 4:10 AM, Gábor Farkas <gabor(dot)farkas(at)gmail(dot)com>wrote:

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

On this topic, when I write my strings to the DB and search from the DB,
should I canonicalize them first as NKFC (or some other), or just let the
DB figure it out? In my specific case I use perl DBI with place holders to
submit my queries.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tirthankar Barari 2014-01-15 17:07:19 Re: Index space growing even after cleanup via autovacuum in Postgres 9.2
Previous Message Felix.徐 2014-01-15 16:10:17 Re: How are pg_operator and pg_type related with each other?