On 09/03/2010 13:51, venkatrao.b@xxxxxxx 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@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
