============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Mike Nguyen
Your email address : mikeetn@yahoo.com
System Configuration
---------------------
Architecture (example: Intel Pentium) :
Intel Pentium
Operating System (example: Linux 2.0.26 ELF) : NT
4.0 sp6
PostgreSQL version (example: PostgreSQL-7.1.1):
PostgreSQL-7.1.2
Compiler used (example: gcc 2.95.2) : gcc
Please enter a FULL description of your problem:
------------------------------------------------
The following SQL statement fails to run because of
the check constraint
(num >= 0.0). It runs fine in Oracle sqlplus.
> create table test (
num numeric (10, 2) check (num
>= 0.0 and num <= 100.0)
)
Error: ERROR: Unable to identify an operator '>=' for
types 'numeric' and 'float8'
You will have to retype this query using an explicit
cast
Please describe a way to repeat the problem. Please
try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
If you know how this problem might be fixed, list the
solution below:
---------------------------------------------------------------------
The work around is to modify the constraint (num >= 0)
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/