Learn how to write your own functions in Postgres with this course | Vertabelo Academy

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

2/18 The user_account table

1. Introduction

2. The user_account table

3. The topic table

4. The post table

5. The post table – example

6. Functions returning void

7. Multiple operations in one function

8. Throwing exceptions

9. Writing complex functions

10. Call a function in SQL

11. Invoke with SELECT does not work in functions

12. Call a function with SELECT in function

13. Assign a query result to a variable

14. Assign a function result to a variable

15. Use SELECT INTO with multiple values

16. Returning a result from INSERT, UPDATE, or DELETE

Awesome! Let's take a look at our first table.

Select all columns from the user_account table. This table stores the following attributes:

id
name
phone
activated_date
is_locked
locked_date
is_deleted
deleted_date

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.