keith and tom, thanks for the responses. as per a
suggestion i received via email only, i think i will
be best served by creating a t_note_area table and
linking its primary key, note_area_id into the notes
table -> t_notes.note_area_id.
that way i get keith's benefit of full nomenclature
and i also don't have to limit myself by hardcoding
the area names.
i do exactly this for note_contact, but somehow i
wasn't thinking through this situation the way i
should have been.
thanks to everyone for getting me back on the right track.
Start your day with Yahoo! - make it your home page
In response to
pgsql-novice by date
|Next:||From: Michael Fuhr||Date: 2005-07-29 02:39:25|
|Subject: Re: Troubles with PL/Perl in PgSQL|
|Previous:||From: Keith Worthington||Date: 2005-07-28 18:47:30|
|Subject: Re: Table Design Issue & PGSQL Performance|