Re: Table constraints and INSERT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Niklas Johansson <spot(at)tele2(dot)se>
Cc: Risto Tamme <risto(at)ektaco(dot)ee>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Table constraints and INSERT
Date: 2006-05-17 14:12:52
Message-ID: 19595.1147875172@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Niklas Johansson <spot(at)tele2(dot)se> writes:
> You must cast the integer column to a float or numeric, try:

Since the CHECK is expecting an exact result, better use numeric.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Emi Lu 2006-05-17 21:22:32 Add column and specify the column position in a table
Previous Message Dave Page 2006-05-17 14:10:02 Re: Recursive SELECT problem