Advanced SQL queries for Postgres DB (CTE or "WITH RECURSIVE")

Completed Posted Aug 3, 2015 Paid on delivery
Completed Paid on delivery

We have a Postgres DB with users in a hierarchical reporting structure (user table has a column for manager_id, which is a foreign key back to the user table). We have some query problems that are complex. The exact problems are described in the attached PDF.

PostgreSQL SQL

Project ID: #8198596

About the project

16 proposals Remote project Active Aug 5, 2015

Awarded to:

angnut

Hi, I can work on this job, today and tomorrow in my morning. I don't know Postgres but I have a lot of experience in SQL and SQL Server. The solution will be agnostic (pure SQL). You can find my reference on linkedi More

$277 USD in 2 days
(5 Reviews)
3.0

16 freelancers are bidding on average $328 for this job

nikmah344

Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 6+ years of experience in Web Development. I have worked on below technologie More

$250 USD in 3 days
(22 Reviews)
5.3
aamaia

Hi, I'm interested. It can be accomplished using the "with RECURSIVE" construction. Looking forward to hear from you.

$526 USD in 3 days
(5 Reviews)
4.7
vinaysinghh

I am Oracle DBA having more then 5 yrs of experience in sql Oracle and mysql. I can do this very easily..

$277 USD in 1 day
(31 Reviews)
4.5
partsgr12

Hi, I am DB developer with good sql writing skills. I propose to work with you. From the proposal, it is not clear how many recursive queries, you have issues with. My proposal is to fix a max of 8 recursive More

$250 USD in 10 days
(4 Reviews)
3.5
vw8209707vw

Experience over 15 years in IT in the areas of development, systems analysis and database. Graduate in database and Master in Electrical Engineering

$833 USD in 3 days
(0 Reviews)
0.0
OmriShraga

i'm a certified dba (data base admin) and i can do this task for you in less then two days time. if and when you chose to use my services please don't forget to give me a good review.

$250 USD in 10 days
(0 Reviews)
0.0
yuriytigiev

I will provide solution ASAP.

$333 USD in 14 days
(0 Reviews)
0.0
SUXONUSA

I am really good in this kinf of problems. Please send a private message I am really good in this kinf of problems I am really good in this kinf of problems

$250 USD in 0 days
(1 Review)
0.0
rudobrody

i've 17y+ experience writting strange sql queries. your problems look easy for recursive query - but dependent on how many records do you have in tables and how many query will be executed per second, it may be worth t More

$250 USD in 3 days
(0 Reviews)
0.0
deepakgarg2010

A proposal has not yet been provided

$320 USD in 10 days
(0 Reviews)
0.0
grtdeveloper

8 Years of Experience in Databases -- PostGresSQL, MySQL. Did DB Setup using scripts , handling, tunning.

$284 USD in 2 days
(0 Reviews)
0.0
fmick

Предложение еще не подано

$280 USD in 5 days
(0 Reviews)
0.0
aleksandar1112

I have experience in similar project task. They can quickly and efficiently to respond to the challenge of the task requires. If you decide it would be useful to provide an example of what the function should return.

$333 USD in 4 days
(0 Reviews)
0.0
shawnmire

I have worked extensively with advanced queries such as these, both in my job and in my personal projects. For this project, I will utilize a recursive CTE. The users reporting to the specified user_id will be sele More

$250 USD in 0 days
(0 Reviews)
0.0