Re: How to convert integer to string in functions

[David Johnston <polobo@xxxxxxxxx>]

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::text"

In both formats replace value with whatever you want to convert.  When writing a parameterized  query (using ?) you can write "?::text" ( or Cast(? AS type) ) to explicitly cast the unknown parameter.  The "text" in the above can be any type name.

David J.