Casting in SQL

[Ruslan Zasukhin]

On 31/3/07 1:23 AM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

> Hi,
> 
> Am I correct in understanding casting is not yet supported in Valentina.
> 
> I found it in the SQL grammar but it complains on executing when I do
> 
> select cast(assess_ptr->is_finished) as boolean from......
> 
> Hoping I am wrong....

SQL Parser understand it, but I think it is ignored.

Well, up to know we did not see big sense in this.
Because Valentina did as mySQL -> auto casting of any expressions.

NOW, thanks to your questions, I see that CAST is kind of control of type of
column in the CURSOR.

The same action current can be done with help of Table Methods.
Because here you specify its type.

As I see implementation of CAST is not hard.
Please add it also into Mantis as request.
We will try get it for 3.0


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]