Re: PSql won't Let me Set Varchar Column to 'true' - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: PSql won't Let me Set Varchar Column to 'true'
Date
Msg-id 412FCE27.2080302@commandprompt.com
Whole thread Raw
In response to PSql won't Let me Set Varchar Column to 'true'  (Hunter Hillegas <lists@lastonepicked.com>)
List pgsql-general
Hunter Hillegas wrote:

>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
>
>

That is kind of weird... you could probably cast it...

editor_status = 't


>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
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL


pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: PSql won't Let me Set Varchar Column to 'true'
Next
From: Bjørn T Johansen
Date:
Subject: Introducing another primary key field?