https://forum.postgresql.org.pl/viewtopic.php?id=392 Thu, 04 Feb 2010 12:30:23 +0000 PunBB https://forum.postgresql.org.pl/viewtopic.php?pid=1796#p1796 1 then ('%'||upper(zmienna)||'%') else null end ) group by slowo,opis, dodal Pozdrawiam.]]> Thu, 04 Feb 2010 12:30:23 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=1796#p1796 https://forum.postgresql.org.pl/viewtopic.php?pid=1794#p1794 Thu, 04 Feb 2010 06:56:19 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=1794#p1794 https://forum.postgresql.org.pl/viewtopic.php?pid=1791#p1791 Wed, 03 Feb 2010 15:08:32 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=1791#p1791 https://forum.postgresql.org.pl/viewtopic.php?pid=1790#p1790 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 ?]]> Wed, 03 Feb 2010 13:02:23 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=1790#p1790