[Position_desc] Like "*loader*",[trndLoaderPerformanceTbl_Crosstab].[11/09],[trndPerformanceQry_crosstab[Position_desc] Like "*loader*",[trndLoaderPerformanceTbl_Crosstab].[11/16],[trndPerformanceQry_crosstab[Position_desc] Like "
但是当我尝试从Database2中使用它时,我得到了这个错误-- crosstab函数不存在。当我运行时,Create extension crosstab,我得到了这个错误- could not open extension control file "/usr/pgsql-10/share/extension/crosstab.control": No such file or directory当我做\dx crosstab时,我会在两个数
TRANSFORM SUM(weekpace_crosstab.wgt) AS SumOfwgt Products.[Product Type], SUM(weekpace_crosstab.wgt) AS DeliveryTotal (weekpace_crosstabLEFT JOIN
Customer ON weekpace_crosstab.Customer = Customer.Customer) LEFT J
正确的查询是: 'SELECT extract(week from starts) AS week, 'SELECT extract(week from starts) AS week,
extract(dow from starts) AS-> Function Scan on public.crosstab (cost=0.00..10