Re: Bug

From: Thiago Braga Nobre <thiagobraganobre(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Bug
Date: 2012-01-03 23:56:24
Message-ID: CAH3KbcUmuyVgRquUWuRVkY5E7+StKeB6kvuV=J333o7pPEF-HQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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(dot)marlowe(at)gmail(dot)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
> <thiagobraganobre(at)gmail(dot)com> wrote:
> > was better before, thanks and happy 2012
> >
> >
> >
> > 2012/1/3 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)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
> >> <thiagobraganobre(at)gmail(dot)com> wrote:
> >> > that's right
> >> >
> >> >
> >> > 2012/1/3 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
> >> >>
> >> >> On Tue, Jan 3, 2012 at 9:47 AM, Thiago Braga Nobre
> >> >> <thiagobraganobre(at)gmail(dot)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
> >> >
> >> > thiagobraganobre(at)gmail(dot)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
> >
> > thiagobraganobre(at)gmail(dot)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

thiagobraganobre(at)gmail(dot)com

In response to

  • Re: Bug at 2012-01-03 22:48:49 from Scott Marlowe

Responses

  • Re: Bug at 2012-01-04 00:32:29 from Scott Marlowe

Browse pgsql-docs by date

  From Date Subject
Next Message Scott Marlowe 2012-01-04 00:32:29 Re: Bug
Previous Message Scott Marlowe 2012-01-03 22:48:49 Re: Bug