order by, within a plpgsql fx

Поиск
Список
Период
Сортировка
От
Тема order by, within a plpgsql fx
Дата
Msg-id F3CBFBA88397EA498B22A05FFA9EC49D5B9F2E51@MX22A.corp.emc.com
обсуждение исходный текст
Ответы Re: order by, within a plpgsql fx  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Please consider this plpgsql function:
= = = = = = = = = =
CREATE Or Replace FUNCTION fx_order_by ( )
RETURNS table( last_name text, first_name )
AS $eofx$
DECLARE
--
BEGIN

  Return Query
  select
    lname, fname
  from
    my_table
  order by
    lname  ASC
  ;

END;
$eofx$ LANGUAGE plpgsql;
= = = = = = = = = =

So, is this select statement's result set  guaranteed to be ordered as specified by the [order by] coded within the
functionbody ? 
= = = = = = = = = =
select last_name, first_name from fx_order_by() ;
= = = = = = = = = =

Or, must I code another [order by] to be sure ?
= = = = = = = = = =
select last_name, first_name from fx_order_by()   order by last_name ;
= = = = = = = = = =

Also, is the answer the same for a "sql" function ?

Thanks,
-dvs-





В списке pgsql-general по дате отправления:

Предыдущее
От: Torsten Zuehlsdorff
Дата:
Сообщение: Re: How to convert HEX to ASCII?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: order by, within a plpgsql fx