Re: How to write a crosstab which returns empty row results

From: Brad White <b55white(at)gmail(dot)com>
To: David Goldsmith <d(dot)l(dot)goldsmith(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to write a crosstab which returns empty row results
Date: 2022-12-25 03:24:59
Message-ID: b53b3b28-21c5-fd2b-bc9a-d4156c46ccb6@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/24/2022 9:03 PM, David Goldsmith wrote:
> How do I force "empty rows" to be included in my query output? (I've
> tried LEFT JOINing to the row header results, and using CASE
> statements; but due to my unfamiliarity w/ using crosstab, I'm not
> sure if I've used those correctly in the current context;
>
Can you give us a head start by showing the query you have now that is
not working.

Extra points if you give simple create/populate statements that
demonstrate the problem.

Hope that helps,
Brad.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Goldsmith 2022-12-25 07:25:09 Re: How to write a crosstab which returns empty row results
Previous Message David Goldsmith 2022-12-25 03:03:13 How to write a crosstab which returns empty row results