Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Tue, 26 Feb 2008, craigp wrote:
>> These create table commands succeed, even tho the foreign key refers to
>> a 'different' type (int2 product_id column refers to an int8 column):
> The requirements in recent SQL specs appears to be that the column ty
On Tue, 26 Feb 2008, craigp wrote:
> These create table commands succeed, even tho the foreign key refers to
> a 'different' type (int2 product_id column refers to an int8 column):
The requirements in recent SQL specs appears to be that the column types
are comparable, not the same.
SQL2003 11.8
These create table commands succeed, even tho the foreign key refers to a
'different' type (int2 product_id column refers to an int8 column):
CREATE TABLE products (
id int8 primary key,
name text not null
);
CREATE TABLE orders (
id int8 PRIMARY KEY,
product_id int2 not null REF