Skip site navigation (1) Skip section navigation (2)

Re: Logical comparison on Strings

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: kumar <sgnerd(at)yahoo(dot)com(dot)sg>
Cc: pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Logical comparison on Strings
Date: 2004-04-27 10:16:02
Message-ID: 408E32E2.1030709@trade-india.com (view raw or flat)
Thread:
Lists: pgsql-sql
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



In response to

pgsql-sql by date

Next:From: Paul ThomasDate: 2004-04-27 11:42:13
Subject: Re: Performance issue
Previous:From: Marcus KrauseDate: 2004-04-27 09:55:33
Subject: Problem with a "blocking period" Trigger

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group