Re: Bug - Mailing list pgsql-docs
From | Thiago Braga Nobre |
---|---|
Subject | Re: Bug |
Date | |
Msg-id | CAH3KbcVHwC1QSkWarDEviWDPqSnQ5N4B5rUXRiia5LXTBAwNDA@mail.gmail.com Whole thread Raw |
In response to | Re: Bug (Scott Marlowe <scott.marlowe@gmail.com>) |
Responses |
Re: Bug
(Robert Haas <robertmhaas@gmail.com>)
|
List | pgsql-docs |
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?
--
Thiago Braga Nobre
(21) 8527-9400
thanks a lot
2012/1/3 Scott Marlowe <scott.marlowe@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<thiagobraganobre@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.marlowe@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
>> <thiagobraganobre@gmail.com> wrote:
>> > was better before, thanks and happy 2012
>> >
>> >
>> >
>> > 2012/1/3 Scott Marlowe <scott.marlowe@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
>> >> <thiagobraganobre@gmail.com> wrote:
>> >> > that's right
>> >> >
>> >> >
>> >> > 2012/1/3 Scott Marlowe <scott.marlowe@gmail.com>
>> >> >>
>> >> >> On Tue, Jan 3, 2012 at 9:47 AM, Thiago Braga Nobre
>> >> >> <thiagobraganobre@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
>> >> >
>> >> > thiagobraganobre@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
>> >
>> > thiagobraganobre@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
>
> thiagobraganobre@gmail.com
>
>
>
>
--
To understand recursion, one must first understand recursion.
Atenciosamente,
Thiago Braga Nobre
(21) 8527-9400
pgsql-docs by date: