Lynn David Newton wrote:
> insert into abc
> (c2, lab, dlab, bdigits) values
> (5, 'somestring', 'abc123', 3410999762);
>
> psql returns to me this message:
>
> psql: ... ERROR: Unable to identify an operator '=' for types 'int4' and 'text'
> You will have to retype this query using an explicit cast
>
Try:
insert into abc
(c2, lab, dlab, bdigits) values
(5, 'somestring', 'abc123', 3410999762::bigint);
or even:
insert into abc
(c2, lab, dlab, bdigits) values
(5, 'somestring', 'abc123', '3410999762');
HTH,
Joe