Postgresql: ARRAY: select when field value in array

Trabla:  Postgresql: ARRAY: select when field  value in array

Solving:

SELECT  
                 usr.*
FROM 
                 tbl_user AS usr
WHERE
               --- user id equals any of elements in array
                usr.id  =   ANY(    ARRAY[  123, 456, 567 ]       )

No comments:

Post a Comment