| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | venkatrao(dot)b(at)tcs(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Urgent help needed- alias name in update statement |
| Date: | 2010-03-09 14:27:20 |
| Message-ID: | 4B965AC8.5020004@iol.ie |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
On 09/03/2010 13:51, venkatrao(dot)b(at)tcs(dot)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(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2010-03-09 14:32:40 | Re: has_schema_privilege function |
| Previous Message | Adrian Klaver | 2010-03-09 14:26:35 | Re: Urgent help needed- alias name in update statement |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2010-03-09 14:32:40 | Re: has_schema_privilege function |
| Previous Message | Adrian Klaver | 2010-03-09 14:26:35 | Re: Urgent help needed- alias name in update statement |