Re: incorrect syntax for 'plpgsql' function to test boolean - Mailing list pgsql-sql

From Ferindo Middleton Jr
Subject Re: incorrect syntax for 'plpgsql' function to test boolean
Date
Msg-id 42F59B30.7080807@verizon.net
Whole thread Raw
In response to Re: incorrect syntax for 'plpgsql' function to test boolean values  (John DeSoi <desoi@pgedit.com>)
List pgsql-sql
Yeah, I guess so..... I just didn't want the compiler to think I was 
trying to assign the value..... And I also figured out that instead of 
the &&, I needed to just say AND.... Thanks.

Ferindo

John DeSoi wrote:

>
> On Aug 6, 2005, at 10:52 PM, Ferindo Middleton Jr wrote:
>
>> ERROR:  operator does not exist: boolean == boolean
>> HINT:  No operator matches the given name and argument type(s). You  
>> may need to add explicit type casts.
>> CONTEXT:  SQL statement "SELECT  (( $1  == true) && ( $2  == true))"
>> PL/pgSQL function  
>> "trigger_insert_update_registration_and_attendance" line 13 at if
>>
>> What is wrong with my syntax above?
>>
>
> Too much C programming :). You just want a single equal sign.
>
> select true = true;
> ?column?
> ----------
> t
> (1 row)
>
>
>
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
>

-- 
Ferindo Middleton
Chief Architect
Sleekcollar.com



pgsql-sql by date:

Previous
From: John DeSoi
Date:
Subject: Re: incorrect syntax for 'plpgsql' function to test boolean values
Next
From: Mischa Sandberg
Date:
Subject: Re: sum but not grouped by?