[Info-ingres] labels on a while statement

[Roy Hann]

Roy Hann wrote:

> Martin Bowes wrote:
>
>> Hi All,
>>
>>>From the SQL manual:
>>
>> A WHILE statement can be labeled. The label enables the ENDLOOP statement to break out of a
>> nested series of WHILE statements to a specified level. The label precedes WHILE and is
>> specified by a unique alphanumeric identifier followed by a colon, as in the following:
>> A: WHILE...
>> The label must be a legal object name...
>>
>> So why is it that the label can only be a single alphanumeric character? Anything other 
>> than a single character causes a syntax error.
>
> The problem (I believe) is that OUTER is a keyword. They can often be
> used for identifiers with impunity, but sometime not. 

CREATE TABLE SELECT ( AS INTEGER );
SELECT AS AS AS FROM SELECT AS SELECT;

I've done worse but you get the idea.  :-)

--Roy