Magnus Hagander's PostgreSQL blog

Entries from Thursday, April 17. 2008

Thursday, April 17. 2008

A new MySQL gotcha Posted by Magnus Hagander in MySQL, PostgreSQL at 23:00

Comment (1)
Trackback (1)
8703 hits
Defined tags for this entry: ,
Related entries by tags:

A new MySQL gotcha

At least it's new for me, and it's not on the list. Bugged a colleague of mine today, and we were both very surprised for a while until we figured it out. Ok, it's not very complex, but the deal was that: 
SELECT CAST(1 as CHAR)
works, but 
SELECT CAST (1 as CHAR)

does not (syntax error!)

Now, CAST is already horribly limited in MySQL (who came up with the idea that you shouldn't be able to cast to all available types if it's reasonable to do the conversion?! Like from int to text...), but this is just too much. Since when does whitespace before a parenthesis matter in SQL?! Sheesh...

Yet another reason to prefer PostgreSQL...
« previous page   (Page 1 of 1, totaling 1 entries)   next page »
Frontpage

Calendar

Back April '08 Forward
Mon Tue Wed Thu Fri Sat Sun
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30        

Archives

Upcoming conferences

Planned Conferences

Tentative conferences

  • OpenSource Days

Past conferences

  • PGConf.EU 2012
  • Postgres Open 2012
  • PGCon 2012
  • GoOpen
  • Software Passion Summit
  • OpenSource Days
  • Prague PostgreSQL Dev Day
  • FOSDEM 2012
  • PGDay.IT 2011
  • FSCONS 2011
  • Postgres Open 2011
  • PGConf.EU 2011
  • Char(11) 2011
  • EuroPython 2011
  • PGCon 2011
  • NLUUG Spring
  • PG-East 2011
  • OpenSource Days 2011
  • P2D2 2011
  • FOSDEM 2011
  • PGDay.EU 2010
  • PG-West 2010
  • PG-East 2010
  • PGCon 2010
  • OpenSource Days 2010
  • FOSS-Stockholm #1
  • FOSDEM 2010
  • JPUG 2009
  • FSCONS
  • PGDay.EU 2009
  • PGcon.BR 2009
  • JDCon West 2009
  • Highload++ 2009
  • PGCon 2009
  • Prague PG Day 2009
  • FOSDEM 2009
  • FSCONS 2008
  • PGDay.EU 2008
  • Open Source Days 2008
  • PG-West 2008
  • PGCon 2008
  • PG-East 2008
  • FOSDEM 2008

Tags

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Latest comments

Matt Spencer about PostgreSQL vs 64-bit windows
Wed, 06.06.2012 05:23
I agree totally, the 64-bit ve rsion definitely solves the pr oblem if you need more memory. We need to gradually sh [...]
Jim Smithson about PostgreSQL vs 64-bit windows
Tue, 05.06.2012 07:04
Users who are challenged by th e memory taxing qualities of t he 64 bit should go back to us ing 32 bit. It offers sm [...]
Magnus Hagander about PostgreSQL vs 64-bit windows
Thu, 19.04.2012 08:22
You are missing the point - wh ich is exactly that the filesy stem level cache does not ha ve a lower cache hit rat [...]
Marcov about PostgreSQL vs 64-bit windows
Mon, 26.03.2012 19:57
Any VM base caching is limited to the maximal mappable addre ss space(which is about 4G in windows 64-bit, 3GB in 3 [...]
Magnus Hagander about Finding gaps in partitioned sequences
Mon, 06.02.2012 10:18
Hah, thanks for pointing that out. That's what I get for try ing to clean up the formatting when posting it...
mark about Finding gaps in partitioned sequences
Tue, 31.01.2012 19:01
thanks, sorry I should have no ticed that was the seq MINUS t he lag function. p.s. you example may have a typo [...]
Magnus Hagander about Finding gaps in partitioned sequences
Mon, 30.01.2012 17:25
No, there are no user defined functions in this. seq is the column name, then minus the o perator, then lag the bu [...]
mark about Finding gaps in partitioned sequences
Mon, 30.01.2012 17:23
what is seq-lag ? i assume thi s is a user defined func.
Magnus Hagander about www.postgresql.org - brand new, yet old and familiar
Thu, 22.12.2011 17:41
Yeah, unfortunately we are sti ll waiting on David to migrate the content over there.
Dave about www.postgresql.org - brand new, yet old and familiar
Thu, 22.12.2011 16:55
The weekly news page (http://w ww.postgresql.org/community/we eklynews/) seems to be broken. I see only a couple of [...]
tweetbackcheck