On Thu, 6 Dec 2018 at 19:27, Laurenz Albe <laurenz.a...@cybertec.at> wrote: > > Replace > > COLLATE pg_catalog."default" > > with > > ::integer
which results in syntax error at or near "::" LINE 2: ...'::text) -> 'pub_info'::text) ->> '@pubyear'::text)::integer moving the ::integer into the bracket also: syntax error at end of input LINE 2: ...'::text) -> 'pub_info'::text) ->> '@pubyear'::text::integer) ^ I have tried this before. Thanks for your try. Regards Johann
