A partir de Firebird 2.1 tienes una función que te devuelve uno de esos valores:
gen_uuid
http://www.firebirdsql.org/refdocs/l...-gen_uuid.html
Cita:
select gen_uuid() from rdb$database
-- returns e.g. 017347BFE212B2479C00FA4323B36320 (16-byte string)
|
Luego puedes visutalizarlo con:
uuid_to_char
http://www.firebirdsql.org/refdocs/l...d_to_char.html
Cita:
select uuid_to_char(x'876C45F4569B320DBCB4735AC3509E5F') from rdb$database
-- returns '876C45F4-569B-320D-BCB4-735AC3509E5F'
select uuid_to_char(gen_uuid()) from rdb$database
-- returns e.g. '680D946B-45FF-DB4E-B103-BB5711529B86'
select uuid_to_char('Firebird swings!') from rdb$database
-- returns '46697265-6269-7264-2073-77696E677321'
|