Composite type, DEFAULT, NOT NULL, REFERENCES

From: erhaminus <erhaminus(at)o2(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: Composite type, DEFAULT, NOT NULL, REFERENCES
Date: 2011-10-19 14:32:50
Message-ID: 1e4f58e1.6aac820e.4e9edf92.278e7@o2.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-10-19 16:10:46 Re: Composite type, DEFAULT, NOT NULL, REFERENCES
Previous Message Achilleas Mantzios 2011-10-19 14:12:58 Re: installing tsearch2