7 Matching Annotations
  1. Jun 2021
    1. You can use the pg_typeof() function, which also works well for arbitrary values. SELECT pg_typeof("stu_id"), pg_typeof(100)

      pg_typeof

    1. In this case it's probably better to have the function return a tabletype, RETURNS table, or define the output with OUT variables. Therecord defining syntax at time of query: SELECT foo() AS (a int, b text);
  2. Jun 2020
  3. Nov 2019