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 1uWxQv-003tID-Nv for pgsql-general@arkaria.postgresql.org; Wed, 02 Jul 2025 13:23:29 +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 1uWxQt-000eA0-2P for pgsql-general@arkaria.postgresql.org; Wed, 02 Jul 2025 13:23:27 +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 1uWxQs-000e9s-NU for pgsql-general@lists.postgresql.org; Wed, 02 Jul 2025 13:23:27 +0000 Received: from mail-oo1-xc32.google.com ([2607:f8b0:4864:20::c32]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uWxQr-005J4q-0n for pgsql-general@postgresql.org; Wed, 02 Jul 2025 13:23:27 +0000 Received: by mail-oo1-xc32.google.com with SMTP id 006d021491bc7-610d86b3da9so1678988eaf.0 for ; Wed, 02 Jul 2025 06:23:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1751462603; x=1752067403; darn=postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=0wm3Db1sZkJ8ZDea/Gfusfa/042slA2NF2oPEK8tz6Q=; b=nSW/PyYlwmpqBSF1fCg7iXX62/tYNhpS/23+4e4lSsYmMH3nWpCnIWsn7wlwjlonfE S81JubrtNkrVqeMBUeSF+kGBOnE+F+9O4xIAI92W8CqIZpVBUDe3LaRGLN8Ro+KmuAVR UFjd/cHVHn+o0jMFndnI9k5Gy1y/4MW/PGJKzX/zSQuLVA2LKk9GGXXTPFQAYXsiqxVl CT+t2IVaLKQcYipUQ1K62gO6nVsHf3txTyfY60wyKoO9PZINEJR5fkW7Casu6zFilexo dA9YMoYTNemNKaANZ5blcPFIna9AUTyCCeQUk5YS6lWA+sXzFnw+UNUnj4bqsp9E6Kz4 voOQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1751462603; x=1752067403; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=0wm3Db1sZkJ8ZDea/Gfusfa/042slA2NF2oPEK8tz6Q=; b=INYE56V7VkWl+xlMyupq4K/9NsKs0KKNw2g1stfh2zp7SjAbVOcAfv62xaspX1+2Ur KqBgIKwWsbputViyRNxPzPE0Adtz8u4GrHJfLLjWCiZYsDYLkmUqn01Hh6MlLZifZ0t4 Nr+Mnh49gK0MJqjOB+xEkNZFoUH5wipDP6sewi/4tNVz1CwPEI4Fvr+0sU+v8Z/qG6L6 2OP3P3DZ52NDqECDGlYbWyKi9dzt7gcUmMO4r1KT9xfPX+XXJTHQYOXwn8zJ/vwXRgIi of8g1QB829pW2CzlFfe40cuxP6oKmuROXR0gpWB3ZXAml+hcuCXqQc5z9l+LeeuxAiUI 71qg== X-Gm-Message-State: AOJu0YxENaMknlutnk9z9c2LKSW+HAC6LIibEokRG0KulkbV/ahC6reL KnmFuwYdwkelJvOJsO8bD7oeNu7J1CYvq7Bm2XtZIggsvT/eSN8fFpzlY5rE+7eTCUsgwDRyGnR +O4bulTCF/SmzR19yPpXHAbbaWShBy7c= X-Gm-Gg: ASbGncsWoVUz1I49kh5lLLxCFVXKI9VC0DDe1/BW9e9WTCWPbJZ2glrTyICMZrfp4Nl y54WHljBdXCuLqhJx1Zxv7I1uPb79dhd5wH3rGLhSgHMLHDbPi3O95R5BeP6uxVt1bmRD9aAJiz vun+NtObzqzBysjabTgIk8ZPaCakL4J7ID8H6sX2te5rE= X-Google-Smtp-Source: AGHT+IHFVC9eEBYxhggKjMxOdH365Y8WLuXqhhM+KZAO6J/qSSYXywRZrOZr+ivcXznstKQwSHlxZQIOTFPaIOH/oy0= X-Received: by 2002:a05:6820:c93:b0:611:7626:b5df with SMTP id 006d021491bc7-612012453e5mr2011678eaf.4.1751462602831; Wed, 02 Jul 2025 06:23:22 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:6802:5083:b0:5d3:be6e:4554 with HTTP; Wed, 2 Jul 2025 06:23:22 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Wed, 2 Jul 2025 06:23:22 -0700 X-Gm-Features: Ac12FXyCUWHTfytuyOtU8XExunqMmJZPvtPWZvwX2dYuGXi07QHcjfgvjzGWlyA Message-ID: Subject: Re: PLPGSQL - store fetched records in array of record To: Durumdara Cc: Postgres General Content-Type: multipart/alternative; boundary="000000000000477b7d0638f22a11" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000477b7d0638f22a11 Content-Type: text/plain; charset="UTF-8" On Wednesday, July 2, 2025, Durumdara wrote: > > > Is there any way to avoid this? To use a "simple untyped record" in an > array without "dependencies"? > Use jsonb David J. --000000000000477b7d0638f22a11 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, July 2, 2025, Durumdara <durumdara@gmail.com> wrote:

Is there any way to avoid this? To use a &qu= ot;simple untyped record" in an array without "dependencies"= ?

Use jsonb

David J.
=C2=A0
--000000000000477b7d0638f22a11--