Re: explicit cast error - Mailing list pgsql-general

From Thomas Lockhart
Subject Re: explicit cast error
Date
Msg-id 3D25B885.31B9BF65@fourpalms.org
Whole thread Raw
In response to explicit cast error  (Lynn David Newton <lynn.newton@cox.net>)
List pgsql-general
> 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 surrounding the bigint integer with single quotes.

                   - Thomas



pgsql-general by date:

Previous
From: Josh Jore
Date:
Subject: Re: two primairy key in one table ?
Next
From: David A Dickson
Date:
Subject: Re: two primairy key in one table ?