A practical example is the scheme substring (text, integer, integer), if I step substring (row ['name'], start, end) but for some reason they start and end string causes an exception, thesubstring function should not perform the conversion from string to integer?
thanks a lot 2012/1/3 Scott Marlowe <scott.marl...@gmail.com> > But if one is a numeric and one is a text, which do you convert? > There's lots of conversations on this in the lists from about 4 or 5 > years ago. Since converting one way or the other can cause two > different outputs, you can't be sure which is the right way. If you > need a field cast, you now have to cast it yourself for safety. > > On Tue, Jan 3, 2012 at 4:56 PM, Thiago Braga Nobre > <thiagobragano...@gmail.com> wrote: > > what is the typing table field? If the type is numeric you convert > > to number, if the type is varchar to string, it is very obvious, is not > it? > > > > > > 2012/1/3 Scott Marlowe <scott.marl...@gmail.com> > >> > >> No it was broken before, because you didn't know if what you were > >> comparing was what it meant. for instance: > >> > >> where number='01000'; > >> > >> should we cast the number to text, or the text to numeric? > >> > >> On Tue, Jan 3, 2012 at 3:44 PM, Thiago Braga Nobre > >> <thiagobragano...@gmail.com> wrote: > >> > was better before, thanks and happy 2012 > >> > > >> > > >> > > >> > 2012/1/3 Scott Marlowe <scott.marl...@gmail.com> > >> >> > >> >> It was considered a bug when things were automagically cast before, > >> >> it's considered fixed now. What's your query and table defs look > >> >> like? > >> >> > >> >> On Tue, Jan 3, 2012 at 2:57 PM, Thiago Braga Nobre > >> >> <thiagobragano...@gmail.com> wrote: > >> >> > that's right > >> >> > > >> >> > > >> >> > 2012/1/3 Scott Marlowe <scott.marl...@gmail.com> > >> >> >> > >> >> >> On Tue, Jan 3, 2012 at 9:47 AM, Thiago Braga Nobre > >> >> >> <thiagobragano...@gmail.com> wrote: > >> >> >> > Hi > >> >> >> > why in version 8.4.4 I have to do is cast in the previous > version > >> >> >> > of > >> >> >> > PHP > >> >> >> > itself postgres already identified this conversion? > >> >> >> > thank you > >> >> >> > >> >> >> Are you referring to the absence of automatic type conversion on > >> >> >> postgresql that started with version 8.3? I'm not sure what > you're > >> >> >> asking exactly. > >> >> > > >> >> > > >> >> > > >> >> > > >> >> > -- > >> >> > Atenciosamente, > >> >> > > >> >> > Thiago Braga Nobre > >> >> > (21) 8527-9400 > >> >> > > >> >> > http://br.linkedin.com/pub/thiago-braga-nobre/25/577/a08 > >> >> > > >> >> > http://twitter.com/thiago_b_nobre > >> >> > > >> >> > thiagobragano...@gmail.com > >> >> > > >> >> > > >> >> > > >> >> > > >> >> > >> >> > >> >> > >> >> -- > >> >> To understand recursion, one must first understand recursion. > >> > > >> > > >> > > >> > > >> > -- > >> > Atenciosamente, > >> > > >> > Thiago Braga Nobre > >> > (21) 8527-9400 > >> > > >> > http://br.linkedin.com/pub/thiago-braga-nobre/25/577/a08 > >> > > >> > http://twitter.com/thiago_b_nobre > >> > > >> > thiagobragano...@gmail.com > >> > > >> > > >> > > >> > > >> > >> > >> > >> -- > >> To understand recursion, one must first understand recursion. > > > > > > > > > > -- > > Atenciosamente, > > > > Thiago Braga Nobre > > (21) 8527-9400 > > > > http://br.linkedin.com/pub/thiago-braga-nobre/25/577/a08 > > > > http://twitter.com/thiago_b_nobre > > > > thiagobragano...@gmail.com > > > > > > > > > > > > -- > To understand recursion, one must first understand recursion. > -- *Atenciosamente,* * *Thiago Braga Nobre (21) 8527-9400 http://br.linkedin.com/pub/thiago-braga-nobre/25/577/a08 http://twitter.com/thiago_b_nobre thiagobragano...@gmail.com
