[GitHub] [shardingsphere] liaojiexin commented on issue #25025: postgresql pagination by OFFSET FETCH

["liaojiexin (via GitHub)" <gi...@apache.org>]

liaojiexin commented on issue #25025:
URL: https://github.com/apache/shardingsphere/issues/25025#issuecomment-1499031126

   I also ran into this error。
   ```sql        
   SELECT t.*,
           CASE to_tsvector(replace(replace(w_mask,' or ',' | '),'not',' &! ')) @@
           to_tsquery(replace(replace(replace(#{mask},' or ',' | '),' not ',' &! '),')not ',')&! '))
           WHEN false THEN 0 ELSE 1 END AS writable
           FROM DS_ATTACH_NODE t
           WHERE t.STATUS != 1 and t.STATUS != 4
           AND t.pid = #{nid}
           AND to_tsvector(replace(replace(mask,' or ',' | '),'not',' &! ')) @@
           to_tsquery(replace(replace(replace(#{mask},' or ',' | '),' not ',' &! '),')not ',')&! ')) = true
           <if test="bimId !=null and bimId!=null">
               and bimid=#{bimId}
           </if>
           ORDER BY t.is_file ASC,t.sindex ASC, t.sindex NULLS LAST, t.up_date ASC limit (#{end}-#{start}) offset
           (#{start}-1)
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org