docker php 安装 pqsql

FROM php:7.2.2-fpm # 国内源 RUN apt-get clean RUN apt-get update RUN apt-get install -y libpq-dev RUN docker-php-ext-configure pgsql -with-pgsql=/usr/local/pgsql RUN docker-php-ext-install pdo RUN...

继续阅读 »

pgsql

json展开值SELECT "value" FROM "inner_id_mapping", json_each_text(inner_id_mapping.ids::json) limit 100窗口函数增加idx的序号字段,使用over进行分窗,后续可通过idx获取组内的行数SELECT *, row_number() over(partition...

继续阅读 »