| From: | Geoff Winkless <pgsqladmin(at)geoff(dot)dj> |
|---|---|
| To: | Anthony Apollis <anthony(dot)apollis(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: TSQL To Postgres - Unpivot/Union All |
| Date: | 2023-07-20 13:58:06 |
| Message-ID: | CAEzk6ffszUabGjDhBOCZqTP0PoMzLaJtnu+=ye2snMVSOy=b4w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | gzh | 2023-07-20 14:14:52 | Re: How to improve the performance of my SQL query？ |
| Previous Message | David G. Johnston | 2023-07-20 12:48:22 | Re: TSQL To Postgres - Unpivot/Union All |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anthony Apollis | 2023-07-20 14:28:33 | Fwd: TSQL To Postgres - Unpivot/Union All |
| Previous Message | David G. Johnston | 2023-07-20 12:48:22 | Re: TSQL To Postgres - Unpivot/Union All |