X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B2DCE5E46E7 for ; Tue, 31 Aug 2004 09:22:10 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 85528-02 for ; Tue, 31 Aug 2004 12:21:58 +0000 (GMT) Received: from 3times25.net (66-23-211-34.clients.speedfactory.net [66.23.211.34]) by svr1.postgresql.org (Postfix) with ESMTP id 48F205E46D4 for ; Tue, 31 Aug 2004 09:22:01 -0300 (ADT) Received: from [127.0.0.1] (rhws.home.edu [127.0.0.1]) by 3times25.net (Postfix) with ESMTP id F071097117 for ; Tue, 31 Aug 2004 08:22:04 -0400 (EDT) Message-ID: <41346D6C.30804@3times25.net> Date: Tue, 31 Aug 2004 08:22:04 -0400 From: Geoffrey User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.2) Gecko/20040803 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: casting BOOL to somthng References: <200408311306.25545.sad@bankir.ru> <4B1E87BC-FB36-11D8-A2A0-000A95C88220@myrealbox.com> <200408311524.16036.sad@bankir.ru> In-Reply-To: <200408311524.16036.sad@bankir.ru> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/337 X-Sequence-Number: 18834 sad wrote: > you wrote: > > >>you can use CREATE CAST to make your own cast from boolean to text. > > > thnx it helps. > > and i am still desire to know _WHY_ there are no predefined cast for BOOL ? > and at the same time there are predefined casts for INT and FLOAT...... I'd like to understand in what context you would find this useful. Don't take me wrong please. I'm by no means a db expert, but I can't see a purpose for such a cast. Can you provide a reasonable example of such usage? Thanks. -- Until later, Geoffrey Registered Linux User #108567 AT&T Certified UNIX System Programmer - 1995