Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Count column with name 'count' returns multiple rows. Why? - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] Count column with name 'count' returns multiple rows. Why?
Date
Msg-id CAKFQuwaxFge-SHpYAZb-jTrG2VTYWQgCcjd0YEAbvO5RpzX75A@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Count column with name 'count' returns multiple rows.Why?  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List pgsql-general
Tree view
On Fri, Aug 18, 2017 at 1:47 PM, Peter J. Holzer <hjp-pgsql@hjp.at> wrote:
So apparently
​ ​
columnname open-parenthesis tablename closed-parenthesis is a specific
syntactic construct, but I can't find it documented anywhere.

​The documentation linked to speaks mainly in terms of "composite types".  A table IS a composite type (i.e., there is an implicit one of the same name) for these purposes.​

David J.

pgsql-general by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: [GENERAL] Count column with name 'count' returns multiple rows.Why?
Next
From: "Peter J. Holzer"
Date:
Subject: Re: [GENERAL] Count column with name 'count' returns multiple rows.Why?