https://forum.postgresql.org.pl/viewtopic.php?id=1225 Wed, 15 Feb 2012 22:17:20 +0000 PunBB https://forum.postgresql.org.pl/viewtopic.php?pid=3445#p3445 Wed, 15 Feb 2012 22:17:20 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3445#p3445 https://forum.postgresql.org.pl/viewtopic.php?pid=3444#p3444 1) Then patrząc do dokumentacji nie mogę się doszukać funkcji array_length [url]http://www.postgresql.org/docs/8.3/static/functions-array.html[/url] wersji 8.3 nie mogę zmienić. po zamianie na array_upper mam błąd ERROR: set-valued function called in context that cannot accept a set [code] Select Case When (array_upper(dane_array, 1) > 1) Then dane_array[1]::text || '-' || dane_array[array_upper(dane_array, 1)]::text Else dane_array[1]::text End From (Select string_to_array(split, ',')::int[] As dane_array From (Select regexp_split_to_table(regexp_replace(array_agg(dane.nr_szt)::text, '[{}]', '', 'g'), '(,NULL)+,') As split From dane Right Join (Select nr_szt From generate_series((Select min(nr_szt) From dane), (Select max(nr_szt) From dane)) nr_szt) rs On dane.nr_szt = rs.nr_szt) ds ) s; [/code]]]> Wed, 15 Feb 2012 18:19:53 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3444#p3444 https://forum.postgresql.org.pl/viewtopic.php?pid=3436#p3436 1) Then dane_array[1]::text || '-' || dane_array[array_length(dane_array, 1)]::text Else dane_array[1]::text End From (Select string_to_array(split, ',')::int[] As dane_array From (Select regexp_split_to_table(regexp_replace(array_agg(dane.nr_szt)::text, '[{}]', '', 'g'), '(,NULL)+,') As split From dane Right Join (Select nr_szt From generate_series((Select min(nr_szt) From dane), (Select max(nr_szt) From dane)) nr_szt) rs On dane.nr_szt = rs.nr_szt) ds ) s;[/code]]]> Wed, 15 Feb 2012 10:37:09 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3436#p3436 https://forum.postgresql.org.pl/viewtopic.php?pid=3435#p3435 Wed, 15 Feb 2012 08:15:05 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3435#p3435 https://forum.postgresql.org.pl/viewtopic.php?pid=3434#p3434 1) Then dane_array[1]::text || '-' || dane_array[array_length(dane_array, 1)]::text Else dane_array[1]::text End From (Select string_to_array(split, ',')::int[] As dane_array From dane_split) s;[/code] Wynik: [code] dane_array ------------ 1-4 9-12 20-25 (3 rows)[/code] Druga możliwość jaką widzę, to użycie języka proceduralnego np. PL/pgSQL, ale tam też trzeba się trochę napisać.]]> Tue, 14 Feb 2012 22:19:27 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3434#p3434 https://forum.postgresql.org.pl/viewtopic.php?pid=3428#p3428 Tue, 14 Feb 2012 12:30:08 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3428#p3428