Re: postgre problem

[wochter <wochter zavinac seznam bod cz>]

Moc dakujem.

-w-



Stanislav Kříž  wrote / napísal(a):
> CREATE OR REPLACE FUNCTION "public"."text_sum" (text, text) RETURNS text AS
> $body$
> SELECT CASE WHEN $1 IS NULL THEN '' ELSE $1 || ',' END || $2;
> $body$
> LANGUAGE 'sql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;
> 
> CREATE AGGREGATE "public"."sum" ( BASETYPE = "text",
> SFUNC = "public"."text_sum", STYPE = "text");
> 
> Standa
> 
> wochter napsal(a):
>> Prave ta agregacna funkcia ma najviac trapi. :-(
>>
>> -w-
>>
>>
>> Miroslav Kure  wrote / napísal(a):
>>   
>>> On Tue, Aug 12, 2008 at 10:39:39AM +0200, wochter wrote:
>>>     
>>>> Ahoj,
>>>> vopred sa ospravedlnujem za dotaz, ktory sem zrejme nepatri, ale nemam s
>>>> nim kam ist.
>>>>       
>>> Kdysi existovala konference databases zavinac linux bod cz
>>>
>>>     
>>>> Mam v postgres tabulku "zdroj":
>>>>
>>>> id  | ciselnik | hodnota
>>>> ----------------
>>>> 1   |    10    |   a
>>>> 2   |    10    |   b
>>>> 3   |    10    |   c
>>>> 4   |    20    |   d
>>>> 5   |    20    |   e
>>>> 6   |    20    |   f
>>>>
>>>> A potrebujem z toho dostat tabulku "ciel":
>>>>
>>>> ciselnik | sumar hodnot
>>>> -----------------------
>>>>    10    |  a,b,c
>>>>    20    |  d,e,f
>>>>
>>>> Viete mi s tym niekto prosim vas pomoct?
>>>> Vopred moc dakujem.
>>>>       
>>> Vytvoril bych si novou agregacni funkci, ktera bude spojovat retezce a
>>> pak bych ji pouzil takto:
>>>
>>>    select ciselnik, spoj_retezce(hodnota) from zdroj group by ciselnik
>>>
>>>     
>> ________________________________________________
>> CZdebian-l maillist  -  CZdebian-l zavinac debian bod cz
>> http://www.debian.cz/mailman/listinfo/czdebian-l
>> E-mail (un)subscriptions: czdebian-l-request zavinac debian bod cz
>>
>>
>>   
> 
> ________________________________________________
> CZdebian-l maillist  -  CZdebian-l zavinac debian bod cz
> http://www.debian.cz/mailman/listinfo/czdebian-l
> E-mail (un)subscriptions: czdebian-l-request zavinac debian bod cz
>