In response to Jeff Janes <jeff.ja...@gmail.com>:

> On Fri, Dec 17, 2010 at 12:16 PM, Bill Moran <wmo...@potentialtech.com> wrote:
> > In response to Tom Lane <t...@sss.pgh.pa.us>:
> >
> >> Josh Berkus <j...@agliodbs.com> writes:
> >> > postgres=# select '1e+01'::Integer
> >> > postgres-# ;
> >> > ERROR:  invalid input syntax for integer: "1e+01"
> >>
> >> I have never heard of any programming system anywhere that accepts such
> >> a syntax for integers (assuming it distinguishes integers from other
> >> numbers at all).  I'm not excited about being the first.  Why does this
> >> error surprise you?  It doesn't seem particularly different from arguing
> >> that 1.000 should be considered an integer, which strikes me as a
> >> seriously bad idea.
> >
> > But
> > SELECT 1.000::Integer;
> > works.  And so does
> > SELECT 1.234::Integer;
> 
> And so does:
> SELECT 1.23e+01::Integer
> 
> 
> > which I find just as dangerous as
> > SELECT '1.234e+01'::Integer;
> 
> Add quotes to either of the other two, and then they don't work either.

Ah ... I wasn't looking carefully enough, that changes the landscape
quite a bit ...

-- 
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to