db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From TomohitoNakayama <tomon...@basil.ocn.ne.jp>
Subject Re: Questionable use of word in "VALUES expression" of Derby Reference Manual
Date Wed, 17 Jan 2007 10:47:55 GMT
Hello.

The sentence in the discussion is next.
 >>>>You use a VALUES statement when you do not have a FROM clause.

If we replace "statement" as "clause", it corresponds to "clause" of 
FROM in the sentence.

I feel this seems to be the answer...

Best regards.


Laura Stewart wrote:

> I think that "statement" should be used only for SQL statements like
> SELECT, CREATE TABLE, GRANT.  VALUES is not a statement in SQL.  I
> believe that "clause" is more accurate.
>
> Laura
>
> On 1/16/07, TomohitoNakayama <tomonaka@basil.ocn.ne.jp> wrote:
>
>> Hello.
>>
>> See ....
>>
>> It is reason why I feel question that title of the page was "VALUE
>> expression" and there was "VALUE statement".
>> Then I feel question for the different word.
>>
>> Reading comment from others, however ,
>> I came to conclude that it is quite right that the words are different
>> according to context which original writer thought .
>>
>> Then I will respect original usage and keep it as "statement" in
>> translated manual.
>>
>> Thank you for your comments :)
>>
>> Best regards.
>>
>> Bernt M. Johnsen wrote:
>>
>> >>>>>>>>>>>>>Julius Stroffek wrote (2007-01-15
17:16:36):
>> >>>>>>>>>>>>>
>> >>>>>>>>>>>>>
>> >>Hi Tomohito,
>> >>
>> >>I would say that the VALUES construct is a statement not an 
>> expression.
>> >>The result and usage is similar like SELECT statement.
>> >>
>> >>
>> >
>> >In the SQL standard the construct
>> >   VALUES <row values expression list>
>> >is called a <table value constructor>
>> >
>> >
>> >
>> >
>> >>Cheers
>> >>
>> >>Julo
>> >>
>> >>TomohitoNakayama wrote:
>> >>
>> >>
>> >>>Hello.
>> >>>
>> >>>I found next one sentence in "VALUES expression" of Derby Reference
>> >>>Manual (http://db.apache.org/derby/docs/dev/ref/rrefsqlj11277.html)
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>>You use a VALUES statement when you do not have a FROM clause.
>> >>>>
>> >>>>
>> >>>>
>> >>>I think statement should be expression here but not completely 
>> sure ....
>> >>>I hope opinion from others ...
>> >>>
>> >>>Best regards.
>> >>>
>> >>>
>> >>>
>> >>>
>> >
>> >
>> >
>>
>> -- 
>> /*
>>
>>        Tomohito Nakayama
>>        tomonaka@basil.ocn.ne.jp
>>        tomohito@rose.zero.ad.jp
>>        tmnk@apache.org
>>
>>        Naka
>>        http://www5.ocn.ne.jp/~tomohito/TopPage.html
>>
>> */
>>
>>
>
>

-- 
/*

        Tomohito Nakayama
        tomonaka@basil.ocn.ne.jp
        tomohito@rose.zero.ad.jp
        tmnk@apache.org

        Naka
        http://www5.ocn.ne.jp/~tomohito/TopPage.html

*/ 


Mime
View raw message