<![CDATA[Forum PostgreSQL - Problem z select case]]>2010-02-04T12:30:23ZPunBBhttps://forum.postgresql.org.pl/viewtopic.php?id=392<![CDATA[Odp: Problem z select case]]>1 then ('%'||upper(zmienna)||'%')
else null
end
)
group by slowo,opis, dodal
Pozdrawiam.]]>https://forum.postgresql.org.pl/profile.php?id=9592010-02-04T12:30:23Zhttps://forum.postgresql.org.pl/viewtopic.php?pid=1796#p1796<![CDATA[Odp: Problem z select case]]>https://forum.postgresql.org.pl/profile.php?id=9592010-02-04T06:56:19Zhttps://forum.postgresql.org.pl/viewtopic.php?pid=1794#p1794<![CDATA[Odp: Problem z select case]]>https://forum.postgresql.org.pl/profile.php?id=262010-02-03T15:08:32Zhttps://forum.postgresql.org.pl/viewtopic.php?pid=1791#p1791<![CDATA[Problem z select case]]>1 then ( select slowo from f.slownik_opis a join f.slownik_slowo b on a.id=b.id where b.slowo like '%z1%')
else null
---(select slowo from f.slownik_opis a join f.slownik_slowo b on a.id=b.id where b.slowo like '-1')
end,
case
when 'z1'='-1' then opis
when (SUM(CHAR_LENGTH('z1')))>1 then ( select opis from f.slownik_opis a join f.slownik_slowo b on a.id=b.id where b.slowo like '%z1%')
else null
--( select opis from f.slownik_opis a join f.slownik_slowo b on a.id=b.id where b.slowo like '-1')
end,
case
when 'z1'='-1' then dodal
when (SUM(CHAR_LENGTH('z1')))>1 then ( select dodal from f.slownik_opis a join f.slownik_slowo b on a.id=b.id where b.slowo like '%z1%')
else null
-- (select dodal from f.slownik_opis a join f.slownik_slowo b on a.id=b.id where b.slowo like '-1')
end
from f.slownik_opis a join f.slownik_slowo b on a.id=b.id where slowo like (upper('%-1%'))
group by b.slowo,a.opis, dodal
ERROR: more than one row returned by a subquery used as an expression
Problem jest jak jedno slowo(czyli zmienna z1) ma dwa opisy.
Jak zbudować funkcję żeby dało się wykonać ten warunek ? Niestety odpada CREATE FUNCTION.
Jakieś podpowiedzi ?]]>https://forum.postgresql.org.pl/profile.php?id=9592010-02-03T13:02:23Zhttps://forum.postgresql.org.pl/viewtopic.php?pid=1790#p1790