Store query result in a variable using in PL/pgSQL

by

I think you’re looking for SELECT select_expressions INTO:

select test_table.name into name from test_table where id = x;

That will pull the name from test_table where id is your function’s argument and leave it in the name variable. Don’t leave out the table name prefix on test_table.name or you’ll get complaints about an ambiguous reference.

More Related Contents:

  1. Do stored procedures run in database transaction in Postgres?
  2. Refactor a PL/pgSQL function to return the output of various SELECT queries
  3. Keep PostgreSQL from sometimes choosing a bad query plan
  4. Difference between language sql and language plpgsql in PostgreSQL functions
  5. Copying PostgreSQL database to another server
  6. Primary keys with Apache Spark
  7. How can I put a database under git (version control)?
  8. Pass multiple values in single parameter
  9. How to set value of composite variable field using dynamic SQL
  10. PL/pgSQL checking if a row exists
  11. PostgreSQL parameterized Order By / Limit in table function
  12. Return multiple fields as a record in PostgreSQL with PL/pgSQL
  13. How do IMMUTABLE, STABLE and VOLATILE keywords effect behaviour of function?
  14. PostgreSQL: Drop PostgreSQL database through command line [closed]
  15. Return setof record (virtual table) from function
  16. How to pass custom type array to Postgres function
  17. Import SQL dump into PostgreSQL database
  18. How to find a table having a specific column in postgresql
  19. how to use Blob datatype in Postgres
  20. Test for null in function with varying parameters
  21. Postgres function returning table not returning data in columns
  22. Postgres FOR LOOP
  23. How can I solve Postgresql SCRAM authentication problem?
  24. Convert SQLITE SQL dump file to POSTGRESQL
  25. Is it better to use multiple databases with one schema each, or one database with multiple schemas? [closed]
  26. How to login and authenticate to Postgresql after a fresh install?
  27. PostgreSQL Database Log Transaction
  28. How do I automatically update a timestamp in PostgreSQL
  29. How to perform a select query in a DO block?
  30. Backup/Restore a dockerized PostgreSQL database

Leave a Comment