public inbox for [email protected]  

help / color / mirror / Atom feed
From: Aditya Toshniwal <[email protected]>
To: Sanchari Biswas <[email protected]>
Cc: pgadmin-hackers <[email protected]>
Subject: Re: Conditional Tables Feature on PostGresSQL
Date: Mon, 25 Oct 2021 10:22:48 +0530
Message-ID: <CAM9w-_n5UBsRQgCFqdmi+5hKz6qOUWLmzPHFac566huM5pwgAg@mail.gmail.com> (raw)
In-Reply-To: <CAGDF-HS32cDLahxxnvPZ9AVLQQNRhUFfski+xbo1oSVkJ+ipUw@mail.gmail.com>
References: <[email protected]>
	<CAM9w-_mhjSEDfGatyVP3tk5Tana88eRoMQ++5Sv-a7Yu7WpTPg@mail.gmail.com>
	<CAGDF-HS32cDLahxxnvPZ9AVLQQNRhUFfski+xbo1oSVkJ+ipUw@mail.gmail.com>

Hi Sanchari,

I'm not sure if PostgreSQL provides such a feature, but the closest I can
relate it is to generated columns where you can put the expression to be
evaluated. It doesn't allow variables but you can use other columns in
expresssion - https://www.postgresql.org/docs/12/ddl-generated-columns.html
[image: image.png]

On Mon, Oct 25, 2021 at 10:00 AM Sanchari Biswas <[email protected]>
wrote:

> Hi Aditya,
>
> Can we use variables in any column and then have (Boolean) constraints
> over the variables?
> Eg. x as a variable value and then corresponding condition (x ≠ 5 || x ≠
> 10).
> So that this condition is satisfied when queried with values of column
> (with variable x) other than the above two and the condition converts to
> actual constant values, and returns tuples with that actual value.
>
> Thanks,
> Sanchari.
>
> On Mon, Oct 25, 2021, 12:11 AM Aditya Toshniwal <
> [email protected]> wrote:
>
>> 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) <
>> [email protected]> 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*
>> <http://edbpostgres.com;
>> "Don't Complain about Heat, Plant a TREE"
>>
>

-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*
<http://edbpostgres.com;
"Don't Complain about Heat, Plant a TREE"


Attachments:

  [image/png] image.png (129.8K, 3-image.png)
  download | view image

view thread (4+ messages)

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Conditional Tables Feature on PostGresSQL
  In-Reply-To: <CAM9w-_n5UBsRQgCFqdmi+5hKz6qOUWLmzPHFac566huM5pwgAg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox