Re: [Firebird-docs] An obscure note DML210.docbook

[Helen B. <he...@ii...>]

Hi Mimmo,

I'm printing out and collecting up these notes as you post them.  From my POV, I will *not* be changing the v.2.1.2 notes at all - ever - since they are now obsolete. 

I suggest that you (and others) simply mark the passages to fix later, when the 2.1.3 notes are finalised and uploaded to CVS. 

But *do* keep posting the obscure passages/example errors as you happen upon them.

Thanks,
Helen

At 08:46 PM 31/08/2009, you wrote:
>Hi Helen,
>
>sorry to ask your patience again, but in "Expression Arguments for 
>SUBSTRING()" there is a note that leads to some ambiguity when translated.
>The points are two: "The length of the resulting column" and syntax 
>expressed in the sample.
>"length of the ... column" is an ambigous expression: it's hard to 
>specify that "length" is not related to an implied "value of" the 
>resulting column, like it sounds in italian.
>Instead I prefer the clearer "the datatype dimension of the returned 
>value" or something alike.
>
>SELECT SUBSTRING ( VARCHAR_50_FIELD FROM 1 FOR 3) FROM A_TABLE;
>
>returns a columns which datatype is the same of the VARCHAR_50_FIELD, but:
>
>SELECT CHAR_LENGTH ( SUBSTRING ( VARCHAR_50_FIELD FROM 1 FOR 3 ) FROM 
>A_TABLE;
>
>returns an integer column where max value is 3,
>
>I have now something like this:
>"The datatype of the result for function substring() is the same of the 
>first argument. This mean that, as in the following example, if the 
>field or the variable X is a VARCHAR(50) the returned value has datatype 
>VARCHAR(50) and the returned string has a max CHAR_LENGTH() of 1"
>
>The sample need to be reworked also, as:
>x = varchar(50);
>is not a valid PSQL / SQL statement, but actually I left the rest 
>unchanged to let you review as you prefer.
>
>Ciao.
>Mimmo.
>
>
>
>------------------------------------------------------------------------------
>Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
>trial. Simplify your report design, integration and deployment - and focus on 
>what you do best, core application coding. Discover what's new with 
>Crystal Reports now.  http://p.sf.net/sfu/bobj-july
>_______________________________________________
>Firebird-docs mailing list
>Fir...@li...
>https://lists.sourceforge.net/lists/listinfo/firebird-docs