Re: [h2] table() syntax

Is this syntax peculiar to h2, and if not, is there a name for it? It's like a table literal, or something. On Monday, October 7, 2013 12:59:45 PM UTC-7, Brian Craft wrote: > > Thanks! > > On Monday, October 7, 2013 12:49:53 PM UTC-7, Thomas Mueller wrote: >> >> Hi, >> >> See http://h2database.c

Re: [h2] table() syntax

Thanks! On Monday, October 7, 2013 12:49:53 PM UTC-7, Thomas Mueller wrote: > > Hi, > > See http://h2database.com/html/functions.html#table > > Regards, > Thomas > > > > On Mon, Oct 7, 2013 at 9:06 PM, Brian Craft > > wrote: > >> From the performance docs: >> >> PreparedStatement prep = conn.prep

Re: [h2] table() syntax

Hi, See http://h2database.com/html/functions.html#table Regards, Thomas On Mon, Oct 7, 2013 at 9:06 PM, Brian Craft wrote: > From the performance docs: > > PreparedStatement prep = conn.prepareStatement( > "SELECT * FROM TABLE(X INT=?) T INNER JOIN TEST ON T.X=TEST.ID"); > prep.setObject

[h2] table() syntax

>From the performance docs: PreparedStatement prep = conn.prepareStatement( "SELECT * FROM TABLE(X INT=?) T INNER JOIN TEST ON T.X=TEST.ID"); prep.setObject(1, new Object[] { "1", "2" }); ResultSet rs = prep.executeQuery(); What is the "TABLE(X INT=?)" bit? I don't see anything like this in