Tarantool discussions archive
 help / color / mirror / Atom feed
From: "Timur Safin" <tsafin@tarantool.org>
To: 'Mergen Imeev' <imeevma@tarantool.org>,
	pgulutzan@ocelot.ca, korablev@tarantool.org,
	v.shpilevoy@tarantool.org, sergos@tarantool.org,
	tarantool-discussions@dev.tarantool.org
Subject: Re: [Tarantool-discussions] The result type and argument types of the built-in SQL functions.
Date: Wed, 29 Jul 2020 11:54:12 +0300	[thread overview]
Message-ID: <018701d66585$d4c081d0$7e418570$@tarantool.org> (raw)
In-Reply-To: <20200727122429.GA49280@tarantool.org>


I general, I agree that UNSIGNED is unnecessary, but the rest of table
is pretty much ok with me. (Though blob vs string discussion opened elsewhere
is important)

With one small note below...

: From: Mergen Imeev <imeevma@tarantool.org>
: Subject: The result type and argument types of the built-in SQL functions.
: 
: Hi, Peter!
: 
: I would like to ask you a few questions about the result type and argument
: types of the SQL built-in functions.
: 
: I suggest changing the result types of some functions. A table with the
: current
: result type and the suggested result type is below.
: 
: FUNCTION NAME		CURRENT		SUGGESTED
: abs			number		number
: avg			number		double
: char			string		string
: character_length	integer		unsigned
...
: soundex			string		string
: substr			string		string
: sum			number		number
: total			number		double

Why total should be different than sum? (I'd use the same number)


Regards,
Timur

  parent reply	other threads:[~2020-07-29  8:54 UTC|newest]

Thread overview: 8+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2020-07-27 12:24 Mergen Imeev
2020-07-27 19:39 ` Peter Gulutzan
2020-07-28 11:28   ` Mergen Imeev
2020-07-29 16:47     ` Peter Gulutzan
2020-07-29  8:50   ` Timur Safin
2020-07-29 17:25     ` Peter Gulutzan
2020-07-29  8:54 ` Timur Safin [this message]
2020-07-29  9:34   ` Mergen Imeev

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to='018701d66585$d4c081d0$7e418570$@tarantool.org' \
    --to=tsafin@tarantool.org \
    --cc=imeevma@tarantool.org \
    --cc=korablev@tarantool.org \
    --cc=pgulutzan@ocelot.ca \
    --cc=sergos@tarantool.org \
    --cc=tarantool-discussions@dev.tarantool.org \
    --cc=v.shpilevoy@tarantool.org \
    --subject='Re: [Tarantool-discussions] The result type and argument types of the built-in SQL functions.' \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox