How to run a function without storing it postgresql

Asked Mar 23 '22 at 10:00

Active Mar 23 '22 at 10:07

Viewed 50 times

Sorry I'm pretty new on this i would like to run something like the code but without storing it, just output the data as i am a read only user in the database I want to run it. BTW i know that the code there is very simple. I just wanna know how to print the data as it is an example.

CREATE [OR REPLACE] FUNCTION a ()
RETURNS timestamp
LANGUAGE plpgsql   
AS $variable_name$     
DECLARE 
  time_a timestamp; 
BEGIN     
  SELECT facilitytime 
     INTO time_a 
  FROM metrics 
  ORDER BY facilitytime DESC 
  LIMIT 1;   

  RETURN time_a;
END;    
$$

edited Mar 23 '22 at 10:07

a_horse_with_no_name

497,550
91
775
843

asked Mar 23 '22 at 10:00

Reikryv

Use `select a()` to "print" the result – a_horse_with_no_name Mar 23 '22 at 10:08
Sorry but that would store it, right? I would like to output the data directly – Reikryv Mar 23 '22 at 10:11
Then run the SELECT statement directly – a_horse_with_no_name Mar 23 '22 at 10:16
There is were i have a problem as i want to use variables and multiple selects – Reikryv Mar 23 '22 at 10:19
Then describe _that_ problem, not some code you aren't actually using. – a_horse_with_no_name Mar 23 '22 at 10:19
It is that code but with more selects a variables – Reikryv Mar 23 '22 at 10:22
I think what you are looking for is anonymous code blocks (available since PG 9). Look at the answers [here](https://stackoverflow.com/questions/766657/how-do-you-use-variables-in-a-simple-postgresql-script) for some examples – Jonathan Willcock Mar 23 '22 at 14:12
@JonathanWillcock,. Except `DO`(anonymous) functions can't return values, you either have to 1) `RAISE NOTICE` in the function or 2) Inside the function `INSERT/UPDATE` the values into a table, which the OP says they can't do. – Adrian Klaver Mar 23 '22 at 15:44
It seems me given the restrictions, that you need to create a function outside the database in the language of your choice. – Adrian Klaver Mar 23 '22 at 15:46
@AdrianKlaver Yes it was `RAISE NOTICE` that I had in mind. The link I gave contained at least one example – Jonathan Willcock Mar 23 '22 at 16:08

How to run a function without storing it postgresql

0 Answers0