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 1tNtLG-002o7m-3y for pgsql-general@arkaria.postgresql.org; Wed, 18 Dec 2024 12:39:54 +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 1tNtLE-00ETqO-2d for pgsql-general@arkaria.postgresql.org; Wed, 18 Dec 2024 12:39:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tNtLD-00ETqF-J1 for pgsql-general@lists.postgresql.org; Wed, 18 Dec 2024 12:39:51 +0000 Received: from mail-ed1-x535.google.com ([2a00:1450:4864:20::535]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tNtLA-000PCZ-3R for pgsql-general@postgresql.org; Wed, 18 Dec 2024 12:39:50 +0000 Received: by mail-ed1-x535.google.com with SMTP id 4fb4d7f45d1cf-5d3ea065b79so2132872a12.3 for ; Wed, 18 Dec 2024 04:39:48 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=peoplecall-com.20230601.gappssmtp.com; s=20230601; t=1734525586; x=1735130386; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Bzesq9GNY38a1QJJxLBKkzXksfONzLFdHB2HgM7HDEI=; b=spTtl0fe8I9bhxdxl+Bjq9+pLEzsd+l2xv9KPDBDiekOoKWj/G2AKHPeObEQdqp+9v OyZG/hiKgpjbVIvWTKx55/aVzqJ+2Z0SYzT41pS0W2I5giZ/WeGzLWrJ1+yhgY5Acmhz acM/LgTSGlRnYQihl39JJwUx/FDlfNvMxfIV7dv7uStbBetOobS2vREsF6OrevLRuh7h A2sS/qurEyF7iGdsQ+pw65AMRyU37NgOa26Bajnvg+B+2NMTJVlrl8ciHBGfKsJoYM5P +QgYoGqFOyWOwkl9v00ZAcOQO6sP8lUCc0qDSmA8d9Y8BG9/JfAXhtS1a4QO4gI3Cchq 7vZA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734525586; x=1735130386; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Bzesq9GNY38a1QJJxLBKkzXksfONzLFdHB2HgM7HDEI=; b=ZampImi04vF9xzqqtprC8CsYRV4sgLv6k43kSCgL9uX0T5tCK81q8XLIiEMlsUfvsq j2gcyK7XmvOrnn3/LMIweLQpDpKuOCOygKKFFbKyT/QYgut38nL0Foy+br6mZuF/jinQ 6tDL4M67YK2DUMd2ewlxuSds4Yyen7mII8iBXvRi/hPA0Ann8l+1sHZXWb4vSCe4HeqW 4tXbSwmbkLjDadDCj8sOAx+NYG+ktF+zwbYwcgNzBhnTmmLrWcQT4qJcgcXaS5ccdV4J DMVe2VPQ1H/X+j2qaiwC9QwOOskBtucx4LEDHfa63AB3oSgkaI5ZJo8/M16CRDW4YVOa WvDg== X-Gm-Message-State: AOJu0YxDkxhPg2/eIT0qP0fC32QiKKmCTawesfntPw8ai4BX/VLuKVDV 7eCYoydu3LtXLxdG+Ndsk/zBFm7qLgX667CYBPAkiJsdCzCMhS8trXIQSuSpp/NprHYhu96zaN5 5cV+EQTjmvRNN28xNgR/340YHsiLVnzQ8BxyB X-Gm-Gg: ASbGncvbIAd0AuwtVWNIDmGaedGl5tNHhmZ1SkQy6YoEvtCHeMCP422UZ3U3GoMW5DP 2qCwqosyC6UlcD9W9cOrqmmuTzvlyBnqJoirBbQ== X-Google-Smtp-Source: AGHT+IFkuH1AYzCGSt5giHPActQ87sVAUamsKcC2MLW4Lwu/V7Hz/sYAPMD58dSi27CPQ6PC4VR5fNz33f8THvWoz9Y= X-Received: by 2002:a05:6402:13cc:b0:5cf:bb9e:cca7 with SMTP id 4fb4d7f45d1cf-5d7ee42426cmr2697796a12.28.1734525586279; Wed, 18 Dec 2024 04:39:46 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Francisco Olarte Date: Wed, 18 Dec 2024 13:39:10 +0100 Message-ID: Subject: Re: How to do an update with XML column ? To: celati Laurent Cc: pgsql-general@postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi: On Wed, 18 Dec 2024 at 11:00, celati Laurent wrote: > ERROR: could not identify an equality operator for type xml > LINE 39: group by orga_name > ^ Have you tried the obvious group by cast(orga_name as text) ? Never used XML but most types in postgres convert to text injectively ( but not bijectively ) ( I mean, same values, same text, but you can have different text same values ( like the obvious text->float conversion )) Francisco Olarte.