|< < 39 > >|

Postgres Stored Procedures

Using the function


select 
    account_number, 
    account_type, 
    balance as dollars, 
    euros(balance)
from account

Output


 account_number | account_type | dollars | euros  
----------------+--------------+---------+--------
 2001           | checking     |  100.00 | 120.00
 2002           | savings      |  200.00 | 240.00
(2 rows)

|< < 39 > >|