Function with SQL query has no destination for result data

by

Do it as plain SQL

CREATE OR REPLACE FUNCTION tst_dates_func() 
    RETURNS TABLE( date_value date, date_id int, date_desc varchar) as
$BODY$   
    select a.date_value, a.date_id, a.date_desc from dates_tbl a;

$BODY$
      LANGUAGE sql;

If you really need plpgsql use return query

CREATE OR REPLACE FUNCTION tst_dates_func() 
    RETURNS TABLE( date_value date, date_id int, date_desc varchar) as
$BODY$   
BEGIN
    perform SELECT dblink_connect('remote_db');
    return query
    select a.date_value, a.date_id, a.date_desc from dates_tbl a;

END;
$BODY$
      LANGUAGE plpgsql;

More Related Contents:

  1. Refactor a PL/pgSQL function to return the output of various SELECT queries
  2. Is SELECT or INSERT in a function prone to race conditions?
  3. Difference between language sql and language plpgsql in PostgreSQL functions
  4. How to return result of a SELECT inside a function in PostgreSQL?
  5. Pass multiple values in single parameter
  6. GROUP BY and aggregate sequential numeric values
  7. PL/pgSQL checking if a row exists
  8. PostgreSQL parameterized Order By / Limit in table function
  9. Return multiple fields as a record in PostgreSQL with PL/pgSQL
  10. PostgreSQL IF statement
  11. Call a set-returning function with an array argument multiple times
  12. Record returned from function has columns concatenated
  13. Postgres Dynamic Query Function
  14. Return setof record (virtual table) from function
  15. Window Functions or Common Table Expressions: count previous rows within range
  16. DROP FUNCTION without knowing the number/type of parameters?
  17. Postgres function returning table not returning data in columns
  18. Return multiple columns and rows from a function PostgreSQL instead of record
  19. COPY with dynamic file name
  20. pseudo_encrypt() function in plpgsql that takes bigint
  21. How to perform a select query in a DO block?
  22. Postgres trigger after insert accessing NEW
  23. INSERT rows into multiple tables in a single query, selecting from an involved table
  24. How to find a table having a specific column in postgresql
  25. PostgreSQL JOIN with array type with array elements order, how to implement?
  26. Postgresql query between date ranges
  27. How to use SQL LIKE condition with multiple values in PostgreSQL?
  28. How to include excluded rows in RETURNING from INSERT … ON CONFLICT
  29. Join a count query on generate_series() and retrieve Null values as ‘0’
  30. Store and reuse value returned by INSERT … RETURNING

Leave a Comment