阅读背景:

Count Aggregate Dot Count语法(.count)

来源:互联网 

So I ran into what I thought was a bizarre error this morning when I accidentally referred to a non-existant "count" column in my CTE. Postgres was looking for a GROUP BY clause even though I didn't think I was doing an aggregate. A little more playing around and it appears the table.count is equivalent to a count star function. Consider the following:So I ran into what I thought was a bizarre erro




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: