From: | "Gareth Kirwan" <gbjk(at)thermeoneurope(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | INT array field referencing same table |
Date: | 2002-10-23 09:26:59 |
Message-ID: | KMEELFAKJGHIGGNIDGHDCEACJPAA.gbjk@thermeoneurope.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Gareth StationeryI just wanted to check that this is the right syntax for a
table.
CREATE TABLE articles (
id INT PRIMARY KEY DEFAULT nextval('articles_seq'),
category INT,
type INT,
title VARCHAR(50),
description TEXT,
link INT,
date timestamp,
related[] INT,
CONSTRAINT articles_categories_const FOREIGN KEY (category)
REFERENCES a_categories (id) ON DELETE CASCADE,
CONSTRAINT articles_types_const FOREIGN KEY (type) REFERENCES
a_types (id) ON DELETE CASCADE,
CONSTRAINT articles_links_const FOREIGN KEY (link) REFERENCES
a_links (id) ON DELETE CASCADE,
CONSTRAINT articles_related_const FOREIGN KEY (related) REFERENCES
articles (id)
);
The bit that I'm curious about is the related field.
Can I do it like this / Should I do it like this.
The array of integers should reference the id of the same table.
If anyone has any more general comments about the design, They'd be welcome
too :-)
Should I index the date field if i expect it to be searched upon regularly
???
Thanks
Regards
Gareth Kirwan
Programming & Development,
Thermeon Europe Ltd,
gbjk(at)thermeoneurope(dot)com
Tel: +44 (0) 1293 864 303
Thermeon Europe e-Card: gbjk
From | Date | Subject | |
---|---|---|---|
Next Message | Gareth Kirwan | 2002-10-23 09:29:55 | Re: INT array field referencing same table |
Previous Message | Dan Langille | 2002-10-23 04:49:52 | Re: security rights per database DDL/DML connect |