Compare field with value and return bool

sql postgresql npgsql
Arman Hayots picture Arman Hayots · Jun 11, 2012 · Viewed 13.8k times · Source

I'm trying move hash cheking from server app to PostgreSQL. In other words I'm need calling a query to PGSQL, which compare string from query with string from field and return result of equal comparison as bool, but I don't know how do this without procedures on clear SQL.

upd: I have table users with field password(currently text, in the future - bytea). I want write sometihng like 

select * from values ('WrittenPassword' = users.password) where username = 'someuser' ,

which must return true or false as result of equal comparison.

Answer

Zane Bien picture Zane Bien · Jun 11, 2012

You can use a CASE statement to return certain values based on a condition:

SELECT 
    (CASE WHEN password = 'WrittenPassword' THEN 1 ELSE 0 END) AS is_equal
FROM
    users
WHERE
    username = 'someuser'

Related questions

How to query column names dynamically using Postgres/NpgSQL

I have a filter object to query a table with many columns, and rather than write a condition covering all columns (allowing for optional filtering) like this: WHERE ((:value0 IS NULL) OR (column_name0 = :value0)) AND ((:value1 IS NULL) OR (…

Read More
PostgreSQL - best way to return an array of key-value pairs

I'm trying to select a number of fields, one of which needs to be an array with each element of the array containing two values. Each array item needs to contain a name (character varying) and an ID (numeric). I …

Read More
Postgres BIGINT out of range

I'm discovering a new world with PostgreSQL but while transefering a Firebird 2.1 database to PostgreSQL 9.3 i've encountered folowing error BIGINT out of range: I've checked the Min and Max values from import statement and they fit in Bigint and could …

Read More