Thread

Re: [GENERAL] ODBC-client->Linux-server: datatype boolean not recognized?

Jose Soares <jose@sferacarta.com> — 1999-10-01T15:14:33Z

oh! this was for old releases, now I'm using the following:

create function MsBool(bool,int4) returns bool as '
declare
        bool_int int4;
begin
        if $1 is NULL then
                return NULL;
        end if;
        if $1 is TRUE then
             if $2 <> 0 then
                 return TRUE;
             end if;
        else
            if $2 = 0 then
                 return TRUE;
            end if;
         end if;
         return FALSE;
end;
' language 'plpgsql';

create operator = (
        leftarg=bool,
        rightarg=int4,
        procedure=MsBool,
        commutator='=',
        negator='!=',
        restrict=eqsel,
        join=eqjoinsel
        );



Moray McConnachie ha scritto:

> >create function MsAccessBool(bool,int4)  returns bool
> >  as '' language 'internal';
>
> There is surely something missing here, between the empty single
> quotes? When I execute that, I get "There is no internal function
> msaccessbool"