Hi,
I would like to know if functions will ever be able to issue SELECT
statements, like procedures can. I want a function which can select
multiple rows from another table, process those rows into a single
scalar, and return that as its result. I want a function to do this
so that I can use it in the column list of SELECT queries,
rather than calling it like a procedure.
A trivial example, showing the error saying I cant use SELECT in a
function is below.
- Will this be included in future, and is just missing now as functions
are
so new?
I am using mysql 5.0.1-alpha (win32)
Thanks,
Mike.
mysql> delimiter |
mysql> create function test()
-> returns int
-> select 1234;
-> end
-> |
ERROR 1301 (0A000): Statements like SELECT, INSERT, UPDATE (and others)
are not allowed in a FUNCTION
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
