Re: ����������� �������������

Mon, 11 Dec 2006 07:46:48 -0800 


"Vlad Horsun" <[EMAIL PROTECTED]> 
ñîîáùèë/ñîîáùèëà â íîâîñòÿõ ñëåäóþùåå: news:[EMAIL PROTECTED]
>
> "sasha" ...
>>
>> Åñòü âîïðîñ ïî FB 2.0. À ïî÷åìó ó íàñ òàêîå ïðåäñòâëåíèå:
>>
>> CREATE VIEW "PinFeedDefinitions"(
>>      "Id",
>>      "Type",
>>      "LifeTime",
>>      "TypeName")
>> AS
>> SELECT
>>    "Id",
>>    "Type",
>>    "LifeTime",
>>    (SELECT "Name" FROM "FeedTypes" WHERE "Id"=C."Type")
>> FROM "FeedDefinitions" C WHERE "Type"=4
>>
>> íåëüçÿ ñêîìïèëëèðîâàòü òàê:
>>
>> CREATE VIEW "PinFeedDefinitions"
>> AS
>> SELECT
>>    "Id",
>>    "Type",
>>    "LifeTime",
>>    (SELECT "Name" FROM "FeedTypes" WHERE "Id"=C."Type") AS "TypeName"
>> FROM "FeedDefinitions" C WHERE "Type"=4
>>
>> Âûäà¸ò:
>>
>> Invalid command.
>> must specify column name for view select expression
>
>    Â 2.1 ìîæíî

PS Íåëüçÿ áûëî ðàíüøå â 2.0 ñäåëàòü áëèí òàê äîñòàëî ïèñàòü è ïîòîì èñêàòü 
ãäå îøèáñÿ.

Êñòàòå òóò âûøå ÷åëîâåê çàÿêíóëñÿ ïðî SELECT A, B INTO :A, :B ñäåëàòü SELECT 
:A = A, :B = B
ìîæåò áûëî á óìåñòíî ñäåëàòü òàê SELECT A to(into) :A êàêòî ëîãè÷íåé ÷òî 
âîîáùå â ñòàíäàðòå ïî ýòîìó ïîâîäó íå ïðîòèâîðå÷èò.  íåêîòîðûõ çàïðîñàõ êàê 
ñÿäåøü è ñòàíîâèòñÿ ñâåò íå ìèë.

Ответить