Home > mailing lists

Logical comparison on Strings - Mailing list pgsql-sql

From	kumar
Subject	Logical comparison on Strings
Date	April 27, 2004 06:12:39
Msg-id	008801c42c1e$b70efbb0$7502a8c0@hdsc.com Whole thread Raw
Responses	Re: Logical comparison on Strings
List	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

From: Rod Taylor
Date: 26 April 2004, 22:48:56
Subject: Re: problem with slow select

From: "kumar"
Date: 27 April 2004, 06:54:03
Subject: Customised Encoding