Closed

Fix a filtering function inside a postgresql function script

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.

Skills: PostgreSQL

See more: postgresql window functions, postgresql string_agg, postgres mode example, within group sql, postgres window function where clause, postgres filter order, postgres within group example, postgres filter example, example iframe inside php script, html tags inside perl script, php script function imap receive email, page inside page script, run php inside bash script, bash shell script function, script function upload, sed inside bash script, read xml script function, postgresql automatic function maker, imput variable inside php script, call java script function delphi

About the Employer:
( 8 reviews ) Kristiansand, Norway

Project ID: #17468537

11 freelancers are bidding on average $84 for this job

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 More

$60 USD in 1 day
(3 Reviews)
2.9
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 More

$35 USD in 2 days
(2 Reviews)
1.2
djpeka

Hello. As a professional programmer, I can take a look at it for you. Just hit me up.

$155 USD in 3 days
(0 Reviews)
0.0
$60 USD in 1 day
(0 Reviews)
0.0
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 in 3 days
(0 Reviews)
0.0
vermadeepak77

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

$94 USD in 2 days
(0 Reviews)
0.0
$30 USD in 2 days
(0 Reviews)
0.0
$55 USD in 1 day
(0 Reviews)
0.0
abruck

I've been working with Databases since 1984: including Oracle, PostgreSQL, MS Access, mySQL, etc. on unix, Windows and Cloud environments. I have done data analysis, modeling, migration, conversion, integration, aggreg More

$277 USD in 3 days
(0 Reviews)
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 in 2 days
(0 Reviews)
0.0
$40 USD in 5 days
(0 Reviews)
0.0