Re: Char = varchar - Mailing list pgsql-general

From Tom Lane
Subject Re: Char = varchar
Date
Msg-id 20079.1023233666@sss.pgh.pa.us
Whole thread Raw
In response to Char = varchar  ("Glen Parker" <glenebob@nwlink.com>)
List pgsql-general
"Glen Parker" <glenebob@nwlink.com> writes:
>   ERROR:  Unable to identify an operator '=' for types 'character' and
> 'character varying'

The reason it's unhappy is that it has no reasonable way to make a
choice between using char and varchar comparison (which are not the
same; the former is insensitive to trailing blanks).  You need a
cast to tell it what to do.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Lost Access To Table
Next
From: "Booth, Robert"
Date:
Subject: Re: Lost Access To Table