Type casting bool as int4?

From: phil(at)Stimpy(dot)netroedge(dot)com
To: pgsql-sql(at)postgresql(dot)org
Subject: Type casting bool as int4?
Date: 2000-02-12 01:52:50
Message-ID: 20000211175250.N14052@Stimpy.netroedge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


This seems like it would be simple, but I'm having troubles getting it
to work. All I wish to do is have Postgresql return '0' or '1'
instead of 'f' or 't' for bool types. This would simplify life for me
since I'm trying to dump these values right into expressions outside
of the context of SQL. Right now my parsers are choking on the 't's
and 'f's from PostgreSQL.

I've tried:

select mybool::int4;

But, I get,

ERROR: function int4(bool) does not exist

Hummm.... I want to do something like:

select (mybool?1:0);

But, that's not the right syntax. I'd love to be able to get this
working w/o defining new functions or types (i.e., make it portable).

Ideas? I've poured over the documentation and the current function
and operators, but this doesn't seem to be implemented?!

Thanks!

Phil

--
Philip Edelbrock -- IS Manager -- Edge Design, Corvallis, OR
phil(at)netroedge(dot)com -- http://www.netroedge.com/~phil
PGP F16: 01 D2 FD 01 B5 46 F4 F0 3A 8B 9D 7E 14 7F FB 7A

Browse pgsql-sql by date

  From Date Subject
Next Message phil 2000-02-12 02:16:10 subscribe
Previous Message Tom Lane 2000-02-11 23:08:43 Re: [SQL] Techniques for quickly finding words in a phrase...