pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Logical comparison on Strings
2+ messages / 2 participants
[nested] [flat]

* Logical comparison on Strings
@ 2004-04-27 06:13 kumar <sgnerd@yahoo.com.sg>
  2004-04-27 10:16 ` Re: Logical comparison on Strings Rajesh Kumar Mallah <mallah@trade-india.com>
  0 siblings, 1 reply; 2+ messages in thread

From: kumar @ 2004-04-27 06:13 UTC (permalink / raw)
  To: pgsql-sql

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Logical comparison on Strings
  2004-04-27 06:13 Logical comparison on Strings kumar <sgnerd@yahoo.com.sg>
@ 2004-04-27 10:16 ` Rajesh Kumar Mallah <mallah@trade-india.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Rajesh Kumar Mallah @ 2004-04-27 10:16 UTC (permalink / raw)
  To: kumar <sgnerd@yahoo.com.sg>; +Cc: 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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2004-04-27 10:16 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-27 06:13 Logical comparison on Strings kumar <sgnerd@yahoo.com.sg>
2004-04-27 10:16 ` Rajesh Kumar Mallah <mallah@trade-india.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox