#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

If you are a database application developer looking to master development with PostgreSQL using PL/pgSQL, check out this course curated just for you with seasonal offer.! #PostgreSQL #Development #plpgsql

🐘 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

Dependabot #github #PHP #PLpgSQL #TypeScript #CSS #Dockerfile #JavaScript #Shell #Rust

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

I just open sourced a new tool that I built during the pandemic — a pure #plpgsql AST toolkit and deparser for #PostgreSQL, which can be used to create ASTs and deparse them back into strings in native #Postgres

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

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

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

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

Fix title underline too short #github #PLpgSQL #Python #HTML #CSS #JavaScript #Makefile #Go #Java #PHP #Batchfile

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

Ensure season applications request at least one timeslot #github #PHP #PLpgSQL #JavaScript #Twig #CSS #HTML #Shell #Python #Dockerfile

DB import #github #Ruby #PLpgSQL #TypeScript #Python #SCSS #HTML #CSS #JavaScript #Shell

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

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

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

Postgresql: How to access camelcased keys from Record structured in function triggers - Visit for the solution. #postgresql #plpgsql #database_trigger #programming #coding