N prefix and ::bpchar

From: oka <t-oka_(at)live(dot)jp>
To: pgsql-general(at)postgresql(dot)org
Subject: N prefix and ::bpchar
Date: 2013-11-17 10:53:32
Message-ID: BLU0-SMTP226837524789BAB3134B87FBBE50@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, I am not good at English.

I have a question.

There are the following data.

create table chartbl
(
caseno int,
varchar5 varchar(5)
);
insert into chartbl values(1, ' ');
insert into chartbl values(2, '');

The same result with the following two queries is obtained.
select * from chartbl where varchar5 = ' '::bpchar -- ::bpchar
select * from chartbl where varchar5 = N' ' -- N prefix

Is this specification?
Does it continue not to change?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Keller 2013-11-17 11:25:37 Postgres as In-Memory Database?
Previous Message Luca Ferrari 2013-11-17 08:56:58 Re: PGSQL: listing db/role and user/role relationships