tag:blogger.com,1999:blog-4173450620182357167.post4475489697811025935..comments2024-03-23T21:34:53.756+08:00Comments on class Programmer implements ANiceHumble, Person {: Postgresql unnest function can do many wondersIEnableMuchhttp://www.blogger.com/profile/01393635235961303977noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4173450620182357167.post-15333702873122377762019-09-24T15:43:10.678+08:002019-09-24T15:43:10.678+08:00Sorry for late reply. Your comment is mistakenly f...Sorry for late reply. Your comment is mistakenly flagged as spam by blogspot.<br /><br />Yes select z from x where 8 = all(z) would work too. However, it would fail if the variable for 8 has null value instead.<br /><br />The last suggested query is the least invasive when it comes to substitution of values on query string be the value is non-null or nullIEnableMuchhttps://www.blogger.com/profile/01393635235961303977noreply@blogger.comtag:blogger.com,1999:blog-4173450620182357167.post-10462516156678705652018-11-24T21:11:37.344+08:002018-11-24T21:11:37.344+08:00Very help, thanks. I followed this link from stac...Very help, thanks. I followed this link from stack. I'm pretty new to unnest but loving it. Question - for this last query using b=8, can't that be done just with select z from x where 8 = ALL(z) ? ThanksAnonymoushttps://www.blogger.com/profile/13508330059440545797noreply@blogger.com