Postgres Pro
Downloads
Home   >   mailing lists

decode or case statements - Mailing list pgsql-sql

From Priya, Nagappan (N.)
Subject decode or case statements
Date
Msg-id 4F3E93DA9F76D6118A2A0002B330C40C040B7ECC@ap1sgm01.singapore.ford.com
Whole thread Raw
List pgsql-sql
Tree view 
Hi,
Please help me in forming a select statement using decode functionality or case in oracle and sql seperately.

The scenario is if  a field has some value like 999999 then we had to select 0 for all the through out the table .
Please give ur answersRegards
Priya.N

pgsql-sql by date:

Previous
From: Kim Petersen
Date:
Subject: problematic query (for me ;-)
Next
From: Ninonard Policarpio
Date:
Subject: postgresql installation question