Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-docs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group