I have 2 tables ART and MTF as follow:
create table art(
artidint4 primary key,
mtfidint4, -- can be null or foreign key with MTF
constraint ck_mtfid check(mtfid is null or fk_mtfid(mtfid))
);
create table mtf(
mtfidint4 primary key
);
create function fk_mtfid(int4) returns bool as
Hi again,
I would like to know how we can define a new domain definition (type).
I explain what I want:
I would like to create a type 'address' as char(10) and use address when I
define a type in my database.
> So it seems the 6.5.1 changes are not listed in the INSTALL file,
> though there was some attempt to add them. Thomas, does this make
> sense?
Oops. Sorry, I must have forgotten a section :(
- Thomas
--
Thomas Lockhart [EMAIL PROTECTED]
South
>Hi !
>
>I am trying a big commercial database application with PostgreSQL and I
>encounter some problems seach as how to create a foreign key constraint..
>
>I would be very nice if someone could send me a dump of a real database
>application with TRIGGER / FUNCTION / TYPE / FOREIGN KEY AND PRI
