Re: How to put multiples results in just one column

Поиск
Список
Период
Сортировка
От Nei Rauni Santos
Тема Re: How to put multiples results in just one column
Дата
Msg-id CADRPEPAiXjpCJ4KTVMJve5Amf4fFPWW6y2Piv4_0JAfZt3cJcA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to put multiples results in just one column  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: How to put multiples results in just one column  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-sql
<div dir="ltr"><div class="gmail_extra">Thank you Pavel,<br /><br /></div><div class="gmail_extra">I could do that like
this:<br/><br /><br />select <a href="http://p.id">p.id</a>, <br /><br />( select array_accum ((<br />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_min_stay<br />
)::cms.room_availability_list_type)<br />from cms.sp_get_supplier_availability(2, '2013-02-01', '2013-02-05', 'pt_BR',
1,'{1}')<br />) room <br />from wr.prestadores p <br />where <a href="http://p.id">p.id</a> = 2;<br /><br />the only
problemis that it takes about 2293 ms for just one result.<br /><br /><br /></div><div class="gmail_extra">Any idea
aboutthe more effective way to do that?<br /></div><div class="gmail_extra"><br /><br /></div><div
class="gmail_extra"><br/></div><div class="gmail_extra"><br /><br /><div class="gmail_quote">On Thu, Jan 31, 2013 at
10:39AM, Pavel Stehule <span dir="ltr"><<a href="mailto:pavel.stehule@gmail.com"
target="_blank">pavel.stehule@gmail.com</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin:0px 0px
0px0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">fce</blockquote></div><br /><br /><br clear="all"
/><br/>-- <br />[]s!!<br /><br />Nei<br /><br /></div></div> 

В списке pgsql-sql по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: How to put multiples results in just one column
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: How to put multiples results in just one column