Sorry for waisting your time. I just now saw the missing period between A and publication_year which is causing the problem and explains the 'strange' result.
CREATE TABLE isi.isi_l1_publication ( article_id character varying(15), journal_id character varying(7), volume character varying(10), issue character varying(10), publication_year character varying(4), publication_date character varying(20), id bigint NOT NULL DEFAULT nextval('isi.pubtmp_id_seq'::regclass), CONSTRAINT publ_pkey PRIMARY KEY (id) ) WITH ( OIDS=FALSE );
A simple select works as expected:
select article_id, publication_year from isi.isi_l1_publication where article_id='000088352400014':
"000088352400014";"2000"
But this query (which works on a development computer):
WITH UTS AS (select art_id from isi.art_country_link where countrycode = 'ZA' INTERSECT select art_id from isi.art_country_link where countrycode = 'CH') SELECT A.article_id, A publication_year from isi.isi_l1_publication A, UTS B, isi.ritem C where B.art_id = A.article_id and A.publication_year <= '2012' and A.publication_year >= '2000' and C.ut = B.art_id and C.dt ='@ Article' order by A.publication_year;