Re: [SQL] Update on 6.5 - Mailing list pgsql-sql

From José Soares
Subject Re: [SQL] Update on 6.5
Date
Msg-id 37173AE2.4FB7C0D5@sferacarta.com
Whole thread Raw
In response to [SQL] OUTER JOINS  (Dan Janowski <danj@3skel.com>)
List pgsql-sql
Chairudin Sentosa ha scritto:

> Hi,
>
> I am using postgresql 6.5 snapshot.
> I can not update.
> Could anyone tell me what's wrong, please?
>
> update ibs_br_all_total_units tr set first_name=
> (select first_name from ibs_subscriber tn
>  where tr.pin = tn.pin
> );
>
> "/tmp/psql.60000.13342" 4 lines, 117 characters
> ERROR:  parser: syntax error at or near "tr"
>

AFAIK PostgreSQL doesn't allow subselects on UPDATE.

José



pgsql-sql by date:

Previous
From: Chris Bitmead
Date:
Subject: UPDATE subselect?
Next
From: José Soares
Date:
Subject: Re: [SQL] UPDATE subselect?