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 1u8qUV-00CWLo-Gm for pgsql-general@arkaria.postgresql.org; Sun, 27 Apr 2025 01:07:31 +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 1u8qTT-008CLf-LV for pgsql-general@arkaria.postgresql.org; Sun, 27 Apr 2025 01:06:28 +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 1u8qTT-008CLX-AY for pgsql-general@lists.postgresql.org; Sun, 27 Apr 2025 01:06:28 +0000 Received: from mail-oa1-x34.google.com ([2001:4860:4864:20::34]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u8qTQ-002Fu7-2X for pgsql-general@lists.postgresql.org; Sun, 27 Apr 2025 01:06:27 +0000 Received: by mail-oa1-x34.google.com with SMTP id 586e51a60fabf-2c2bb447e5eso1938496fac.0 for ; Sat, 26 Apr 2025 18:06:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745715983; x=1746320783; darn=lists.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=UfPBjpedDoRc4+ecJvsBOrCNd/ZuPfq4ky/nvIg/n5I=; b=gyKWgdyh5wV2le8WJwE4wCR+DjaBeiSo4xQxO0jjU7balYroEREA0Hugy5Yr8flzrm VIcRT2E/YQwWam81J0Rhcx+raAz7f1AET6QdE0D62yqRDZAYYeiAveJwsq+sjjvr7Pcs MbOYK8oKrQ+ZVFZrwS5KRt6VfoVCQY/ryimc/P4CpQ7a1hxENX9ISWOK9DInONvJy/k+ NMVsDAnkbPRcIwxOx+gzDTPQlI3cqISmf5oRnhK39zxF0vQo5CpCNt98LY5vmEZszInG bJaVT/9oCaw+VtpYIG/A/1oRGsD+UJ/6xZoAhfSwEULlX5FiQH5MLMAMZaBJbClaE3YP RaqA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745715983; x=1746320783; 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=UfPBjpedDoRc4+ecJvsBOrCNd/ZuPfq4ky/nvIg/n5I=; b=UNpK1Hf016lT9o2K86ey0jAV2X4j9Xi9alr3YlCbGjHzEdxT8FBZh/Uz0b3t3gOQRE 5MmjxE7NFnmO1bQ5WM/IhJPQ3avAxP1yjDXnfDT68oiAgopVHe7i024ExbZUerhGs4zW MdjRTm+kRpNaIsrPfh0PnnYuvp5Ag0OAZc/raUQ4zBwY7OvQ/w+XV2c5/nOYH0NuPyCp +AvfYXyckfj/u8SCDfok8i5tNesAbYivDxfZ76Ze0EVa1xNDYE8CBAux52Rev/E1kILr zV6ejZknpi/mL8D9VTVPLHi2vhuF0XUp5yxGfYtLLTb1+IF3SQmtjxuuyanThK7r7HS4 VBxw== X-Gm-Message-State: AOJu0Yxm/6VevYjA0KqceO1FOKBwOXKvS2OnWxuRUfVjiEODhEztKqbV vwBfWFKTsMVk8HGl8Yts07SLSZUS5Oebjm7Olk54And3RrGrhwA89ipxdqSgdziO7dWq0rrqk4R /CXuPNKBgUSraV6PQW3F2ukyNtmU= X-Gm-Gg: ASbGncvdajtujEulXugBEg+iozwN9L2TcsEKfMkpbjyNhAjSgD6M+w5xWGyS4UXpL2b 4zi/+qlDE5boptYNqVMPS7dwCaODE3oFCJuNPVeOyUK1g0MsRghF4kkFsp2WwWCZwCQxYMzoIeB Xk2v7qKu104en2xyOGzoJU X-Google-Smtp-Source: AGHT+IGJ49S0ppuuo5sZ784BqGTISsrP/s3Q8VYEMZc2Vk8W8mgYMpfmHKVoFpCa23Ih+966OcnFvK+pGo9528UkUak= X-Received: by 2002:a05:6870:9728:b0:2c1:ae41:6b5e with SMTP id 586e51a60fabf-2d99d8056a4mr4335934fac.16.1745715982710; Sat, 26 Apr 2025 18:06:22 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:6802:1e0e:b0:589:13f9:e937 with HTTP; Sat, 26 Apr 2025 18:06:22 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Sat, 26 Apr 2025 18:06:22 -0700 X-Gm-Features: ATxdqUEzekGVxn061O9VrBEkpMC3q7v8AZmbUtX6qNZwcuuJGaFVvYhdQi1QD4s Message-ID: Subject: How to get the data from the query To: Igor Korot Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000073ab20633b82d73" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000073ab20633b82d73 Content-Type: text/plain; charset="UTF-8" On Saturday, April 26, 2025, Igor Korot wrote: > but the size comes out "" (empty) > > What is the value you are expecting? What is the minimal table definition (i.e., a one or few column table) that would produce this expected value? What does psql show if you use it to output the query against that table? David J. --000000000000073ab20633b82d73 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Saturday, April 26, 2025, Igor Korot <ikorot01@gmail.com> wrote:
but the size comes out "" (empty)


What is the value you are expecting?=C2=A0= What is the minimal table definition (i.e., a one or few column table) tha= t would produce this expected value?=C2=A0 What does psql show if you use i= t to output the query against that table?

David J.=

--000000000000073ab20633b82d73--