Check the CREATE TABLE statement. Possibly you use VARCHAR type and your data has trailling spaces. Try to TRIM all the data in your database or remove trailling spaces using text editor.
I don't use VARCHAR, but TEXT type. I also checked, but there are no leading or trailing spaces.
Maybe it will be easiest when I show the table:
CREATE SEQUENCE authors_seq
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;CREATE TABLE authors (
id bigint DEFAULT nextval('authors_seq'::text) NOT NULL,
original text DEFAULT '' NOT NULL,
usable text DEFAULT '' NOT NULL
) WITHOUT OIDS;ALTER TABLE ONLY authors
ADD CONSTRAINT authors_pkey PRIMARY KEY (id);Jack
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
