Find Jobs
Hire Freelancers

Write PostgreSQL function

$10-150 USD

Closed
Posted about 6 years ago

$10-150 USD

Paid on delivery
I need to write a postgres function that will be given a parameter 'search_text'. It will then search table for occurences in few columns (col1, col2, etc). It will return total results per column as well as first n rows. N to be specified. This to be returned as json. I need this done within 1-2h.
Project ID: 16651213

About the project

16 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average $67 USD for this job
User Avatar
Hi, I read your requirements to write sql statements for search_term in your db. I am expert in SQL queries. Wish positive response from your end so we can start the work soon. Thanks.
$50 USD in 1 day
5.0 (494 reviews)
7.6
7.6
User Avatar
How are you, pkkos?. Do you need to write a postgres function that will be given a parameter 'search_text' ?.I can do this project as well Our skills same your requirement skills : Python, PostgreSQL, SQL,PHP. I always: -Do project fast as possible. -Charge a reasonable cost. -Provide Quality Product. All my previous project was feedbacked 5 stars. because i care the customer feeling. I'm waiting you ping me via inbox to do this project. please please please!
$95 USD in 2 days
5.0 (58 reviews)
6.1
6.1
User Avatar
Hi, I would like to write postgres function to check the table occurence and return the output as json. Available to start now. please get in touch to discuss more. Regards, Manish
$88 USD in 0 day
4.9 (128 reviews)
6.3
6.3
User Avatar
I can do this for you. I have 5 years of experience in Postgresql. Contact me if you have any questions.
$111 USD in 1 day
4.9 (33 reviews)
5.4
5.4
User Avatar
Hi, I read your request. I can provide you with the required postgress function
$50 USD in 1 day
5.0 (22 reviews)
5.5
5.5
User Avatar
Hello, I have briefly read the description on PostgreSQL development, and I can deliver as per the requirements however I need us to discuss for more clarity on the details, deadline and budget as well.
$88 USD in 10 days
5.0 (12 reviews)
4.7
4.7
User Avatar
Rich experience on PostgreSQL and JSON. can do it in 2 hours
$55 USD in 1 day
4.9 (14 reviews)
4.8
4.8
User Avatar
Hello how are you, I hope you, were reading your requirement and I know how to solve it I have good experience with postgresql write me and we can clarify details in the chat I will be attentive to your request.
$50 USD in 1 day
4.6 (5 reviews)
3.2
3.2
User Avatar
$20 USD in 1 day
5.0 (3 reviews)
2.1
2.1
User Avatar
We Beieve there are three responses to a piece of design – YES, NO, and BEYOUTIFOOL. Please go through our PORTFOLIO for our previous BEYOUTIFOOL DESIGNS...
$10 USD in 4 days
5.0 (6 reviews)
2.0
2.0
User Avatar
I am Vaibhav Tandale, 2+ years experienced in python, PostgreSQL, Django. I am confident enough to handle this task. I am ready to start immediately. Please share all the details regarding the project. I welcome an opportunity for a possible interview and look forward to your questions related to this. I appreciate your valuable time and consideration and would like to work with you. Regards, Vaibhav
$88 USD in 10 days
4.6 (1 review)
1.4
1.4
User Avatar
Hello, I can make it fast as possible just give me more details about the function you want to have.
$15 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I worked on PostgreSQL and and written functions alike your requirement. If you assign this job to me I can complete this in 5 days.
$88 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey, hope your well. So I wanted to work out some of the requirements here. Do you want this as pure postgres? I can do the work much faster in python if you're using that (I noticed that was one of the tagged skills) If pure postgres that also shouldn't be an issue. Do you know what version of postgres you are using? 9.4 introduces some nice features that supports outputting json. Would this function always work on the same table and columns? Or does it need to specify the table and columns when being called? If so we have to make sure the columns are always of the same type. I assume for each column we want to return an integer. I'm not sure what you mean by 'as well as first n rows'. If you can give me more specific details on this feature I would appreciate it. This work is completely doable but to be reasonable I would probably need a day to be on the safe side. What I propose to do in that time is build a test database locally with some dummy data. Write and test this function and deliver it to you. Hope to hear back from you soon. If not I hope you the best with your problem.
$111 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of POLAND
Lodz, Poland
5.0
53
Payment method verified
Member since Jun 11, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.