Re: Help for MSSQL "Compute" equivalent in Postgres - Mailing list pgsql-novice

"Manfred Koroschetz" <mkoroschetz@tekvoice.com> writes:
> I am having trouble translating the following simple MSSQL query into
> the equivalent Postgres form.

> select A.ProdID, A.Description, A. Qty, A.Price
> from SoldItems as A
> where   A.ListID = 15
> order by A.ProdID
> compute count(A.ProdID),sum(A.Price),sum(A.Qty)

This "compute" construct does not exist in the SQL standard, so you'll
have to forgive us for not immediately knowing what it does ...  if
you'd care to specify exactly what behavior you're trying to achieve,
maybe we could help.

            regards, tom lane