Re: Current status: implicit-coercion issues for 7.3 - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Current status: implicit-coercion issues for 7.3
Date
Msg-id 200209010132.g811W9A29059@candle.pha.pa.us
Whole thread Raw
In response to Current status: implicit-coercion issues for 7.3  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> It does seem that in at least a few places, current sources behave better
> than 7.2 did; for instance the example mentioned in TODO works:
> 
>     o SELECT col FROM tab WHERE numeric_col = 10.1 fails, requires quotes
> 
> regression=# explain select * FROM tab WHERE numeric_col = 10.1;
>                      QUERY PLAN
> -----------------------------------------------------
>  Seq Scan on tab  (cost=0.00..22.50 rows=5 width=32)
>    Filter: (numeric_col = 10.1::numeric)
> (2 rows)

TODO updated.
--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pgindent
Next
From: Tom Lane
Date:
Subject: CREATE CAST requires immutable cast function?