2012/3/20 Chris Angelico :
> On Tue, Mar 20, 2012 at 7:14 PM, Stefan Keller wrote:
>> But this only works if the input is a clean list of number characters
>> already!
>> Anything other than this will issue an error:
>>
>> postgres=# SELECT '10'::int;
>>
>> After trying hard to cope with anythin
On Tue, Mar 20, 2012 at 7:14 PM, Stefan Keller wrote:
> But this only works if the input is a clean list of number characters already!
> Anything other than this will issue an error:
>
> postgres=# SELECT '10'::int;
>
> After trying hard to cope with anything possibly as an input string I
> found
Hi,
2011/8/12 David Johnston :
> In my table, some of the columns are in text datatype. Few data will come
> down from UI layer as integers. I want to convert that to string/text before
> saving it into the table. Please help me on this.
>
>
> SQL Standard: "CAST( value AS text )" [or varchar]
>
On Friday, August 12, 2011 6:53:57 am Siva Palanisamy wrote:
> Hi All,
>
> In my table, some of the columns are in text datatype. Few data will come
> down from UI layer as integers. I want to convert that to string/text
> before saving it into the table. Please help me on this.
Should not need t
> In my table, some of the columns are in text datatype. Few data will come
> down from UI layer as integers. I want to convert that to string/text before
> saving it into the table. Please help me on this.
>
SQL Standard: "CAST( value AS text )" [or varchar]
PostgreSQL short-hand: "value::te
Hi All,
In my table, some of the columns are in text datatype. Few data will come down
from UI layer as integers. I want to convert that to string/text before saving
it into the table. Please help me on this.
Thanks and Regards,
Siva.
::DISCLAIMER::
--
