The things you can do with search

You are reading a single comment by @Khornight2 and its replies. Click here to read the full conversation.

•

Khornight2

Cheers, just came back to say I'd read about sub forums in the bugs and hings thread and assumed it was because of that. Sub forums are great things, thanks for bringing them back.

•

Velocio in reply to @Khornight2

Fixed, and yeah it was subforum related.

This query was wrong:

SELECT microcosm_id
  FROM microcosms
 WHERE path <@ (
           SELECT path
             FROM microcosms
            WHERE microcosm_id = ANY ($1::bigint[])
       );

Should've been:

WITH p AS (
    SELECT path
      FROM microcosms
     WHERE microcosm_id = ANY ($1::bigint[])
)
SELECT DISTINCT m.microcosm_id
  FROM microcosms m
      ,p
 WHERE m.path <@ p.path;

Thanks for letting me know. Now fixed.

The things you can do with search

About

LFGSS