List:General Discussion« Previous MessageNext Message »
From:SGreen Date:March 24 2006 10:54pm
Subject:Re: Is there anyway to return an array?
View as plain text  
"David Godsey" <mysql@stripped> wrote on 03/24/2006 12:55:29 PM:

> This is not a typically thing that anyone would expect Mysql to do,
> however with the application I am writing it would be helpful.  Here 
goes:
> 
> The application stores raw data from a satellite, along with a
> configuration of how to read the data.  So of the data types are Int
> Arrays and Float arrays.  Each can have conversion parameters to apply 
to
> the data.  So I have to loop through this raw data, converting to the
> correct type, and applying some convertion parameter (say multiply by 
.26
> for a float).
> 
> So I will pass a function (a UDF function) a binary string, perform some
> conversion, then I would like to return it as an array.
> 
> I know, I know, sounds like something that should be done in the
> presentation layer, howerver if possible, I would like to provide common
> data presentation to multiple presentation layers (written in different
> languages).
> 
> So is there anyway to return an array in mysql?
> 
> Accomplishing the impossible means only that the boss will add it to 
your
> regular duties.
> 
> David Godsey
> 

Depending on your version of MySQL, you could return the results of a 
query created within a stored procedure. Or you could set up a view or 
.... 

Anyway, since array data types are not one of the data types supported by 
MySQL I think the closest you can get is either to return the data as a 
table or as the results of a query or as the content presented by a view. 
If you think about it, a recordset is very similar to a two-dimensional 
array.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Thread
Is there anyway to return an array?David Godsey24 Mar
  • Re: Is there anyway to return an array?SGreen24 Mar
  • Re: Is there anyway to return an array?Peter Brawley25 Mar
    • Re: Is there anyway to return an array?nigel wood25 Mar
      • Re: Is there anyway to return an array?David Godsey29 Mar
      • Re: Is there anyway to return an array?David Godsey31 Mar
        • Re: Is there anyway to return an array?David Godsey31 Mar