Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qMVFo-002YHT-K8 for pgsql-general@arkaria.postgresql.org; Thu, 20 Jul 2023 15:07:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qMVFm-00A3kE-Nx for pgsql-general@arkaria.postgresql.org; Thu, 20 Jul 2023 15:07:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qMVFm-00A3k0-CR for pgsql-general@lists.postgresql.org; Thu, 20 Jul 2023 15:07:42 +0000 Received: from mout.gmx.net ([212.227.15.15]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qMVFf-000WPw-9a for pgsql-general@lists.postgresql.org; Thu, 20 Jul 2023 15:07:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1689865652; x=1690470452; i=shammat@gmx.net; bh=mKFGEUovRUw8uOTmO3HrByHqtCQ4bEiwJbq7YJRvf1A=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=FlpOJ7cE1nJwmfn6AqFt+4rc3jSKKR6/heAPYE7Gj06H7GTNWBrWTSxJNolsRqwCBlf50C1 AXaN4NZotIjlLAyrUj96rXm9AedlUxBF9CAho7PkWfjD83z1VqeB74MtmsWYhXl5Vgm8Vp21F G+BWR7VSYuvZnQHEu2fkcr1/DoxTwI1zwAsGq5icTsknslHpOu8prXrX9IgYV1CHZR1u0w7Kr /L80juNpuBvYQutjfpIVYLOtu+7FXg7SKsB2DEIsIUj657de42VESOqhouGKvWMiuqm3dOFom +InILJWCGCJDS7DHK9e+l4YqvokqsIHL9o0GKgy4h6Lj6DtiDunQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [192.168.178.20] ([88.217.180.155]) by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MWzk3-1qOOw13Obx-00XLhs for ; Thu, 20 Jul 2023 17:07:32 +0200 Subject: Re: Fwd: TSQL To Postgres - Unpivot/Union All To: pgsql-general@lists.postgresql.org References: From: Thomas Kellerer Message-ID: Date: Thu, 20 Jul 2023 17:07:31 +0200 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: de-DE Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:wt6zSxDMXKqSOT0gNUw9i0TMqu8RBnaXQ1oJ8oaESLtF4Ou5HjT h/121th9MdSd5U7ugj1ByTXMws4uqR3Fx+R5JigPL0YYK5NZfDy0D6PJ4pp19rIW6PoZaWj wvnZdDrK7vI1PQh9dzuUJjiBW1R99oHd+l9ovYQLZNErhZ6MB7jfl8qKoQqNBt98WIkpLLo qoPQwmYYOiNAtV0euKFOg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:L0tTrOw6oD8=;bpIWqA3i3Mu+/oBsCJ8itjmnOkf atXsbcQUg6axdqccrDqibn3OuRztmWdA0w9wZwIfCka+bdDjtquLTH/IJp60K0+n40rsZD88i jNxPvR8x3Jm9vTKCZA+MpNGHROIIUKzjD0yQvdrk1lQM4ZZtcps1RhmrV8TdQ61HTWOOHQCFx G3fRV2Lf+si+OFiJfXwaZ5cli5od4B3C7yasB62MnQrbpuUNSgfM44PCGyqQO1CGJBrOPf9Ah LFKQnqN0X/mpMikaS9xcJkmTDEaqUsU6I2jORCDG3Gx5/V2gOKK1uE1QHVCQqumynGGzNZ9KJ +6FVAIHlc/6AakVQFpCwokSO8OgUgiyE0W76eLnLZN1zxu1T5Q8xEuWqsQo11ec9ctabi7f29 HO3frUF5csPVQPggqBepFgTABZkpUGYwoRourJqT4+U5dSyoDmSpmAEFsrYgLyEwsTmldaTsS fLYUj+BXtqNWx/EXFnq6+3+S0F4v4+uUb6WktMay/ZXSUvMPafxKH762x9Y0OUZ5Xj8hZJrjB frbt4aoRah793bcyVfCuqRej37xB/48131qd+FImX40TQfVjpDehwHoKh2A2Tu+BcHhU9w4LL dPWbwJV1InWoP0gKKreIx6CfLC0EEKXMAmN13ZMzbmT4ROOA6528qyU4lYV6Hx4J7/D97Sl9y cwZtWwrfa8mSIo38X8pZmK3jnFQdYMlRus2F+9oAXe7+GmpDrlXHGJ7O8BhXi8hVgDyi6Glhp /omenfq1avvIrTpvj9jZVDJ0uzIVp0m+VjR/c0izPx/EOEi+O28DgGKCW91/xz9hknZbIeXKw I6UrZiodT2w1rCY36E3hST2Kx80Aevm76MfR9qh2wH9sGH+tValJZNTRy7NNdZjs6kioRk7lh 3CbtUOBkdSlJ5t2iA/WTyY+kArB5+/EjTna2wPe43MfeoSGkqQEjCfvzLOM8CiTfdIv0MBXhY 8Z9EDA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Anthony Apollis schrieb am 20.07.2023 um 14:17: > Does not give me outputs for columns: Metric and Pricing Channel: > image.png > > What am i doing wrong? Please assist? UNPIVOT can be done using a LATERAL sub-query with a VALUES clause: https://blog.sql-workbench.eu/post/unpivot-with-postgres/