Re: [SQL] Converting varchar to bool

2005-06-15 Thread Bruno Wolff III
On Wed, Jun 15, 2005 at 14:14:46 +0200, KÖPFERL Robert <[EMAIL PROTECTED]> wrote: > Hi, > > > I have currently trouble working with boolean values and variables in > functions. > > As one would expect, a > select '1'::bool, 't'::bool, 'true'::unknown::boolean > > works. > > As a select '1'

[SQL] Converting varchar to bool

2005-06-15 Thread KÖPFERL Robert
Hi, I have currently trouble working with boolean values and variables in functions. As one would expect, a select '1'::bool, 't'::bool, 'true'::unknown::boolean works. As a select '1' tells us this seems as a conversion unknown->bool or ??maybe?? a boolean literal?? what-o-ever, at least my