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: Call postgresql function...
Date: Wed, 27 Jul 2016 11:09:07 +0200
Organization: Aioe.org NNTP Server
Message-ID: <nn9tnr$1d4n$1@gioia.aioe.org>
References: <e3f64963-6b77-4bee-a155-f0bcbe91e709@googlegroups.com>
 <nn9qp6$18an$1@gioia.aioe.org>
 <651f87d2-0c20-4c0c-88e8-a82f241f3466@googlegroups.com>
NNTP-Posting-Host: xelDFTENDI+dlkJFd2Ot2w.user.gioia.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Complaints-To: abuse@aioe.org
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101
 Thunderbird/45.2.0
X-Notice: Filtered by postfilter v. 0.8.2
Xref: news.eternal-september.org comp.lang.ada:31181
Date: 2016-07-27T11:09:07+02:00
List-Id: <comp.lang.ada>

On 2016-07-27 10:42, eduardsapotski@gmail.com wrote:
> среда, 27 июля 2016 г., 11:18:48 UTC+3 пользователь Dmitry A. Kazakov написал:
>> On 2016-07-27 09:55, eduardsapotski@gmail.com wrote:
>>
>>> I started to learn Ada language.
>>> How to call postgresql function with input and output parameters and return the result?
>>
>> Meaning?
>>
>> 1. A stored procedure
>> 2. A PostgreSQL API subprogram (from libpq)
>> 3. An SQL statement (preparing, binding, executing, fetching)
>
> Здравствуйте, Дмитрий. Как понимаю, русский язык Вам знаком? :)

Yes, but this is an English language group. Please, keep posting in English.

> Есть база PostgreSQL 9.5, в ней много функций. Функции имеют входные
> ивыходные параметры, возвращают значения. Сейчас задача дергать эти
> функции из приложения на Ада.

Is it a stored procedure then?

> Хотелось бы найти нормальный пример с
> подобным функционалом. Самое лучшее что пока нашел:
> https://rosettacode.org/wiki/Parametrized_SQL_statement#Ada
> Но здесь sqlite и немного не то. Может что посоветуете?

If don't know if GNATCOLL supports PostgreSQL. If it does, the example 
should work fine after you replace/modify the UPDATE statement with a 
stored procedure call.

There are other PostgeSQL Ada binding available, e.g. in GNADE and APQ 
come in mind, though both are not actively maintained now.

Then, I would of course use ODBC rather than native PostgreSQL bindings.

There is nothing special in how you do this in Ada or, say, in C.

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