On 11/02/2014 06:13 AM, Emanuel Calvo wrote:
El 02/11/14 a las 07:15, rohtodeveloper escibió:
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.
From which data_type to which one? In psql, the option \dC, will give
you the list of supported casts.
Did you try the cast operand?
postgres=# select '1235'::int , 823::text, (now()::date)::text;
int4 | text | now
------+------+------------
1235 | 823 | 2014-11-02
(1 row)
In addition if you are trying to do this in/to a table column there is:
http://www.postgresql.org/docs/9.3/interactive/sql-altertable.html
ALTER [ COLUMN ] column_name [ SET DATA ] TYPE data_type [ COLLATE
collation ] [ USING expression ]
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
