Re: explicit cast error - Mailing list pgsql-general

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