Logical comparison on Strings

From: "kumar" <sgnerd(at)yahoo(dot)com(dot)sg>
To: "pgsql" <pgsql-sql(at)postgresql(dot)org>
Subject: Logical comparison on Strings
Date: 2004-04-27 06:13:08
Message-ID: 008801c42c1e$b70efbb0$7502a8c0@hdsc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message kumar 2004-04-27 06:54:03 Customised Encoding
Previous Message Rod Taylor 2004-04-26 18:58:00 Re: problem with slow select