Fix a filtering function inside a postgresql function script

Закрито Опубліковано %project.relative_time Оплачується при отриманні
Закрито Оплачується при отриманні

We have a postgresql function that selects from tree tables.

Now we also have a "filter" field telling if we should return data from all tree tables, or just one of them.

Therefore we need some sort of

IF filter = 'case 1' OR filter = 'case 2' THEN

SELECT ....

IF filter = 'case 1' OR filter = 'case 3' THEN

SELECT ....

IF filter = 'case 1' OR filter = 'case 4' THEN

SELECT ....

Since I'm not that good with Postgres I was hoping someone can have a look at this.

Thanks.

PostgreSQL

ID Проекту: #17468537

Про проект

10 заявок(-ки) Дистанційний проект Остання активність 5 роки(ів) тому

10 фрілансерів(-и) готові виконати цю роботу у середньому за $77

Darwin21015

Hello how are you ? I hope you are well, I am very interested in your project and in solving your query problem I have enough experience in postgresql I have made many queries, triggers, views, complete development of Більше

$60 USD за 1 день
(4 відгуків(и))
3.0
lemarin68

Database administrator for PostgreSQL, SQL Server, for 8 years in a row. I would like to help you in your request, I have done similar tasks in previous projects, as I offer, I could finish this project max. two day Більше

$35 USD за 2 дні(-в)
(2 відгуків(и))
1.2
thanhvinhphan

If your script use language plpgsql, just copy to me, I will help you to fixed. If it do not take more time, I can free for you.

$55 USD за 3 дні(-в)
(0 відгуків(и))
0.0
vermadeepak77

hi I am good in postgresql, let me modify this query for you. thanks deepak

$94 USD за 2 дні(-в)
(0 відгуків(и))
0.0
fradut

I will solve your problem! We need to have a discution to clarify some problems and then I will solve your problem!

$66 USD за 2 дні(-в)
(0 відгуків(и))
0.0