> -----Original Message-----
> From: Dmitry Yemanov (JIRA) [mailto:[email protected]]
> 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