Re: Arrays

2011-08-28 Thread Michael Dykman
2011/8/27 Halász Sándor > 2011/08/26 13:58 -0700, javad bakhshi > Thanks guys for the help. but my problem seems to stand unsolved. > > Right, no arrays. Nothing is left but table. I used a temporary table, but > note that MySQL also does not let table be returned, or passed

Re: a lesson in query writing and (maybe) a bug report

2011-08-28 Thread Jigal van Hemert
Hi, On 28-8-2011 4:08, shawn wilson wrote: On Sat, Aug 27, 2011 at 17:33, Arthur Fuller wrote: I agree 110%. It is completely pointless to index a column with that amount of NULLs. In practical fact I would go further: what is the point of a NULLable column? A NULL 'value' is special in most

Re: Arrays

2011-08-28 Thread Johan De Meersman
- Original Message - > From: "Arthur Fuller" > Another approach to this is to create a concatenated string from the > PKs of the result set and then parse that within a stored procedure > elsewhere in your Front End (FE). For more information on this, > visit www.artfulsoftware.com and c

Re: Arrays

2011-08-28 Thread Johan De Meersman
- Original Message - > From: "Halász Sándor" > > passed in. The table-name will be *sigh* global. No: when you use /create temporary table/, the table is local to your connection. You can perfectly open a dozen connections and have them all create a temporary table called intermediate