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
