Subquery and stored procedures

Article View: borland.public.interbase.sql

Article #927

Back to borland.public.interbase.sql Previous Next

#927

From: Luca Gallo (Gmg Sistemi)
Date: Fri, 27 Apr 2007 09:59

16 lines
1217 bytes

Hi all,
Does someone know how to do something like this

select tbl1.id,(select a,b from storeproc1(tbl1.id)) from tbl1

Interbase give an sql error token unknow ,

I know i can do

select tbl1.id,(select a from storeproc1(tbl1.id)),(select b from 
storeproc1(tbl1.id)) from tbl1

but this is much slower

TIA
Luca

Technical Details

Message-ID: <4631c96e@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,815209dcccbc6914,start
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Luca Gallo \(Gmg Sistemi\)" <luca.gallo@gmgsistemi.it>
From: "Luca Gallo \(Gmg Sistemi\)" <luca.gallo@gmgsistemi.it>
Newsgroups: borland.public.interbase.sql
Subject: Subquery and stored procedures
Date: Fri, 27 Apr 2007 11:59:01 +0200
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 89.118.69.34
Message-ID: <4631c96e@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1177667950 89.118.69.34 (27 Apr 2007 02:59:10 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail