| From: | Anthony Apollis <anthony(dot)apollis(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Fwd: TSQL To Postgres - Unpivot/Union All |
| Date: | 2023-07-20 14:28:33 |
| Message-ID: | CAJyMCYJDiY6hoLdtM=T2nc8rnZTxBbNOr0mHsJ5v6OPtes6B0Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
---------- Forwarded message ---------
From: Anthony Apollis <anthony(dot)apollis(at)gmail(dot)com>
Date: Thu, 20 Jul 2023 at 16:07
Subject: Re: TSQL To Postgres - Unpivot/Union All
To: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com>
I am attaching my TSQL and Postgres SQL:
On Thu, 20 Jul 2023 at 15:58, Geoff Winkless <pgsqladmin(at)geoff(dot)dj> wrote:
> On Thu, 20 Jul 2023 at 13:17, Anthony Apollis <anthony(dot)apollis(at)gmail(dot)com>
> wrote:
>
>> The Postgres i used: INSERT INTO temp_FieldFlowsFact
>> SELECT "Account", "Calendar day", "Financial year", "Period",
>>
>> [snip]
>
> At the very least, include a column list in your INSERT statement. We have
> no way of checking where any of your results are going.
>
> Geoff
>
| Attachment | Content-Type | Size |
|---|---|---|
| posgresto.txt | text/plain | 14.6 KB |
| Channel FTR.sql | application/sql | 14.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2023-07-20 14:41:44 | Re: Nu-B here |
| Previous Message | gzh | 2023-07-20 14:14:52 | Re: How to improve the performance of my SQL query？ |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Geoff Winkless | 2023-07-20 14:51:35 | Re: TSQL To Postgres - Unpivot/Union All |
| Previous Message | Geoff Winkless | 2023-07-20 13:58:06 | Re: TSQL To Postgres - Unpivot/Union All |