On Sat, Dec 6, 2008 at 7:36 AM, Merlin Moncure <mmoncure@xxxxxxxxx> wrote:
>> itidb=> update joblist set (full_name, email_address, recruiter,
>> itidb(> subscribed, verified, created_at, updated_at) =
>> itidb-> ('[name hidden]', '[email address hidden]', false, true
>> itidb(> true, current_timestamp(0), current_timestamp(0));
> It looks to me like you are setting the whole table to the same
> address in the update statement (no where clause)...so of course you'd
> get the error. Maybe you want to do an insert statement?
Does this mean the PostgreSQL supports row-wise updates? When did this happen?
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
