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

1998-07-11 Thread Antonio Garcia Mari
> > B> PRIMARY KEY: home_team > > B> FOREIGN KEY: home_team JOIN TO baseball_team.team_name > > > Take a look at .../contrib/spi/refint.example. > > I don't suppose you could post the full URL for that? I checked the > examples I use frequently, and I'm not familiar with where that one might > b

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

1998-07-10 Thread Bruce Tong
> B> PRIMARY KEY: home_team > B> FOREIGN KEY: home_team JOIN TO baseball_team.team_name > Take a look at .../contrib/spi/refint.example. I don't suppose you could post the full URL for that? I checked the examples I use frequently, and I'm not familiar with where that one might be. Bruce Tong

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

1998-07-10 Thread Brian
On Fri, 10 Jul 1998, Bruce Tong wrote: > > How can I insure that for example "home_team_name" is one of > > "baseball_team.team_name"? > > > > I have seen in books things like: > > > > PRIMARY KEY: home_team > > FOREIGN KEY: home_team JOIN TO baseball_team.team_name > > > > is there anyway to

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

1998-07-10 Thread Bruce Tong
> How can I insure that for example "home_team_name" is one of > "baseball_team.team_name"? > > I have seen in books things like: > > PRIMARY KEY: home_team > FOREIGN KEY: home_team JOIN TO baseball_team.team_name > > is there anyway to do this in postgresql? I asked the same question a week o

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

1998-07-10 Thread Sferacarta Software
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