1
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

BigQueryのドキュメントのNULLIFの和訳がおかしい

Posted at

BigQueryのNULLIF関数の説明

NULL が true の場合は expression = expression_to_match を返し、それ以外の場合は expression を返します。(以下略

チョットナニイッテルノカワカラナイ

こんな時は原文をみてみよう。(URL直だと日本語版にリダイレクトされるので右上のLanguageのプルダウンでEnglishを選ぶとよい)

Returns NULL if expression = expression_to_match is true, otherwise returns expression. (以下略

【和訳】 expression = expresson_to_match がtrueの場合はNULLを返し、それ以外の場合はexpressionを返します。

'NULL' と 'expression = expresson_to_match'の位置が逆じゃねーか!

IFNULLの和訳も同様に'NULL'と'expr'が逆の様である。

一般的なRDBMSのSQL関数知ってれば調べないのかもしれないが、一応・・・。

1
0
1

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
1
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?