new_guid

Return a new globally universal identifier value

Syntax

new_guid()

Description

This function returns a new globally universal identifier value.

Example

create database misdb;
create table salesperson(
 	sale_id guid primary key,
 	sale_name char(30),
	gender char,
	dob date
);
create table customer(
 	cust_id char(3) primary key,
	name char(38),
 	sale_id guid not null 
 		references salesperson 
 			on update cascade 
 			on delete restrict
);
commit;

insert into salesperson values new_guid(), "Haskell, Eddie", "M", date "1943-07-01";
insert into customer values "TBC", "Cleaver, Theodore", last_insert_guid();
commit;