CAST
| From: | Enrico Comini | Date: | Thu, 28 Sep 2000 08:56:34 +0000 |
| Subject: | CAST | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-3132@lists.php.net to get a copy of this message | ||
Hi, how I have to change the next query ?
da_kg=Numeric
a_kg =Numeric
cusiodb=# SELECT * FROM tavola_pesi WHERE ((da_kg < 3.5) and (a_kg >= 3.5));
ERROR: Unable to identify an operator '<' for types 'numeric' and
'float8'
You will have to retype this query using an explicit cast