Order by parameter inside pgsql function ignored
От | Anton Marchenkov |
---|---|
Тема | Order by parameter inside pgsql function ignored |
Дата | |
Msg-id | 4A24D710.30803@handybank.ru обсуждение исходный текст |
Ответы |
Re: Order by parameter inside pgsql function ignored
Re: Order by parameter inside pgsql function ignored Re: Order by parameter inside pgsql function ignored |
Список | pgsql-general |
Hi! I'm trying to use the order by parameter inside a function, but it is ignored. Any ideas why? And how can I sort by external parameters inside pgsql function? CREATE OR REPLACE FUNCTION "public"."test_order_by" (sort_key varchar) RETURNS SETOF "customers"."customers_with_mark_deleted" AS $body$ DECLARE rec RECORD; BEGIN FOR rec IN SELECT * FROM customers.customers_with_mark_deleted c ORDER BY sort_key ASC LOOP RETURN NEXT rec; END LOOP; RETURN; END; $body$ LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER COST 100 ROWS 1000; -- Best regards, Anton Marchenkov.
В списке pgsql-general по дате отправления: