Re: [GENERAL] What to do with no foreign keys

Hello Brian,

giovedì, 9 luglio 98, you wrote:



B> If I have two tables, which are like this:

B> baseball_team
B> -------------
B> team_name
B> number_of_players
B> games_played
B> total_runs


B> baseball_game
B> -------------
B> home_team_name
B> visitor_team_name
B> home_runs
B> visitor_runs



B> How can I insure that for example "home_team_name" is one of
B> "baseball_team.team_name"?

B> I have seen in books things like:

B> PRIMARY KEY: home_team
B> FOREIGN KEY: home_team JOIN TO baseball_team.team_name

B> is there anyway to do this in postgresql? Bascially I have like 12 tables,
B> and alot of them have a field "username".  I want to insure that
B> "username" in all tables, is a valid username in "passwd.username".

B> Brian


B> /-------------------------- signal@shreve.net -----------------------------\
B> | Brian Feeny                | USR TC Hubs | ShreveNet Inc. (318)222-2638  |
B> | Network Administrator      | Perl, Linux | Web hosting, online stores,   |
B> | ShreveNet Inc.             |  USR Pilot  | Dial-Up 14.4-56k, ISDN & LANs |
B> | 89 CRX DX w/MPFI, lots of  |-=*:Quake:*=-| http://www.shreve.net/        |
B> | mods/Homepage coming soon  |LordSignal/SN| Quake server: 208.206.76.47   |
B> \-------------------------- 318-222-2638 x109 -----------------------------/


Take a look at .../contrib/spi/refint.example.

Best regards,
 Jose'                            mailto:sferac@bo.nettuno.it