Random string u PSQL-u

[ Mr. Rejn @ 11.12.2011. 16:44 ] @

Dal neko zna kako da napravim random string u PSQL-u?

Deki

[ darko_sudarov @ 19.07.2012. 13:32 ] @

nije nesto specijalno ali mislim da bi ti resilo problem

Code:
execute block returns (uuid_txt char(36))
as
declare uuid_bin char(16) character set octets;
declare i int = 1;
begin
  while (i > 0) do
  begin
    i = i - 1;
    uuid_bin = GEN_UUID();
    uuid_txt = UUID_TO_CHAR(uuid_bin);
    suspend;
  end
end