#plpgsql

Finished my "SQL and PL/pgSQL Programming Style Guide" which follows Joe Celko’s book - with one notable exception: Put #SQL keywords, datatypes and functions all-lowercase(!) - because they are _not_ the main content! #plpgsql #programming #styleguide

🐘 identifier scope in #plpgsql - be explicit with the namespace to to avoid ambiguous resolution: - prefix columns with the alias - prefix local variables with the label - prefix arguments with the procedure name

I totally approve that message!

Python is bad for the environment while C is the greenest programming language.

@l_avrot Time to rewrite the TAP tests in C?

@ian_barwick_pg @l_avrot I'm interested to know what you think about PGUnit, a lightweight Unit Test framework for PL/pgSQL, which we've upgraded. It's a fork from Adrian Andrei written also in PL/pgSQL. It's now available as a Postgres Extension: #PostgreSQL #PLpgSQL

OpenSearch plan calculator #github #PLpgSQL #Python #HTML #CSS #JavaScript #Makefile #Java #Go #PHP #Batchfile

Insightful contribution by @xurxosanz on this PR, explaining how to add parallel capability to #plpgsql functions in #PostgreSQL / #PostGIS:

Replace image for higher quality one #github #PLpgSQL #Python #HTML #CSS #JavaScript #Java #Makefile #Go #PHP #Batchfile

Ever wondered how PostgreSQL optimizes functions? ⚡ It all comes down to VOLATILE, STABLE, IMMUTABLE🚀 Get this wrong & you could hurt performance and functionality. Broke it down with real-world examples 👇 #PostgreSQL #Performance #plpgsql

Switch from Dependabot to Renovate #github #Python #PLpgSQL #Shell #Dockerfile #TypeScript #JavaScript #HTML #CSS #Shell

TIL #PostgreSQL's #PLpgSQL even knows #Lambda functions! But the extension docs. need a better example: /cc @amplifypostgres

write tests #github #Python #PLpgSQL #Shell #Dockerfile #Python #HTML #JavaScript #CSS

With inspiration from a chit chat in Pgconf, started reading research papers. @FranckPachot IF plpgsql excites you and keen to how and when inlined with sql or core language is possible and diff framework do check out. #plpgsql

Fix year in the footer #github #PLpgSQL #Python #HTML #CSS #JavaScript #Java #Makefile #Go #PHP #Batchfile

Fix broken links in #github #Python #PLpgSQL #Makefile #Java #Python #HTML #Shell #Dockerfile

Sous #PostgreSQL, convertir des nombres en base hexadécimale en nombres en base décimale avec #plpgsql (sous forme de données TEXT). Avec cette fonction, `SELECT hex2dec('b04');` donnera 2820. #hexa #cedtipoftheday

Bug: Link to "Attend a Training Session" in the For Volunteers section of website leads to an Error 404 #github #JavaScript #PLpgSQL #SCSS #CSS #HTML #Dockerfile #Shell

Já reparou naqueles cifrões ($$) que tem no CREATE FUNCTION do #PostgreSQL? Neste vídeo falo disto e dou algumas dicas de FUNÇÕES, LATERAL JOIN e INTERPOLAÇÃO de texto no #plpgsql

[CT-331] Views with persist_docs on columns: check to see if any comments first #github #Python #PLpgSQL #JavaScript #Shell

User profile - Projects #github #TypeScript #PLpgSQL #Java #Python #JavaScript #Shell #Dockerfile #CSS

Working with triggers and historical files in #PostgreSQL #PlpgSQL #100DaysOfCode #WomenWhoCode

When no `supabaseKey` is passed in it throws an error #github #JavaScript #PLpgSQL #Makefile