From with case - Mailing list pgsql-sql

Hi everyone, 

I'm working in a PL/SQL and I'd like to use the same PL for 2 kinds of tables...

I have "valepag" and "valerec" both tables have the same columns, but one is for debit and the other one is for credit, the PL will work for both cases

with the unique diference for the name of the table...

So I thought to use something like this:

...

For rSql in select a.adiant,
                   a.desc_per
              from case
                      when cTip='P'
                      then valapag
                      else valerec
                   end
             where cod=2 Loop

...

But it just dont work... does some one have other solution for this case ?

Thanks guys.

-- 
Grato,
Mauricio Cruz
Sygecom Informática
51 3442-3975 / 3442-2345