Re: Casting help - Mailing list pgsql-general

From Tom Lane
Subject Re: Casting help
Date
Msg-id 21384.982009155@sss.pgh.pa.us
Whole thread Raw
In response to Casting help  ("Mitch Vincent" <mitch@venux.net>)
List pgsql-general
"Mitch Vincent" <mitch@venux.net> writes:
> if I try to cast minority to varchar (or anything else for that matter) I
> get
> ERROR:  Cannot cast type 'bool' to 'varchar'

There's always

    CASE WHEN minority THEN 't' ELSE 'f' END

            regards, tom lane

pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: Trigger/Function Problem
Next
From: "Jonas Delfs"
Date:
Subject: createuser in pgsql