Re: Conditional Tables Feature on PostGresSQL

Поиск
Список
Период
Сортировка
От Sanchari Biswas
Тема Re: Conditional Tables Feature on PostGresSQL
Дата
Msg-id CAGDF-HS32cDLahxxnvPZ9AVLQQNRhUFfski+xbo1oSVkJ+ipUw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Conditional Tables Feature on PostGresSQL  (Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>)
Ответы Re: Conditional Tables Feature on PostGresSQL  (Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>)
Список pgadmin-hackers
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.toshniwal@enterprisedb.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.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"

В списке pgadmin-hackers по дате отправления:

Предыдущее
От: Aditya Toshniwal
Дата:
Сообщение: Re: Conditional Tables Feature on PostGresSQL
Следующее
От: Aditya Toshniwal
Дата:
Сообщение: Re: Conditional Tables Feature on PostGresSQL