Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cpxlx-0006zf-2A for pgsql-sql@arkaria.postgresql.org; Mon, 20 Mar 2017 13:54:57 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cpxlv-00015d-Ov for pgsql-sql@arkaria.postgresql.org; Mon, 20 Mar 2017 13:54:55 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cpxlt-000137-Ca for pgsql-sql@postgresql.org; Mon, 20 Mar 2017 13:54:54 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cpxlm-0003Qu-Tg for pgsql-sql@postgresql.org; Mon, 20 Mar 2017 13:54:52 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id E944420976; Mon, 20 Mar 2017 09:54:45 -0400 (EDT) Received: from frontend2 ([10.202.2.161]) by compute6.internal (MEProxy); Mon, 20 Mar 2017 09:54:45 -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=e/VCpk3oatcynnPTJE 9B26ASO33+k/naEUh9H/MwklA=; b=KqC7bWu6b33++/6bclggOPKxRbRNCd0GmL i2iQEzKTfVK/ZW0WMNh8eeOSFcBMmL9XU5HFlkmxmC1OLvbLJ8SGKbPLSmJIr3Md grXr5c86HUtazYuJUXeFORc+LwonCLI/zH9KBxQ4CPWu1ejq4IyH1nRW7jnqicyH yNT4PCIlcQKOa0PQnKSk1v18K/Of4fsygwxuUN7gVxRZFRQxcybWLZbxbTOPi8Kg Vc2SzbQ4Bwaigh7Ftj07d9z6z9LxlEalK+foB25sL5OhW2OItbeNC6W1LyOW0xjC N0wRY8o6xlNUZbzB9McVok6Occi+Dlf/B2FIEdqZnkzXaV4ZJzqg== 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=e/VCpk3oatcynnPTJE9B26ASO33+k/naEUh9H/MwklA=; b=DO1iTgg2 xTlCVnfeYBFlsxycP0peOYejrqe+lvM2O4pNraQwV1PitZqU5yX2MlY8iNOtNFDD ULi3Fk0ReOpcxxdVdl1jIOrqbk3odGxOu6gDazdX74YVoshzl7WLuBDuyh04vf4w rfQuKVnRYyJjDYYLiyj5no921+MX8SVKFCROfzvalXdIMHCbujRADkNmjUQFEK+f UmNkCrT3v5JR/3u2RbOd1lFSaaEnW6HP7UiN5Tkpzzt9XJ0lbXJPPoDfcQTDFOXx hnsWrirg9gNt1Me8V12/Ii3EUdML1ozaHIOJveq0Uw2/6U4/EEI8NlC276KjTZTW Lj49AtOA/ValWg== X-ME-Sender: X-Sasl-enc: uVImn351XjgQFbiaGwAlgIWkeysAaoaZ5fDhKJ3OQ1fO 1490018085 Received: from [192.168.1.2] (174-21-203-58.tukw.qwest.net [174.21.203.58]) by mail.messagingengine.com (Postfix) with ESMTPA id 6D823241D1; Mon, 20 Mar 2017 09:54:45 -0400 (EDT) Subject: Re: Equivalent data type for SQL_Variant not found To: "Ghosh, Snehashish" , "pgsql-sql@postgresql.org" References: <5258E1C8FACF394EA6FD98129A647D9A3337F173@IN-BLR-DAGND1.corp.capgemini.com> From: Adrian Klaver Message-ID: Date: Mon, 20 Mar 2017 06:54:44 -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: <5258E1C8FACF394EA6FD98129A647D9A3337F173@IN-BLR-DAGND1.corp.capgemini.com> Content-Type: text/plain; charset=windows-1252; 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 03/20/2017 06:12 AM, Ghosh, Snehashish wrote: > Hi, > > > > Do we have a Equivalent data type for SQL_Variant which is available > insqlserver in postgresql? No. I would say the closest you could get is to declare a text column and store the string representations of the values. > > > > Please help. > > > > > > > > With Regards, > > > > Snehashish Ghosh / Capgemini India / Kolkata > Smart Energy Services Platform (SESP) > -- 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