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=-0.9 required=5.0 tests=BAYES_00,FORGED_GMAIL_RCVD,
	FREEMAIL_FROM autolearn=no autolearn_force=no version=3.4.4
X-Google-Thread: a07f3367d7,c8b656b776e44485
X-Google-Attributes: gida07f3367d7,public,usenet
X-Google-NewGroupId: yes
X-Google-Language: ENGLISH,ASCII
Path: 
 g2news2.google.com!postnews.google.com!a39g2000pre.googlegroups.com!not-for-mail
From: Emmanuel Briot <briot.emmanuel@gmail.com>
Newsgroups: comp.lang.ada
Subject: Re: GnatColl
Date: Thu, 2 Jul 2009 12:20:22 -0700 (PDT)
Organization: http://groups.google.com
Message-ID: 
 <2cb7b727-e3c5-4353-ab72-f90410b6c122@a39g2000pre.googlegroups.com>
References: <943582ed-c6aa-4f9f-84c1-b4ce68b2aef4@32g2000yqj.googlegroups.com>
	<h2iq13$e3p$1@online.de>
NNTP-Posting-Host: 70.71.0.212
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1246562423 32586 127.0.0.1 (2 Jul 2009 19:20:23
 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 2 Jul 2009 19:20:23 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: a39g2000pre.googlegroups.com; posting-host=70.71.0.212;
	posting-account=6yLzewoAAABoisbSsCJH1SPMc9UrfXBH
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.0)
	Gecko/20090623 SUSE/3.5.0-2.1 Firefox/3.5,gzip(gfe),gzip(gfe)
Xref: g2news2.google.com comp.lang.ada:6809
Date: 2009-07-02T12:20:22-07:00
List-Id: <comp.lang.ada>

On Jul 2, 10:16=A0am, Dirk Heinrichs <dirk.heinri...@online.de> wrote:
> Cainite 256 wrote:
> > Is there any way to call stored function insted of simple query?
>
> select * from function(arg1, arg2,...);

Not so far, although that should not be too difficult to add. We do
not use stored function ourselves because we have found them harder to
maintain, and we do not need the minor efficiency boost they provide
compared to prepared statements. I guess you could just create a new
instance of SQL_Table where the name is "function (arg1, arg2)". That
would not provide type checking on the Ada side, but at least you
could write the query I think

regards
Emmanuel