Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1merL6-0002DU-S8 for pgadmin-hackers@arkaria.postgresql.org; Mon, 25 Oct 2021 04:12:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1merL5-0002Ko-Hx for pgadmin-hackers@arkaria.postgresql.org; Mon, 25 Oct 2021 04:11:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1merL5-0002Kf-Bz for pgadmin-hackers@lists.postgresql.org; Mon, 25 Oct 2021 04:11:59 +0000 Received: from mail-vk1-xa32.google.com ([2607:f8b0:4864:20::a32]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1merKx-0004uq-NQ for pgadmin-hackers@lists.postgresql.org; Mon, 25 Oct 2021 04:11:58 +0000 Received: by mail-vk1-xa32.google.com with SMTP id o42so4500858vkf.9 for ; Sun, 24 Oct 2021 21:11:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=B04tj7Rd5C+IkwOw0vG6UYfFxILdZP/xthD4HF2j+3E=; b=K/yDetPvascF0i3aGbARBakVpvB+gKMD0JpeXH98gTAPT6wHdwQrUHRttsk5XkB+Oq Jw2MzCxZ1xP2w/jckxP2IPWIxP+H2gikozjayAn8vflEBWVx+sJNfO+dm1aXdyU9U4pN QIzzfoDJ0Y9YowRV8WkEf4U/w67wKcSu0eEAb+9FLJUGiZL48Gn1E+V1rPmw2wATAvDZ b7hDHsZtVcVZo/cXQwLYYy4QX+1ZIJ25iYNZSzgw3i9KKb9BGfSSPzeqLk/zdJFGTncf 4kEVxLcR+vhY/BpAtAYDiKjzF4SFG/YtD8dXWHEXzc8y3NlbsSykYGDemqTld5DvVFb2 JtCg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=B04tj7Rd5C+IkwOw0vG6UYfFxILdZP/xthD4HF2j+3E=; b=wOEPZjQ0hIuAHoiiJZ+TseWj8vmh7rXZxc21nmU7Y//qkXpluvjweOR6ZYyjcYv0Bg zgCIZ1IDNBJAo4czBQ0wfy6A4Z03D1nVrupPjNpcCEZP3DZj9GSS3mk9e8db80KaZnNT B3uhaHifUyl3pSxAQ4u1GeloScy/DYffidTU6ecp9tvFUe9ZZN0tkphgfqOXV0vk1rPU rxzReY4Q+XB0JcQsPG8IXrXDm7xOJ7srXO6rDqMbnQicUTdz98OevQuQZ6BX59fv3mk9 8og7yx4DQ9+iG/XWkIaf1SF82/hp1J8lVtkmD2Wa/Aa59e38F1cVSYBFlJle04CYi4uv VICw== X-Gm-Message-State: AOAM531jpBA5Y1VwI21pivHdWTuD+/Rdz6cZ1YQtzgb6XwfTiKWWhEb3 DoosQgBlDwJS5o5jQ3bZWM9pD8QX+ED5AN5lubE6P6lKbJKe41SPeuzzdsYeMvXKy7zPhc/+zKt GxzL4W1H0N3JmtVs0Kj7KLjOfKftxQcFDejUhBrv6Huav8gwi6JrdAkfGgO2XdFWJiHgC7gOcRA /iz0IaMqs/D5dQw9ldnVrKHyxOOPWiga64h2M/JaAHCAVuGU0RLHDwGLNsdHMDGEtaHM4BfBN9w g== X-Google-Smtp-Source: ABdhPJy2uPJJ8zI1EfN6HnYS1K89IqEaHyys630SBqsn1To/LRE1z4+q3tD+3GRYYB2rV2AQ/F6H6MtOjx2WKtquXfY= X-Received: by 2002:a05:6122:881:: with SMTP id 1mr2732757vkf.19.1635135109691; Sun, 24 Oct 2021 21:11:49 -0700 (PDT) MIME-Version: 1.0 References: <62ACFF92-59AF-4F55-953B-BAFC767FCED7@gmail.com> In-Reply-To: <62ACFF92-59AF-4F55-953B-BAFC767FCED7@gmail.com> From: Aditya Toshniwal Date: Mon, 25 Oct 2021 09:41:13 +0530 Message-ID: Subject: Re: Conditional Tables Feature on PostGresSQL To: "Sanchari Biswas (Shrina)" Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="0000000000005f8f0505cf258fd5" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000005f8f0505cf258fd5 Content-Type: text/plain; charset="UTF-8" Hi Sanchari, You can use the query tool to write anonymous blocks. Else, can you please explain with an example what exactly is the requirement ? On Fri, Oct 22, 2021 at 10:05 PM Sanchari Biswas (Shrina) < sanchari.shrina@gmail.com> wrote: > Hello, > > Is there any existing feature that enables the use of conditional tables > on PostGreSQL, specifically the usage of variables, and implementing those > variables in our (complex) queries? > > Thanks, > Sanchari. > > -- Thanks, Aditya Toshniwal pgAdmin Hacker | Software Architect | *edbpostgres.com* "Don't Complain about Heat, Plant a TREE" --0000000000005f8f0505cf258fd5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Sanchari,

You can use the query tool to write anonymous= blocks. Else, can you please explain with an example what exactly is the r= equirement ?

On Fri, Oct 22, 2021 at 10:05 PM Sanchari Biswas (Shrina)= <sanchari.shrina@gmail.com= > wrote:
= Hello,

Is there any existing feature that enables the use of conditional tables on= PostGreSQL, specifically the usage of variables, and implementing those va= riables in our (complex) queries?

Thanks,
Sanchari.



--
Thanks,
Aditya Toshniwal
pgAdmin Hacker=C2=A0| Software A= rchitect=C2=A0| edbpostgres.com
"Don't Complain about Heat, Plant a TREE&qu= ot;
--0000000000005f8f0505cf258fd5--