N prefix and ::bpchar - Mailing list pgsql-general

From oka
Subject N prefix and ::bpchar
Date
Msg-id BLU0-SMTP226837524789BAB3134B87FBBE50@phx.gbl
Whole thread Raw
Responses Re: N prefix and ::bpchar
List 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?


pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: PGSQL: listing db/role and user/role relationships
Next
From: Stefan Keller
Date:
Subject: Postgres as In-Memory Database?