Re: (no subject)

[email protected] Thu, 8 Sep 2016 17:48:22 +0000

Newsgroups	gmane.comp.java.hsqldb.user
Organization	io7m.com
Message-ID	<[email protected]>

Hello!

On 2016-09-08T18:27:37 +0100
Fred Toussi <[email protected]> wrote:

> I think this has been fixed in SVN /base/trunk

Ok, thanks.

> 
> Please read the Guide for the supported syntax of CREATE PROCEDURE and
> CREATE FUNCTION.
> 
> With CREATE FUNCTION, you need to use RETURN TABLE(SELECT ...)

I'm not sure if you meant that the syntax I gave is wrong...

  CREATE FUNCTION getX(IN in_x INTEGER)
    RETURNS TABLE (x INTEGER)
      READS SQL DATA RETURN TABLE (SELECT t.x FROM WHERE t.x = in_x
       LIMIT 1);

It seems correct. Is the (fixed) bug masking what would have been
a syntax error?

M

------------------------------------------------------------------------------

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

signature.asc (application/pgp-signature, 821 B)