--- Tom Ince <[EMAIL PROTECTED]> wrote: > I am attempting to convert an database currently running on > Informix to > a free database on Linux (RedHat 6.1). I have a question..... > > I learned that MySQL, does not maintain foreign keys, which > affects me > because I need to use things like CHECK in the CREATE TABLE > statements. > So thats why I am not trying PostgreSQL. Does PostgreSQL > support > foreign keys?
Yes. > Are there any other quirks I might run into as > far as > SQL syntax goes? The syntax is very ANSI SQL 92 compliant. I have projects which can interchangebly utilize PostgreSQL, MSSQL, and MySQL with little changes. The only thing that might require a change in code is that the PostgreSQL LIKE is case-sensitive, unlike other databases. You have to change your queries to ILIKE. Brent __________________________________________________ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html