In the previous chapter, we talked about the different data types available in PL/pgSQL and how to use them with some examples. In this chapter, we will cover how to work with strings, numbers, and arrays inside PL/pgSQL of PostgreSQL. It will include examples of how to declare variables, perform operations, and manipulate data within these data types. Additionally, it will cover best practices for working with these ...
4. Dealing with Strings, Numbers, and Arrays
Get Procedural Programming with PostgreSQL PL/pgSQL: Design Complex Database-Centric Applications with PL/pgSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.