Re: SELECT bug?

Dnia 06/26/2003 11:12 PM, Ace napisa³(a):
> 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