Thread: Logical comparison on Strings

Logical comparison on Strings

From
"kumar"
Date:
Dear Friends,
 
Postgres 7.3.2 on Linux 7.
 
I want to compare to columns and get the logical result as follows.
 
C1 is 'YNYNY' . C2 is 'NNYYY'.
 
I want to compare like AND and OR operators.
 
C1 AND C2 should give result like NNYNY.
C1 OR C2 should give result like YNYYY.
 
Please shed some light.
 
Thanks
Kumar

Re: Logical comparison on Strings

From
Rajesh Kumar Mallah
Date:
kumar wrote:

> Dear Friends,
>  
> Postgres 7.3.2 on Linux 7.
>  
> I want to compare to columns and get the logical result as follows.
>  
> C1 is 'YNYNY' . C2 is 'NNYYY'.
>  
> I want to compare like AND and OR operators.
>  
> C1 AND C2 should give result like NNYNY.
> C1 OR C2 should give result like YNYYY.



Bit String Types in PostgreSQL may be what you are
looking for.

btw: what is linux 7?



>  
> Please shed some light.
>  
> Thanks
> Kumar