PSql won't Let me Set Varchar Column to 'true'

From: Hunter Hillegas <lists(at)lastonepicked(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: PSql won't Let me Set Varchar Column to 'true'
Date: 2004-08-27 23:58:08
Message-ID: BD5518A0.37A6C%lists@lastonepicked.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have two varchars on my table...

I tried to run the following:

VMGEngine=# update user_account set editor_status = 'true' and
administrator_status = 'true' where rec_num = 20;
ERROR: column "editor_status" is of type character varying but expression
is of type boolean

I was expecting the single quotes to tell psql to treat the data as a
string, not a constant boolean value.

Can I coerce psql to do what I would like it to?

Hunter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2004-08-28 00:08:11 Re: PSql won't Let me Set Varchar Column to 'true'
Previous Message Marc G. Fournier 2004-08-27 23:15:27 Re: [OT?] Problems with majordomo :-)