reading.fm reading.fm

PostgreSQL example of self-contained stored procedures

Written by Derek Sivers in Derek Sivers

PostgreSQL example of self-contained stored procedures
Previous blogshow Next blogshow
0:00 1:12
Blog

First, see my previous article about PostgreSQL functions at sivers.org/pg. That article gave tiny examples, but no finished working code.

More #blogshows

by Derek Sivers
Travel without a phone
Travel without a phone
Personal Development
Derek Sivers
My old clothes don’t fit
My old clothes don’t fit
Personal Development
Derek Sivers
Meta-considerate
Meta-considerate
Personal Development
Derek Sivers
Have a private email account
Have a private email account
Personal Development
Derek Sivers
Future posthumous autobiography
Future posthumous autobiography
Personal Development
Derek Sivers
Would you make your art if you were the last person on earth?
Would you make your art if you were the last person on earth?
Personal Development
Derek Sivers
Where to find the hours to make it happen
Where to find the hours to make it happen
Personal Development
Derek Sivers
Don’t quote. Make it yours and say it yourself.
Don’t quote. Make it yours and say it yourself.
Personal Development
Derek Sivers
How I got rich on the other hand
How I got rich on the other hand
Personal Development
Derek Sivers
Time is personal. Your year changes when your life changes.
Time is personal. Your year changes when your life changes.
Personal Development
Derek Sivers
That’s version infinity. First launch version 0.1.
That’s version infinity. First launch version 0.1.
Personal Development
Derek Sivers
And if only 1% of those people…
And if only 1% of those people…
Personal Development
Derek Sivers
Sammy Cahn said thank you
Sammy Cahn said thank you
Personal Development
Derek Sivers
When you win the game, you stop playing
When you win the game, you stop playing
Personal Development
Derek Sivers
Digital pollution
Digital pollution
Personal Development
Derek Sivers
Cut out everything that’s not surprising
Cut out everything that’s not surprising
Personal Development
Derek Sivers
Doors and windows and what’s real
Doors and windows and what’s real
Personal Development
Derek Sivers
Monthly self-expansion project
Monthly self-expansion project
Personal Development
Derek Sivers
Daydreaming is my favorite pastime
Daydreaming is my favorite pastime
Personal Development
Derek Sivers
Human nature to focus on the one bad thing
Human nature to focus on the one bad thing
Personal Development
Derek Sivers
Back and forth between super-hot and super-cold
Back and forth between super-hot and super-cold
Personal Development
Derek Sivers
Blowing off work to play
Blowing off work to play
Personal Development
Derek Sivers
How to ask your mentors for help
How to ask your mentors for help
Personal Development
Derek Sivers
Tour -isms
Tour -isms
Personal Development
Derek Sivers
How I became Ryuichi Sakamoto’s guitarist
How I became Ryuichi Sakamoto’s guitarist
Personal Development
Derek Sivers
Is there such a thing as too much freedom?
Is there such a thing as too much freedom?
Personal Development
Derek Sivers
Sprezzatura
Sprezzatura
Personal Development
Derek Sivers
When in doubt, try the difference
When in doubt, try the difference
Personal Development
Derek Sivers
Experiments in music and life
Experiments in music and life
Personal Development
Derek Sivers
Your heroes show which way you’re facing
Your heroes show which way you’re facing
Personal Development
Derek Sivers
Daydreaming the downside, for once
Daydreaming the downside, for once
Personal Development
Derek Sivers
Travel without social praise
Travel without social praise
Personal Development
Derek Sivers
What I did belies why
What I did belies why
Personal Development
Derek Sivers
Cross the world four times
Cross the world four times
Personal Development
Derek Sivers
The art of selfishness
The art of selfishness
Personal Development
Derek Sivers
Why experts are annoying
Why experts are annoying
Personal Development
Derek Sivers
What you learn by travelling
What you learn by travelling
Personal Development
Derek Sivers
PostgreSQL example of self-contained stored procedures
PostgreSQL example of self-contained stored procedures
Personal Development
Derek Sivers
Mastery school
Mastery school
Personal Development
Derek Sivers
How to take a compliment
How to take a compliment
Personal Development
Derek Sivers
Human Intervention as a Competitive Advantage
Human Intervention as a Competitive Advantage
Personal Development
Derek Sivers
What happens when we ignore plans?
What happens when we ignore plans?
Personal Development
Derek Sivers
Err on the side of action, to test theories
Err on the side of action, to test theories
Personal Development
Derek Sivers
Anti-chameleon
Anti-chameleon
Personal Development
Derek Sivers
Where we do and don’t want automation
Where we do and don’t want automation
Personal Development
Derek Sivers
Living according to your hierarchy of values
Living according to your hierarchy of values
Personal Development
Derek Sivers
Benefits of a daily diary and topic journals
Benefits of a daily diary and topic journals
Personal Development
Derek Sivers
Heed your fears
Heed your fears
Personal Development
Derek Sivers