Fastest check if row exists in PostgreSQL

by

Use the EXISTS key word for TRUE / FALSE return:

select exists(select 1 from contact where id=12)

More Related Contents:

  1. PostgreSQL “Column does not exist” but it actually does
  2. Is SELECT or INSERT in a function prone to race conditions?
  3. Any downsides of using data type “text” for storing strings?
  4. Index for finding an element in a JSON array
  5. Query for array elements inside JSON type
  6. Calculating Cumulative Sum in PostgreSQL
  7. What is the expected behaviour for multiple set-returning functions in SELECT clause?
  8. Is it possible to make a recursive SQL query?
  9. Change PostgreSQL columns used in views
  10. Way to try multiple SELECTs till a result is available?
  11. How to set auto increment primary key in PostgreSQL?
  12. List columns with indexes in PostgreSQL
  13. PostgreSQL IF statement
  14. Split given string and prepare case statement
  15. Division of integers returns 0
  16. Postgres not using index when index scan is much better option
  17. SQL update fields of one table from fields of another one
  18. How to store array or multiple values in one column
  19. convert Postgres geometry format to WKT
  20. Which datatype should be used for currency?
  21. How to return two columns with function
  22. COPY with dynamic file name
  23. Table or column name cannot start with numeric?
  24. Count cumulative total in Postgresql
  25. PostgreSQL column ‘foo’ does not exist
  26. Prepared Statement on Postgresql in Rails
  27. SELECT DISTINCT is slower than expected on my table in PostgreSQL
  28. How to use SQL LIKE condition with multiple values in PostgreSQL?
  29. Why isn’t row level security enabled for Postgres views?
  30. Is there a postgres CLOSEST operator?

Leave a Comment