Postgres Pro
Downloads
Home   >   mailing lists

Thread: Query On Case structure

Query On Case structure

From
"Dinesh Parikh"
Date:
Hi All,
Can we create a query to find different values based on different criteria from a table using case structure. For example
 
Select Into DBComment
        Case When localComment Is Null Then Comment
                When localComment = '123' Then 'Numeric Comment'
                Else 'String Comment'
        End    
From PDBUser
Where UserIndex = 23;
 
Using such type of structure can we evaluate multiple values. e.g
 
Select DBComment , DBName
        Case When localComment Is Null Then Comment
                When localComment = '123' Then 'Numeric Comment'
                Else 'String Comment'
        End,   
        Case When localName Is Null Then UserName
                When localName = 'SuperUser' Then 'Supervisor'
                Else 'NormalUser'
        End    
From PDBUser
Where UserIndex = 23;
 
 
Is this possible. If yes then How is it.
Any help/suggestion may be benificial.
 
Regards
Dinesh Parikh
NSTL New Delhi

Re: Query On Case structure

From
Haller Christoph
Date:
> 
> Hi All,
> Can we create a query to find different values based on different criteria =
> from a table using case structure. For example
> Select Into :DBComment        Case When localComment Is Null Then Comment             When localComment = '123' Then
'NumericComment'             Else 'String Comment'        Endfrom PDBUserWhere UserIndex = 23;
 
> 
> Using such type of structure can we evaluate multiple values. e.g
> Select DBComment , DBName,         Case When localComment Is Null Then Comment             When localComment = '123'
Then'Numeric Comment'             Else 'String Comment'        End,        Case When localName Is Null Then UserName
        When localName = 'SuperUser' Then 'Supervisor'             Else 'NormalUser'        Endfrom PDBUserWhere
UserIndex= 23;
 
> 
> 
> Is this possible. If yes then How is it.
> Any help/suggestion may be benificial.
> 
> Regards
> Dinesh Parikh
> NSTL New Delhi
> 
Looks fine to me. What do you want by asking "If yes then How is it." 
Run the query and have a look on the result. 
Regards, Christoph