PostgreSQL 分页查询问题？

Question

SELECT SQL_CALC_FOUND_ROWS un.userName as name,un.fk,

    picture.headPortrait,
    CONCAT(ur.age,'岁') as age,
    substring_index(userPlace.birthPlace,' ', -1) as birthPlace,
    substring_index(userPlace.workPlace, ' ',-1) as workPlace,
    ur.sex,ur.onLine,ur.work,ur.feel,ur.constellation,ur.hobby 
    FROM xrym_user un
    INNER JOIN picture ON picture.fk = un.fk AND picture.type = 'avator'
    INNER JOIN userPlace ON userPlace.fk = un.fk
    INNER JOIN userresume ur ON ur.fk = un.fk
    WHERE un.fk > 0
      AND un.userName = COALESCE(${user['userName']}, '')
      AND ur.sex = COALESCE(${user['sex']}, '')
      AND ur.edu = COALESCE(${user['edu']}, '')
      AND ur.weight = COALESCE(${user['weight']}, '')
      AND ur.constellation = COALESCE(${user['constellation']}, '')
      AND ur.advantage = COALESCE(${user['advantage']}, '')
      AND ur.hobby = COALESCE(${user['hobby']}, '')
      AND ur.feel = COALESCE(${user['feel']}, '')
      AND ur.money = COALESCE(${user['money']}, '')
      AND ur.workType = COALESCE(${user['workType']}, '')
      AND ur.social = COALESCE(${user['social']}, '')
      AND ur.age = COALESCE(${user['age']}, '')
      AND ur.height = COALESCE(${user['height']}, '')
      AND ur.child = COALESCE(${user['child']}, '')
      AND ur.house = COALESCE(${user['house']}, '')
      AND ur.car = COALESCE(${user['car']}, '')
      AND ur.pets = COALESCE(${user['pets']}, '')
      AND ur.travel = COALESCE(${user['travel']}, '')
      AND ur.sdLike = COALESCE(${user['sdLike']}, '')
      AND ur.onLine = COALESCE(${user['onLine']}, '')
      AND ur.work like ('%!'(MISSING) || COALESCE(${user['work']}, '') || '%!'(MISSING))
      AND userPlace.birthPlace like ('%!'(MISSING) || COALESCE(${user['birthPlace']}, '') || '%!'(MISSING))
      AND userPlace.workPlace like ('%!'(MISSING) || COALESCE(${user['workPlace']}, '') || '%!'(MISSING))
    ORDER BY un.fk ASC
    LIMIT ${Number(user['pageSize'])} offset ${(Number(user['pageNumber']) - 1) * Number(user['pageSize'])}

所有的字段记录都在。是什么原因错了呢。
请先知给看看这是什么问题。 mysql。跑这条sql是没有问题的

Answer 1

SQL_CALC_FOUND_ROWS 是 mysql 的特有关键字，postgresql 不支持

请参考：
PostgreSQL - SQL 命令 - SELECT 语法