Re: Conditional Tables Feature on PostGresSQL

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 <sanchari(dot)shrina(at)gmail(dot)com>
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 <
> aditya(dot)toshniwal(at)enterprisedb(dot)com> 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) <
>> sanchari(dot)shrina(at)gmail(dot)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*
>> <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"