Re: MATCH FULL flawed?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)atentus(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: MATCH FULL flawed?
Date: 2001-10-24 18:35:29
Message-ID: 21790.1003948529@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera <alvherre(at)atentus(dot)com> writes:
>> You're not using it right. You specified a separate MATCH FULL
>> constraint for each column:

> Now that I think about it: it's in the column_constraint part of the
> definition! Shouldn't it only be in the table_constraint part? It
> doesn't make much sense.

No, it doesn't, but the SQL spec requires us to accept it both places...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2001-10-24 18:37:38 Re: Writing BLOBS to pgsql via ODBC using VB
Previous Message Tom Lane 2001-10-24 18:31:47 Re: Snapshot is not working