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

José Soares wrote:

> 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é

Hi Jose,

How should I do it in PostgreSQL?

Thanks

Regards,
Chai