3 ms·
I have just learned about the RETURNING close of INSERT just a few months ago for example and I'm programming since 1983... and I've learnt it from someone, who
by onetom 4y ago
I have just learned about the RETURNING close of INSERT just a few months ago for example and I'm programming since 1983... and I've learnt it from someone, who is 20 years older than me...
- forinti 4y agoI started using databases a lot at a time when I was coding in Java. I would search for SQL tricks that would simplify my Java, so RETURNING was one of the first things I used heavily. Soon I discovered window functions so that I could, for instance, get my data back with an extra column with the total number of rows, or the data in the first and last rows, and so on. These little things had a large impact on the number of lines of Java that I had to write.
- funcDropShadow 4y agoThat is one of the reasons why I enjoy working with PostgreSQL. It's reference manual is of such high quality, that I consult it before Google or Stack Overflow when I have questions. That lead me to the discovery of many useful features of the years.