Using case or if to return multiple rows - Mailing list pgsql-sql

From Ashish Karalkar
Subject Using case or if to return multiple rows
Date
Msg-id 005401c7c450$3d6670e0$170211ac@LIONKING.COM
Whole thread Raw
Responses Re: Using case or if to return multiple rows  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: Using case or if to return multiple rows  (Ragnar <gnari@hive.is>)
List pgsql-sql
Hello all,
 
 
I want to select data from two diffrent table based on third tables column
somthing like:
 
 
select case when  t3.date='xxxx' then
                    select * from table1
 
else
                    select * from table 2
       
 from table3  t3             where t3.date='xxxxx'
 
 
Problem is that I have to do it in Plain SQL.
 
Is there a anyway.
 
Thanks in Advance
 
With egards
Ashish....
 

pgsql-sql by date:

Previous
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: linux
Next
From: "Pavel Stehule"
Date:
Subject: Re: Using case or if to return multiple rows