Re: [ask] Boolean type in SELECT statement

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 16 Apr 1999 03:27:07 GMT
Message-ID: <3716ada3.1085124@netnews.worldnet.att.net>

Phil,

SQL doesn't recognize BOOLEAN as a valid datatype. Even though you can write a PL/SQL function to return true or false, you can't use that return value in a SQL query. You might try returning 0 or 1 instead.

Jonathan

---

Jonathan Gennick
jonathan_at_gennick.com -- Brighten the corner where you are. http://gennick.com

On Thu, 15 Apr 1999 18:44:43 -0700, "earthlink" <phil_at_amax.com> wrote:

>can any tell me how to apply boolean type in SELECT statement?
>
>e.g.
>
>SELECT *
>FROM my_table
>WHERE my_boolean_func(my_table.applied_field) = true
>
> " my_boolean_func " will return either true or false.
Received on Thu Apr 15 1999 - 22:27:07 CDT