ERROR: operator does not exist: integer = integer[]
| От | cesar_cast |
|---|---|
| Тема | ERROR: operator does not exist: integer = integer[] |
| Дата | |
| Msg-id | 1334178085476-5634039.post@n5.nabble.com обсуждение |
| Ответы |
Re: ERROR: operator does not exist: integer = integer[]
|
| Список | pgsql-sql |
I have the following select * from employee AS e where (e.id) IN (ARRAY[3,1]); I have the following mistake ERROR: operator does not exist: integer = integer[] LINE 3: where (e.id) IN (ARRAY[3,1]); ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. ********** Error ********** ERROR: operator does not exist: integer = integer[] SQL state: 42883 Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Character: 45 Can anybody explain me? -- View this message in context: http://postgresql.1045698.n5.nabble.com/ERROR-operator-does-not-exist-integer-integer-tp5634039p5634039.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
В списке pgsql-sql по дате отправления: