function not responding with desired result?

Asked Sep 23 '19 at 12:11

Active Sep 23 '19 at 12:19

Viewed 46 times

I'm able to create a PL/pgSQL function successfully. But while running a function it response like below

SELECT  __find_locations() 

Successfully run. Total query runtime: 236 msec.
867 rows affected.

But I'm expecting it to return 867 rows

My function looks like:

CREATE OR REPLACE FUNCTION public.__find_locations() 
    RETURNS TABLE (j json) AS
    $$
        BEGIN
            RETURN QUERY SELECT row_to_json(data) from 
            (SELECT geonameid, latitude, longitude, country_code, country_name, 
             FROM public.locations) AS data; 
        END
    $$
    LANGUAGE 'plpgsql'

Any kind of help will much be appreciated.

edited Sep 23 '19 at 12:19

asked Sep 23 '19 at 12:11

Rajath

2,611
8
27
43

What exactly is your question? – Sep 23 '19 at 12:15
no data is returning while running `SELECT __find_locations() ` – Rajath Sep 23 '19 at 12:16
Which tool do you use to run that query? Maybe that tool truncates large results. – Sep 23 '19 at 12:17
I'm using pgAdmin – Rajath Sep 23 '19 at 12:18
while running `SELECT * FROM locations` I'm able to get the data, then what's wrong with the above functions – Rajath Sep 23 '19 at 12:20
A table function should be used like a table. Does it work if you use `select * from __find_locations()` – Sep 23 '19 at 12:20
Nope, `select * from __find_locations()` also not working.. it is also returning the same result – Rajath Sep 23 '19 at 12:25
Please review help section [mre] and revise your question accordingly. – Belayer Sep 23 '19 at 17:11
Now it is returning result. I don't know why it not worked at that time – Rajath Sep 23 '19 at 17:54

function not responding with desired result?

0 Answers0