Функция	                 Аргументы	Возвращаемое значение	Язык
calc_traf_by_tarif_time	integer	traf_by_ttime                 	plpgsql
Определение
declare 
 tt_traf traf_by_ttime%rowtype;
 tid integer;
begin
 tid =  1 ;
 tt_traf.client_id = tid;
 tt_traf.t_interval = '00:00-01:59';
 tt_traf.incoming = tid *  100 ;
 tt_traf.outgoing = tid *  10 ;
 tt_traf.traf_price = tid * 5 ;
  return  tt_traf; 
end;
Свойства
 VOLATILE 
CALLED ON  NULL  INPUT
SECURITY INVOKER

Поле	        Тип данных	
client_id	integer	
t_interval	character varying	
incoming	bigint	входящий 
outgoing	bigint	выходящий 
traf_price	 double  precision

 public   class  TrafByTTimeType  implements  UserType

 public   class  TrafByTTime
 implements  Serializable, Cloneable

...
   private  Integer clientId;
   private  String timeInterval;
   private  BigInteger incoming;
   private  BigInteger outgoing;
   private   Double  trafPrice;
....

 public   class  HTest1
{
     public   static   void  main(String[] args)  throws  ParseException
    {
        Session session = HibernateUtil.getSessionFactory().openSession();

        TrafByTTime test = (TrafByTTime) session.createSQLQuery("select * from    calc_traf_by_tarif_time(1)").uniqueResult();