============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : Mike Nguyen Your email address : [EMAIL PROTECTED] 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/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])