Ehh, to clarify I'm referring to the lone _double_ quotation mark at the end of the condition 'health'<>''. I called it a "single quotation mark" because it was a quotation mark all by itself, but realize that could be misread. Single quotation marks are technically this: ' Sorry for the newbie spam -- I can't run less-than/greater-than/quotation marks through Google for answers. On 4/29/14, David Noel <david.i.noel@xxxxxxxxx> wrote: >> select p.*, s.NoOfSentences >> from page p, >> lateral (select count(*) as NoOfSentences >> from sentence s >> where s."PageURL" = p."URL") s >> where "Classification" like case ... end >> order by "PublishDate" desc >> limit 100; > > Great. Thanks so much! > > Could I make it even simpler and drop the case entirely? > > select p.*, s.NoOfSentences > from page p, > lateral (select count(*) as NoOfSentences > from sentence s > where s."PageURL" = p."URL") s > where "Classification" like 'health' > order by "PublishDate" desc > limit 100; > > I'm not sure what "case WHEN 'health'<>'' THEN 'health' ELSE '%' end" > does. I follow everything just fine until I get to the 'health'<>'' > condition. What does the single quotation mark mean? I can't seem to > find it in the documentation. > > -David > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
