---
title: "Discussion on \"How VOLATILE, IMMUTABLE, and STABLE Attributes Affect Functions in Supabase\" | Hashnode"
description: "Discussion on \"How VOLATILE, IMMUTABLE, and STABLE Attributes Affect Functions in Supabase\". In Supabase, which is built on PostgreSQL, when you create functions using PL/pgSQL (Procedural Language/PostgreSQL), you have the option to specify the volatility category of each function: VOLATILE, STABLE, or IMMUTABLE. These categories describe h..."
url: "https://hashnode.com/posts/how-volatile-immutable-and-stable-attributes-affect-functions-in-supabase/67003cf147f3b05aec010f59"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [How VOLATILE, IMMUTABLE, and STABLE Attributes Affect Functions in Supabase](https://thingengineer.hashnode.dev/how-volatile-immutable-and-stable-attributes-affect-functions-in-supabase?utm_source=hashnode&utm_medium=feed)

In Supabase, which is built on PostgreSQL, when you create functions using PL/pgSQL (Procedural Language/PostgreSQL), you have the option to specify the volatility category of each function: VOLATILE, STABLE, or IMMUTABLE. These categories describe h...

Oct 4, 2024 · 7 min read · thingengineer.hashnode.dev  
Read the article

-   [#supabase](https://hashnode.com/tag/supabase)
-   [#plpgsql](https://hashnode.com/tag/plpgsql)
-   [#postgres](https://hashnode.com/tag/postgres)
-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#databases](https://hashnode.com/tag/databases)

## Written by

[Josh Campbell](https://hashnode.com/@thingengineer)

@thingengineer

  
[View profile](https://hashnode.com/@thingengineer)

Profoundly curious, lifelong learner making the type of products I would want to use.

Passionate about leveraging geospatial technologies to build innovative solutions. Skilled in PostGIS, SQL, JavaScript, Supabase, Vercel, Linux, and DevOps. Available for consulting projects related to GIS, spatial data, and web development.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
