Обсуждение: There is a different cast than ::MyOtherType() ?
Hi list,<br /><br />My Delphi app does not suport this kind of cast:<br /><br />Select id, desc<span style="font-style: italic;font-weight: bold;">::Varchar(50)</span> from myTable<br clear="all" /><br />I don't know if it is a odbc problemor a Delphi problem (or a BDE problem). <br /><br /><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><fontface="Verdana, Arial, Helvetica, sans-serif" size="2"><strong><span style="font-weight: bold;">Even thoughI would like to try another cast.</span><br style="font-weight: normal;" /><br style="font-weight: normal;" /><spanstyle="font-weight: normal;">Does anyone is avaliable to help me ?</span><br /></strong></font></font>-- <br /> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=<br /> Atenciosamente (Sincerely)<br/> Ezequias Rodrigues da Rocha<br /> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br/>A pior das democracias ainda é melhor do quea melhor das ditaduras <br />The worst of democracies is still better than the better of dictatorships<br /><a href="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a>
am Fri, dem 16.02.2007, um 9:30:14 -0300 mailte Ezequias Rodrigues da Rocha folgendes: > Hi list, > > My Delphi app does not suport this kind of cast: > > Select id, desc::Varchar(50) from myTable This is PG-only-style, the spec is: select id, cast(desc as varchar(50)) from mytable; But i'm not sure if 'desc' is a reserved key-word. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
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