# PostgreSQL Functionality Equivalent to Elasticsearch Painless Scripts **URL:** \ **Category:** Elasticsearch\ **Tags:** painless\ **Created:** [September 3, 2025, 9:55am UTC](https://discuss.elastic.co/t/postgresql-functionality-equivalent-to-elasticsearch-painless-scripts/381559 "2025-09-03T09:55:56Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![samrinkomai](https://avatars.discourse-cdn.com/v4/letter/s/e99b99/32.png) [@samrinkomai](https://discuss.elastic.co/u/samrinkomai)\ **Post date:** [September 3, 2025, 9:55am UTC](https://discuss.elastic.co/t/postgresql-functionality-equivalent-to-elasticsearch-painless-scripts/381559/1 "2025-09-03T09:55:56Z")
In elasticsearch I often use painless script inside searches to calculate values dynamically ay query time, for example by manipulating a timestamp field or deriving custom numeric values. Now I am working on a project where part of the data is also stored in PostgreSQL, and I need similar behavior there just like [stumble guys mod](https://stumbleguymod.com). Essentially, I want to apply calculations on fields within the query itself rather than precomputing and storing them. In PostgreSQL I know it is possible to write expressions directly in SQL queries or even create stored functions in PL/pgSQL, but I am not sure if there is a recommended approach that is conceptually closest to how Elasticsearch uses Painless. So the question is what is considered the nearest equivalent to using Painless scripts when working in PostgreSQL? Should I rely mostly on SQL expressions, custom functions, or procedural languages, or is there something else commonly used for this purpose? ---
**Author:** ![leandrojmp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leandrojmp/32/107231_2.png) [@leandrojmp](https://discuss.elastic.co/u/leandrojmp)\ **Post date:** [September 3, 2025, 12:56pm UTC](https://discuss.elastic.co/t/postgresql-functionality-equivalent-to-elasticsearch-painless-scripts/381559/2 "2025-09-03T12:56:40Z")
Hello and welcome, It is not clear how your issue relates to Elasticsearch, it seems that it is related to PostgreSQL? ---
**Author:** ![samrinkomai](https://avatars.discourse-cdn.com/v4/letter/s/e99b99/32.png) [@samrinkomai](https://discuss.elastic.co/u/samrinkomai)\ **Post date:** [September 3, 2025, 1:09pm UTC](https://discuss.elastic.co/t/postgresql-functionality-equivalent-to-elasticsearch-painless-scripts/381559/3 "2025-09-03T13:09:38Z")
its my bad can you please move it to right place for me…??? ---
**Author:** ![leandrojmp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leandrojmp/32/107231_2.png) [@leandrojmp](https://discuss.elastic.co/u/leandrojmp)\ **Post date:** [September 3, 2025, 1:21pm UTC](https://discuss.elastic.co/t/postgresql-functionality-equivalent-to-elasticsearch-painless-scripts/381559/4 "2025-09-03T13:21:28Z")
> [@samrinkomai](#): > > its my bad can you please move it to right place for me…??? You would need to look for a forum related to PostgreSQL, I do not know one, maybe there is something on reddit. This forum is for question and issues related to Elastic tools only. ---
**Author:** ![discourse\_ai\_spam](https://avatars.discourse-cdn.com/v4/letter/d/c68b51/32.png) [@discourse\_ai\_spam](https://discuss.elastic.co/u/discourse_ai_spam)\ **Post date:** [September 3, 2025, 5:18pm UTC](https://discuss.elastic.co/t/postgresql-functionality-equivalent-to-elasticsearch-painless-scripts/381559/5 "2025-09-03T17:18:05Z")
---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 4, 2025, 1:14am UTC](https://discuss.elastic.co/t/postgresql-functionality-equivalent-to-elasticsearch-painless-scripts/381559/6 "2025-09-04T01:14:39Z")