Re: [HACKERS] Converting an expression of one data type to another

2014-10-30 Thread Craig Ringer
I think you're looking for the pgsql-general mailing list. This list is for PostgreSQL extensions and core database engine software development. On 10/30/2014 07:44 PM, rohtodeveloper wrote: > Dear > > I'm doing a job about converting an expression of one data type to another. > In SQLServer, the

[HACKERS] Converting an expression of one data type to another

2014-10-30 Thread rohtodeveloper
Dear I'm doing a job about converting an expression of one data type to another.In SQLServer, there'are two functions to do this job. 1. CAST ( expression AS data_type [ ( length ) ] )2. CONVERT ( data_type [ ( length ) ] , expression ) However, In PostgreSQL, there's only the CAST ( expression A