| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | pogden(at)claresco(dot)com |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Inconsistent or incomplete behavior obverse in where clause |
| Date: | 2002-11-12 18:34:47 |
| Message-ID: | 10295.1037126087@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
Paul Ogden <pogden(at)claresco(dot)com> writes:
> select count(wuid) from WU where wuActive = 0.0 --throws the
> following exception:
> "Unable to identify an operator '=' for types 'numeric' and 'double
> precision' You will have to retype this query using an explicit cast"
This is fixed as of 7.3. (We still have related issues for smallint
and bigint columns, unfortunately.)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-11-12 18:44:49 | Re: [HACKERS] Inconsistent or incomplete behavior obverse in where |
| Previous Message | Zeugswetter Andreas SB SD | 2002-11-12 18:32:48 | Re: Problem with 7.3 on Irix with dates before 1970 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-11-12 18:44:49 | Re: [HACKERS] Inconsistent or incomplete behavior obverse in where |
| Previous Message | Josh Berkus | 2002-11-12 18:23:02 | Re: Inconsistent or incomplete behavior obverse in where |