Please add alias on where clause

[oscarzamora]

If you could please add the alias for the last containment query "ge", "gu".

Thanks

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: b9b65f64-c521-3799-b833-9ac27213e927
• Version Independent ID: 0d6e2a8b-043b-7cdd-4e19-82c03c803c16
• Content: Azure Database for PostgreSQL – Hyperscale (Citus) (preview) quickstart
• Content Source: articles/postgresql/quickstart-create-hyperscale-portal.md
• Service: postgresql
• Sub-service: hyperscale-citus
• GitHub Login: @jonels-msft
• Microsoft Alias: jonels

[AshokPeddakotla-MSFT]

@oscarzamora Thanks for the feedback! I have assigned the issue to the content author to evaluate and update as appropriate.

[jonels-msft]

@oscarzamora can you please provide a little more info about the query you are referring to, and how you would like it to change?

[jjfrost]

I believe the request from @oscarzamora is to change this query below, into something like the second query below, such that the 'where' clause and other clauses are also using the aliases of 'gu' and 'ge' for technical clarity:

--- Current Query in Doc ---

SELECT login, count() FROM github_events ge JOIN github_users gu ON ge.user_id = gu.user_id WHERE event_type = 'CreateEvent' AND payload @> '{"ref_type": "repository"}' GROUP BY login ORDER BY count() DESC;

--- Updated Query ---

SELECT gu.login, count() FROM github_events ge JOIN github_users gu ON ge.user_id = gu.user_id WHERE ge.event_type = 'CreateEvent' AND ge.payload @> '{"ref_type": "repository"}' GROUP BY gu.login ORDER BY count() DESC;