Thanks

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
>
>
>
>

In response to

Browse pgsql-sql by date

  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