Postgres: check if array field contains value?

by

This should work:

select * from mytable where 'Journal'=ANY(pub_types);

i.e. the syntax is <value> = ANY ( <array> ). Also notice that string literals in postresql are written with single quotes.

More Related Contents:

  1. Why the “Group BY” by month didn’t work? [closed]
  2. What to do with null values when modeling and normalizing?
  3. Postgres: INSERT if does not exist already
  4. postgres default timezone
  5. quick random row selection in Postgres
  6. How to close idle connections in PostgreSQL automatically?
  7. postgresql – replace all instances of a string within text field
  8. Is it possible to have autoincrement number without it being an ID?
  9. PostgreSQL: Modify OWNER on all tables simultaneously in PostgreSQL
  10. pgadmin4 : postgresql application server could not be contacted.
  11. PostgreSQL error ‘Could not connect to server: No such file or directory’
  12. Insert if not exists, else return id in postgresql
  13. function returns multiple columns as a single column instead of multiple columns
  14. Sequences not affected by transactions?
  15. Postgres FOR LOOP
  16. Storing Images in PostgreSQL
  17. Psql could not connect to server: No such file or directory, 5432 error?
  18. Strange behaviour in Postgresql
  19. Postgres: Distinct but only for one column
  20. In PostgreSQL, how to insert data with COPY command?
  21. Cursor based records in PostgreSQL
  22. Maximum characters in labels (table names, columns etc)
  23. Configuration parameter work_mem in PostgreSQL on Linux
  24. How to work with PGpoint for Geolocation using PostgreSQL?
  25. PostgreSQL disable more output
  26. PostgreSQL array_agg order
  27. Postgres table column name restrictions?
  28. PostgreSQL jsonb, `?` and JDBC
  29. Syntax error at end of input in PostgreSQL
  30. Error when pushing data to Heroku: time zone displacement out of range

Leave a Comment