NSTRAINT two_fk foreign key(col_b) REFERENCES
tbl_one(col_a) match full;
The biggest thing that I have noticed is many things require you to use
separate ALTER statements in order for them to work.
I hope this helps.
jeff
Jeff Daugherty
Database Systems Engineer
Great Bridge, LLC
---
desc is a reserved word (descending, ascending, having, from, etc...),
as in:
select * from foo order by col_a desc;
That is why you need the double quotes.
jeff
Jeff Daugherty
Database Systems Engineer
Great Bridge LLC
[EMAIL PROTECTED] wrote:
> I have 7.1
>
> Can someone take a
I see no reason why a second SERIAL column would be needed. As in the
example for creating tbl_c, when you have a SERIAL as a primary key,
the foreign keys that reference it should be int4 not SERIAL.
jeff
Jeff Daugherty
Database Systems Engineer
Great Bridge LLC
will trillich wrote:
>
