On Wed, Jun 17, 2009 at 6:35 AM, Ashish Jain<ashjain2(at)gmail(dot)com> wrote:
> Can any one help me to write a cast statement which automatically cast
> integer to character??
The SQL standard way would be: CAST( your_int_column AS TEXT )
or the Postgresql way: your_int_column::TEXT
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug