20 lines
320 B
PL/PgSQL
20 lines
320 B
PL/PgSQL
|
|
DROP FUNCTION IF EXISTS public.get_rates();
|
|
|
|
CREATE OR REPLACE FUNCTION public.get_rates()
|
|
RETURNS TABLE (
|
|
Id INTEGER,
|
|
Name VARCHAR,
|
|
Price MONEY
|
|
)
|
|
AS $$
|
|
SELECT
|
|
c.id,
|
|
c.name,
|
|
c.price
|
|
FROM public.rates AS c
|
|
ORDER BY c.id;
|
|
$$ LANGUAGE SQL STABLE;
|
|
|
|
|