Re: setting up foreign keys

Merlin Moncure wrote:
> On 8/10/06, Chris <dmagick@gmail.com> wrote:
>> Sue Fitt wrote:
>> > Thanks Chris and Chris, you've solved it.
>> >
>> > I had a gui open that connects to the database. It was doing nothing
>> > (and not preventing me adding to or altering headwords_core via psql),
>> > but having closed it the table is instantly created. Weird.
>> >
>> > BTW, referencing the same column twice is deliberate, it's a
>> > cross-reference.
>>
>> The same column and the same table?
>>
>> Same column different table I could understand but not the same column &
>> table ;)
>
> create table color(color text);
>
> create table person(eye_color text references color(color), hair_color
> text references color(color));

lol. Good point :)

*back to the hidey hole!*

--
Postgresql & php tutorials
http://www.designmagick.com/