[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] Table constraints and INSERT
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2006-05-17 14:12:52
Message-ID: 19595.1147875172 () sss ! pgh ! pa ! us
[Download RAW message or body]

Niklas Johansson <spot@tele2.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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
[prev in list] [next in list] [prev in thread] [next in thread]