Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cv3AK-0000V9-C3 for pgsql-sql@arkaria.postgresql.org; Mon, 03 Apr 2017 14:41:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cv3AJ-0000RK-LI for pgsql-sql@arkaria.postgresql.org; Mon, 03 Apr 2017 14:41:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cv39H-00070C-Pg for pgsql-sql@postgresql.org; Mon, 03 Apr 2017 14:40:04 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cv39C-0001Tc-RI for pgsql-sql@postgresql.org; Mon, 03 Apr 2017 14:40:03 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 9431520A15; Mon, 3 Apr 2017 10:39:56 -0400 (EDT) Received: from frontend2 ([10.202.2.161]) by compute6.internal (MEProxy); Mon, 03 Apr 2017 10:39:56 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= content-transfer-encoding:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc:x-sasl-enc; s=fm1; bh=AqZzk1WGt2nSVRDp48 89T1UkpKG03g2I+icM7+U+svU=; b=CQE16/8YqSgy7N0Y7NvPXXwcwZWwp5rJea UrV3ZIOLLp1H9m0TMyJbJLXBFoDRgJEWwgifiUwjzExa7p/GmrY/PD6I+u8vQHNl +KCpS3vXYKWc1pJb4h0Yj1OoJ8TbhBZQZe5Gkaf0fy+C4V8WBa8+VCNXCUz37C8J 87A2V5UYJ4G4DyoHYQ+moMK92tZ20Sjo0EKQbtnaNorGW6exB/a21wduU2rGhUg+ zS3Gbp/TKraNGARJ7PMaoldDwJVQRyxMc5gUtT9Pq3JXa6npNeRuowfwI+MHiDbI yWv9hw700YUv9+DL/89E75DKP2BqS35RA/W00DjvJ7OnTIwYKqsg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-sender:x-me-sender:x-sasl-enc:x-sasl-enc; s= fm1; bh=AqZzk1WGt2nSVRDp4889T1UkpKG03g2I+icM7+U+svU=; b=Ptf6A+LT 7CbZIFAaAwLU4UPwwLXqIeKPRG0Ob4tHdpFKFL05nSjkrx436pKJkSQZCS8wM3KC mlV0ET5EK1eYftXknQrJsfJnBu8fZ4990gDhhFXtv2GCZcUfGgRFLm2/RvVBrZLs Qf8uQIgjYvqj0VnCpNsFLYjm35D3R09q6RINC0BaXEMnRzzb+E9NvVFxqNL6MzuZ HMaWzRXT8YCAHYg9O7kSvN63J6ttFVHD3rxQLbjxMxz3TsFccy74OrmbOD3Sjbe3 +KTeS7abZg5f5CVV/C74Kh4WtYwCKIgFv4577qpCCsQ7JTZb3SA0R8QBqDz//TT5 AoyKtmXThvUzOw== X-ME-Sender: X-Sasl-enc: TxnFTrev4DbphhIMwpVifEZIaocTdQWWrWIQG8L1z6EE 1491230396 Received: from [192.168.1.2] (97-113-63-158.tukw.qwest.net [97.113.63.158]) by mail.messagingengine.com (Postfix) with ESMTPA id 227F52469B; Mon, 3 Apr 2017 10:39:56 -0400 (EDT) Subject: Re: Crosstab function To: Gowtham Vel , pgsql-sql@postgresql.org References: From: Adrian Klaver Message-ID: Date: Mon, 3 Apr 2017 07:39:55 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.8.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org On 04/02/2017 09:05 AM, Gowtham Vel wrote: > Hi postgresql support, > > Could you please help on crosstab function for dynamic column. The docs and an example: https://www.postgresql.org/docs/9.6/static/tablefunc.html http://stackoverflow.com/questions/3002499/postgresql-crosstab-query If you need something more specific, then we will need to see an example of what you are trying to achieve. > > Regards, > Gowtham K > > -- Adrian Klaver adrian.klaver@aklaver.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql