Re: [SQL] There is a different cast than ::MyOtherType() ?

[Alvaro Herrera]

Ezequias Rodrigues da Rocha escribió:
> Hi list,
> 
> My Delphi app does not suport this kind of cast:
> 
> Select id, desc::Varchar(50) from myTable

Try

select id, cast(desc as varchar(50)) from yourTable

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings