
Ryan Booz
@ryanbooz
Sinner saved by Grace, Husband to @laurabooz, Father of 6,
#PostgreSQL π₯ @Redgate. #SQL #family, π΅ π βΎοΈ. Opinions my own.
ID:17131719
http://www.softwareandbooz.com 03-11-2008 14:57:17
3,2K Tweets
620 Followers
288 Following

I'm looking forward to #PSQLPhriday posts tomorrow.
#PostgreSQL has expanded support for non-relational data over the last number of years. Indexing JSONB & ARRAY types, PostGIS, or sometimes just using the functions internally to move data around.
What's your story?

What's one #PostgreSQL function that changed how you work w/data & made your job easier once you knew it existed & how it worked?
I'll go first.
regexp_matches(), especially used w/ a CROSS LATERAL JOIN
For powerful ELT, the entire regexp family can't be beat.





Carpe diem! The CFP for Citus Con: An Event for Postgres | CFP is open!: An Event for Postgres 2023 will close on Sun Feb 5th
Will you submit? We'd love to see your talk proposals about:
- PostgreSQL
- Citus database extension Citus Data
- Azure Database for PostgreSQL
- Azure Cosmos DB for PostgreSQL
citusdata.com/cituscon/2023/β¦



For some reason this morning I realized that I get to think and talk about #PostgreSQL every day as part of my job! π
I still have a billion things to learn, but I really do love how much my π§ gets π₯ up each day by the challenge of it.
Alright... back at it! πͺ




