[
http://tracker.firebirdsql.org/browse/CORE-3435?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmitry Yemanov reopened CORE-3435:
----------------------------------
Reopened because of the discovered support in the SQL standard.
> Lateral derived tables
> ----------------------
>
> Key: CORE-3435
> URL: http://tracker.firebirdsql.org/browse/CORE-3435
> Project: Firebird Core
> Issue Type: New Feature
> Components: Engine
> Reporter: mauro russo
>
> I would like to have the following SQL feature.
> I would like to use a derived table, in a nested join, for which the
> definition
> assume a eaning only according to the result of previous join.
> For example :
> select * from T1
> join T2 on ....
> join lateral (select A.col1 from A where A.col2 = T2.colX order by A.col2
> rows 1)
> ...
> With such a select, I can "attach" to my query result a column [A.col1] to
> each row according to the column values
> of each row generated by the previous joins. Of course, in this case a new
> derived table has to be computed
> for each row generated by the previous joins, but this way to write seems to
> be more easy and fast
> respect using nested queries.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
