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