Search Results

How can I convert this: CREATE OR REPLACE FUNCTION getFooData() RETURNS TABLE(foo_name name text) AS $BODY$ BEGIN RETURN QUERY select foo_name from foo where x = 3; END $BODY$ LANGUAGE plpgsql V …

EDIT: Following the Horse's answer/comment, this is my final version of my function: CREATE OR REPLACE FUNCTION public.pointscanner(IN routegeometry text, IN criteria text) RETURNS TABLE(way geomet …

It was solved by a friend with this statement: select * from test order by case when (ordr='asc') then first_name end asc, case when (ordr='desc') then first_name end desc limit ( sel …

I have this table in a Postgres 9.3 database: I need to use the content of columns order and limit to sort and filter this table. The table will be sorted by column first_name. The final result wi …

I have some query as select x1,x2,x3,x4 from foo where bar resulting something like: CREATE TEMP TABLE foo AS SELECT * FROM ( VALUES ( '00','01','03','AA' ), ( '01','03','03','BB' ), ( '02','09',' …

This function was the one that actualy solved my problem. I'll not accept it because I was not too clear in my question and based in my example the accepted answer is the correct one. The major proble …

I have this function working fine: CREATE or replace FUNCTION pointscanner( IN source integer, IN target integer, IN k integer, IN directed boolean, IN quant integer ) RETURNS ta …

This is the complete full version of the working function: CREATE OR REPLACE FUNCTION public.pointscanner(IN routegeometry text, IN criteria text, IN source text) RETURNS TABLE(way geometry, name t …