can i use DATE_PART() Function with postgrest?

[MohammedFaragallah]

I'm trying to build an "On This Day/Week/Month" feature. After some research, I found DATE_PART, but I'm not sure if I can use it with PostgREST.

Right now, I'm using an RPC function (which I’d like to avoid whenever possible) with a query similar to this:

  SELECT *
  FROM employees
  WHERE date_part('month', date_of_birth) = date_part('month', NOW())
    AND date_part('day', date_of_birth) = date_part('day', NOW());

Any suggestions?

[wolfgangwalther]

There is no way to pass the date_part function call via API.

Your options:

• create computed fields for "month" and "day" (of the date of birth) and do the part for "now" on the client-side, then query something like dob_month=eq.2&dob_day=eq.14.
• You should be able to put your query into a view as well.
• Use an RPC.

I'm using an RPC function (which I’d like to avoid whenever possible)

What is bad about an RPC in this case?

For "on this day", you probably don't need any mutations like POST, PUT, PATCH or DELETE on the endpoint. So an RPC seems like a perfect fit to me.

[MohammedFaragallah]

thank you for your great and detailed answer ❤️

Yes sounds like an RPC function is a great fit for this case we will go with it 🙌