On Thu, 6 Dec 2018 at 19:27, Laurenz Albe <laurenz.albe@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