Re: [GENERAL] Urgent help needed- alias name in update statement

2010-03-10 Thread Albe Laurenz
Venkat wrote: > 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 > --- > > > is giving error - mytable is not having col x. > > We

Re: [GENERAL] Urgent help needed- alias name in update statement

2010-03-09 Thread Raymond O'Donnell
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

Re: [GENERAL] Urgent help needed- alias name in update statement

2010-03-09 Thread Adrian Klaver
On Tuesday 09 March 2010 5:51:31 am 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 > --- > > is giv

[GENERAL] Urgent help needed- alias name in update statement

2010-03-09 Thread venkatrao . b
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 --- is giving error - mytable is not having col x. We have migrated code from oracle to pos