They may have added it but it is not standard

IWETHEY v. 0.3.0 | TODO

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #204,416

by ben_tilly

4/22/05 11:16:56 AM

They may have added it but it is not standard

If they did add it, I don't know which version it would have been.

I know that when I went searching for it, I was pointed at a conversion from Oracle's DECODE to MySQL's CASE. (Which doesn't seem like it quite matches the SQL-92's standard for CASE either. Oh well.)

Cheers,
Ben

I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)

How to do without subqueries - (drewk) - (18) - April 21, 2005, 12:02:47 AM EDT

SELECT DISTINCT t1.* FROM t1, t2 ...? - (FuManChu) - April 21, 2005, 01:26:10 AM EDT

I don't understand your description - (ben_tilly) - (16) - April 21, 2005, 02:21:36 AM EDT

Reply from Drew - (Meerkat) - (15) - April 21, 2005, 09:34:14 AM EDT

Re: Reply from Drew - (SpiceWare) - (6) - April 21, 2005, 09:59:22 AM EDT

DECODE is Oracle-specific. -NT - (ben_tilly) - (5) - April 21, 2005, 08:37:47 PM EDT

It is, but it is easy to clone - (tuberculosis) - April 22, 2005, 09:29:35 AM EDT

Are you sure? I checked MySQL before posting - (SpiceWare) - (3) - April 22, 2005, 09:54:09 AM EDT

They may have added it but it is not standard - (ben_tilly) - April 22, 2005, 11:16:56 AM EDT

Seems to be specific to MaxDB - (JayMehaffey) - (1) - April 22, 2005, 11:35:10 AM EDT

That's rather confusing - (SpiceWare) - April 22, 2005, 12:14:55 PM EDT

One solution - (JayMehaffey) - (1) - April 21, 2005, 10:25:00 AM EDT

FWIW this was the best I saw for our needs - (drewk) - April 21, 2005, 08:49:39 PM EDT

Untested, googling for supported syntax - (ben_tilly) - April 21, 2005, 10:32:29 AM EDT

Re: Reply from Drew - (dws) - (4) - April 21, 2005, 08:17:36 PM EDT

You're ordering by the wrong thing - (ben_tilly) - (3) - April 21, 2005, 08:36:52 PM EDT

Where do you see me ordering by count(*) ? -NT - (dws) - (2) - April 22, 2005, 12:38:23 PM EDT

You weren't, clarification - (ben_tilly) - (1) - April 22, 2005, 02:08:36 PM EDT

Re: You weren't, clarification - (dws) - April 22, 2005, 04:32:31 PM EDT

iwethey.org

And yes, IT WORKED!!!!!
125 ms