DECODE is Oracle-specific.

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

Welcome to IWETHEY!

Post #204,378 by ben_tilly 4/21/05 8:37:47 PM Reply	DECODE is Oracle-specific. 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)
Post #204,396 by tuberculosis 4/22/05 9:29:35 AM Reply	It is, but it is easy to clone I cloned it in postgres on a porting project awhile back. However, it is not only Oracle specific, but in most cases it is EVIL since people abuse it to get out of creating reference tables. "Whenever you find you are on the side of the majority, it is time to pause and reflect" --Mark Twain "The significant problems we face cannot be solved at the same level of thinking we were at when we created them." --Albert Einstein "This is still a dangerous world. It's a world of madmen and uncertainty and potential mental losses." --George W. Bush
Post #204,399 by SpiceWare 4/22/05 9:54:09 AM Reply	Are you sure? I checked MySQL before posting I put decode in the search box at [link\|http://www.mysql.com/\|MySQL.com]. The first result was [link\|http://dev.mysql.com/doc/maxdb/en/cf/63316bc03511d2a97100a0c9449261/content.htm\|DECODE(x,y(i),...,z)] with sample code SELECT hno, price, DECODE (type,\n'single', 1, 'double', 2, 'suite', 3) room_code\n FROM room\n WHERE hno IN (40,50,60) As such, I figured it supported decode and posted my example for Drew. Darrell Spice, Jr. [link\|http://spiceware.org/gallery/ArtisticOverpass\|Artistic Overpass]\n[link\|http://www.spiceware.org/\|SpiceWare] - We don't do Windows, it's too much of a chore
Post #204,416 by ben_tilly 4/22/05 11:16:56 AM Reply	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)
Post #204,423 by JayMehaffey 4/22/05 11:35:10 AM Reply	Seems to be specific to MaxDB MaxDB is the databsse MySQL got when they partnered with SAP. It does have an Oracle like decode. MySQL has a function called decode, but it an encryption function that works opposite encode. Jay
Post #204,435 by SpiceWare 4/22/05 12:14:55 PM Reply	That's rather confusing odd that the MaxDB version of Decode would come up first on a MySQL site search. Oh well. Darrell Spice, Jr. [link\|http://spiceware.org/gallery/ArtisticOverpass\|Artistic Overpass]\n[link\|http://www.spiceware.org/\|SpiceWare] - We don't do Windows, it's too much of a chore

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

That's what Brian Boitano'd do!
62 ms