2013/1/31 Nei Rauni Santos :
> Thank you Pavel,
>
> I could do that like this:
>
>
> select p.id,
>
> ( select array_accum ((
> room_name, room_id, room_group_name, room_group_id, room_order,
> availability_min, price_amount, price_min, price_avg, price_balcony_amount,
> price_balcony_avg, capacity
Thank you Pavel,
I could do that like this:
select p.id,
( select array_accum ((
room_name, room_id, room_group_name, room_group_id, room_order,
availability_min, price_amount, price_min, price_avg, price_balcony_amount,
price_balcony_avg, capacity, deposit_required, breakfast_included,
room_mi
Hello
select (fce(..)).column from ...
or select column from fce()
Regards
Pavel Stehule
2013/1/31 Nei Rauni Santos :
> Hi,
>
> The problem is, I'm working in a list of hotels which should have
> availability of rooms and list the hotel and its rooms on the application.
>
> I have this functio
Hi,
The problem is, I'm working in a list of hotels which should have
availability of rooms and list the hotel and its rooms on the application.
I have this function which already is used to get the rooms available
select cms.sp_get_supplier_availability(2, '2013-02-01', '2013-02-02',
'pt_BR', 1
