On Jan 9, 2008, at 12:19 PM, leonardz wrote:
I am reading through HeadFirst SQL (an OReilly book) which uses specific MySQLisms in its examples. I use postgres on our databases. Some examples are easy to work around, some are not . Is there a rosetta stone (table of commands in one and equivalents inthe other) available?
There are a few compatibility lists/articles around (have you tried Google?), but they're often out of date since both databases are in constant, active development. I'd suggest getting a different book that gives examples in Postgres or, failing that, read the Postgres manual and learn how to translate them yourself. There is a Postgres list dedicated specifically to SQL/query questions as well (pgsql-sql@).
In particular, MySQl seems to have richer string functions to parse out sub strings and als trim a string for automatic table insertion from long multifield strings.
PostgreSQL has extensive string maniputation functions: http:// www.postgresql.org/docs/8.2/interactive/functions-string.html
Erik Jones DBA | Emma® erik@xxxxxxxxxx 800.595.4401 or 615.292.5888 615.292.0777 (fax) Emma helps organizations everywhere communicate & market in style. Visit us online at http://www.myemma.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
