From: | Kaloyan Iliev <news1(at)faith(dot)digsys(dot)bg> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org |
Subject: | Thanks |
Date: | 2006-09-07 15:29:50 |
Message-ID: | 45003AEE.2000604@faith.digsys.bg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Thanks a lot!
It works!
Regards,
Kaloyan Iliev
Tom Lane wrote:
>Kaloyan Iliev <news1(at)faith(dot)digsys(dot)bg> writes:
>
>
>>rsr=# SELECT
>>...
>>rsr-# FROM debts_desc DD LEFT JOIN config
>>C ON (DD.conf_id = C.id),
>>...
>>rsr-# FOR UPDATE OF
>>debts_desc;
>>ERROR: relation "debts_desc" in FOR UPDATE/SHARE clause not found in
>>FROM clause
>>
>>
>
>Use the alias, ie, DD. Remember that an alias hides the real name of
>that table for all purposes in the current query.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Aaron Bono | 2006-09-09 17:26:10 | Re: Is it possible to left join based on previous joins result |
Previous Message | Ragnar | 2006-09-07 14:30:50 | Re: Is it possible to left join based on previous joins |