Re: Count column with name 'count' returns multiple rows. Why?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Count column with name 'count' returns multiple rows. Why?
Date: 2017-08-18 21:34:27
Message-ID: CAKFQuwaxFge-SHpYAZb-jTrG2VTYWQgCcjd0YEAbvO5RpzX75A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 18, 2017 at 1:47 PM, Peter J. Holzer <hjp-pgsql(at)hjp(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2017-08-19 08:04:04 Re: Count column with name 'count' returns multiple rows. Why?
Previous Message Justin Pryzby 2017-08-18 20:57:39 Re: Count column with name 'count' returns multiple rows. Why?