Skip site navigation (1) Skip section navigation (2)

Re: New To PostgreSQL

From: Andrew Gould <andrewgould(at)yahoo(dot)com>
To: Tom Ince <tince(at)acsinc-nj(dot)com>, "PostgreSQL-General \(E-mail\)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: New To PostgreSQL
Date: 2001-09-27 18:48:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
MySQL's syntax for the UPDATE SQL statement does not
allow for the use of multiple tables.  You cannot
update existing records in one table with data from
another using SQL statements at the interactive
prompt.  There are work-arounds; but I they are both
incovenient and very inefficient.  Fixing this has
been on their todo list for a very long time; but
without any priority.

This was the most significant reason I switched from
MySQL to PostgreSQL.  There are other great reasons
switch; but I am a newbie and didn't know what they
were at the time.   ;-)

Best of luck,

Andrew Gould

--- Tom Ince <tince(at)acsinc-nj(dot)com> 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?  Are there any other quirks I might
> run into as far as
> SQL syntax goes?
> Thank In Advance, 
> Thomas Ince
> Software Systems Engineer
> Atlantic Consulting Services
> Shrewsbury, NJ
> tince(at)acsinc-nj(dot)com
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to

Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.

In response to

pgsql-general by date

Next:From: Bruce MomjianDate: 2001-09-27 18:58:37
Subject: Re: Encoding passwords
Previous:From: Mihai GheorghiuDate: 2001-09-27 18:23:26
Subject: Test is_data_type

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group