INT array field referencing same table

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

Responses

Browse pgsql-admin by date

  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