Hi,
Is a way to define DEFAULT, NOT NULL and REFERENCES for members of composite type?
For example:
-- type
CREATE TYPE bibl.bibliography AS
(
edition TEXT,
publisher_id BIGINT
);
-- table def
create table bibl.monograph
(
id BIGSERIAL PRIMARY KEY NOT NULL,
bibl bibl.bibliography
);
-- how to do that, assuming that:
-- we want edition NOT NULL, DEFAULT with value "first"
-- we want publisher_id reffering to bibl.publisher(id)
This does not work for me:
ALTER TABLE bibl.monograph ALTER COLUMN (bibl).is_bibliography SET NOT NULL;
ALTER TABLE bibl.monograph ALTER COLUMN (bibl).is_bibliography SET DEFAULT false;
Thanks in advance,
Best regards