Postgres NOT in array

Postgres NOT in array

Asked on January 10, 2019 in PostgreSQL.
Add Comment


  • 2 Answer(s)

    Below solution for theĀ Postgres NOT in array

    SELECT COUNT(*) FROM "messages" WHERE NOT (3 = ANY (recipient_ids))
    
    

    always annihilate WHERE (condition) with WHERE NOT (condition)

     

    Answered on January 10, 2019.
    Add Comment

    Use this command

    not (3 = any(recipient_ids))?
    
    
    Answered on January 10, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.