On 09/03/2010 13:51, venkatrao.b@tcs.com wrote:
> Hello,
>
> In postgre, when i am trying to give alias name in update statement like
> below -
>
> ---------------------------------
> update mytable x
> set x.name = 'asdf'
> where x.no = 1
> -------------------------------
Leave leave off the "x." :
update mytable
set name = 'asdf'
where no = 1;
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie