Re: How to use a stored procedure in a select structure?

[Jay Pipes]

To strip a little flesh from the meat ( ;) ), I would add that MySQL does indeed know whether a SQL statement will return one or no rows versus more than one row. This is evidenced by error messages when you try to issue a correlated scalar subquery which MySQL recognizes does not retrieve a row based on a unique index. In that case, it errors, saying that you have attempted a scalar subquery which may return more than one row (paraphrased).

So, in a way, I think it may be possible in the near future for this type of functionality to be added to MySQL, as, clearly MySQL already knows a little bit about the nature of a returned resultset...

Just a thought,

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com