> -----Original Message-----
> From: Dmitry Yemanov (JIRA) [mailto:trac...@firebirdsql.org] 
> Sent: Jueves, 24 de Abril de 2014 10:55
> 
> Either explicit (DECLARE AS CURSOR) or implicit (FOR SELECT) 
> PSQL cursors could make their current record available via 
> the cursor name similar to OLD/NEW trigger contexts, thus 
> making the INTO clause optional. In FOR SELECT loops, it 
> requires AS CURSOR clause to be specified.

Is this feature being asked for?
;-)

What I see is that fields with the same name, even though they come from
different tables, would need to be given an alias:

select T1.A, T2.A ... as cursor C do
        v = C.A; -- Error

=> 
select T1.A as t1a, T2.A as t2a ... as cursor C do
        v = t1a; -- Ok

Claudio.



------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to