From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00
	autolearn=unavailable autolearn_force=no version=3.4.4
Path: 
 eternal-september.org!reader01.eternal-september.org!reader02.eternal-september.org!news.eternal-september.org!news.eternal-september.org!feeder.eternal-september.org!aioe.org!.POSTED!not-for-mail
From: "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>
Newsgroups: comp.lang.ada
Subject: Re: Question on bounded / unbounded strings
Date: Thu, 22 Sep 2016 19:18:10 +0200
Organization: Aioe.org NNTP Server
Message-ID: <ns13oq$1rp9$1@gioia.aioe.org>
References: <nnd$12b05e33$1843543e@b46552de0b4781f4>
 <nr8fgq$dc5$1@gioia.aioe.org>
 <11ee98f5-d373-4c72-8562-c310cc76817d@googlegroups.com>
 <ns010s$1s8h$1@gioia.aioe.org> <ns06kn$i6v$1@dont-email.me>
 <ns09p7$bp2$1@gioia.aioe.org> <ns0dfk$86b$1@dont-email.me>
 <ns0hgg$pq6$2@gioia.aioe.org> <ns0p0a$fuq$1@dont-email.me>
NNTP-Posting-Host: 1YuCPr00zqg9zND3Lb27jw.user.gioia.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@aioe.org
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101
 Thunderbird/45.3.0
X-Notice: Filtered by postfilter v. 0.8.2
Xref: news.eternal-september.org comp.lang.ada:31849
Date: 2016-09-22T19:18:10+02:00
List-Id: <comp.lang.ada>

On 2016-09-22 16:14, G.B. wrote:
> On 22.09.16 14:05, Dmitry A. Kazakov wrote:
>> On 22/09/2016 12:58, G.B. wrote:
>>> On 22.09.16 11:53, Dmitry A. Kazakov wrote:
>>>> If you do DB you use DB data types.
>>>
>>> (...)
>>>
>>> So, user defined types may be beneficial in a typical
>>> Ada environment when using a capable DBMS.
>>
>> Sure they are, all DB interfacing types are user-defined Ada types.
>
> Do Ada programmers normally store objects of user defined
> types of their own in DBMS?

Sometimes, existing bindings do not encourage this.

> Objects that the DBMS considers atomic,
> to become one attribute value of some tuple (column value in some row).
> Say, of a private type that exports "=" to the DBMS. These would
> be types other than those binding-layer defined types like SQL_INT
> etc, which, I take it, you meant by "DB data types".

SQL_INT is not observable. The only language type here is SQL_C_INT. If 
you have a higher-level abstraction you can have Age or House_Number. 
Now bounded string, if any, would be equivalent to SQL_INT, a 
non-existent entity.

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de