Re: What is the difference of foreign key?

Hi,

Read http://www.postgresql.org/docs/8.4/static/sql-createtable.html

> REFERENCES *reftable* [ ( *refcolumn* ) ] [ MATCH *matchtype* ] [ ON
> DELETE *action* ] [ ON UPDATE *action* ] (column constraint)
> FOREIGN KEY ( *column* [, ... ] ) REFERENCES *reftable* [ ( *refcolumn* [,
> ... ] ) ] [ MATCH *matchtype* ] [ ON DELETE *action* ] [ ON UPDATE *action
> * ] (table constraint)

HTH

Regards,

Serge Fonville

On Thu, Sep 24, 2009 at 4:18 PM, 纪晓曦 <sheepjxx(at)gmail(dot)com> wrote:

> To be precise,
>
> The difference between
>
> create table a (
> foreign key (id) referenced by b(name),
> );
>
> create table b(
> id integer referenced by b(name),
> );
>

--
Convince Google!!
They need to support Adsense over SSL
https://www.google.com/adsense/support/bin/answer.py?hl=en&answer=10528
http://www.google.bg/support/forum/p/AdSense/thread?tid=1884bc9310d9f923&hl=en