Home > mailing lists

Re: Table constraints and INSERT - Mailing list pgsql-sql

From	Tom Lane
Subject	Re: Table constraints and INSERT
Date	May 17, 2006 14:13:06
Msg-id	19595.1147875172@sss.pgh.pa.us Whole thread Raw
In response to	Re: Table constraints and INSERT (Niklas Johansson <spot@tele2.se>)
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: "Dave Page"
Date: 17 May 2006, 14:11:10
Subject: Re: Recursive SELECT problem

From: Emi Lu
Date: 17 May 2006, 21:22:38
Subject: Add column and specify the column position in a table

Re: Table constraints and INSERT - Mailing list pgsql-sql

Previous

Next