Why doesn't the where query work in postgresql?

Question

I have a ruby on rails app in which I am querying for a boolean column, Flag. The code is:

Merchant.where("Flag=?",false)

However this does not work at all and the only result is that the Merchants table does not have a column name "flag". Is there any way to fix this? The column name starts with an uppercase letter, but the search is being done for a lower case "flag"

And is it "Flag" or "flag"? In RoR the convention is to use lower-case letters. — Behrang Saeedzadeh
– Behrang Saeedzadeh, Commented Sep 28, 2011 at 4:10

mu is too short · Accepted Answer · 2011-09-28 04:08:01Z

1

If the column name was quoted when the table was created then you will have to quote it forever. So, if you started with this:

create table merchants (
    -- ...
    "Flag" boolean
    -- ...
)

Then you'll have to refer to it using

Merchant.where('"Flag" = ?', false)

PostgreSQL normalizes all unquoted identifiers to lower case (not upper case as the standard says), that's why the error message complains about flag rather than Flag.

If you can, you might want to rebuild your table with only lower case column names.

edited Sep 28, 2011 at 4:08

answered Sep 28, 2011 at 3:46

mu is too short

436k71 gold badges863 silver badges822 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why doesn't the where query work in postgresql?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related