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