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.
Regards
Johann
On 3 October 2013 10:08, Johann Spies <johann.sp...@gmail.com> wrote:
> The table definition:
>
> 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;
>
>
> delivers this result on the server:
>
> "000166055700014";"(000166055700014,35528J0,40,1-2,2000,DEC,2316393)"
> "000088352400014";"(000088352400014,12927J0,39,6,2000,JUN,30510144)"
> "000166477400015";"(000166477400015,10233J0,11,4,2000,DEC,2530188)"
> ....
>
> I have seen it once before and could not figured out what is causing it.
>
> Version: Postgresql 9.1
>
> I would like to know...
>
> Regards
> Johann
>
> --
> Because experiencing your loyal love is better than life itself,
> my lips will praise you. (Psalm 63:3)
>
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
