"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 можно
--
Хорсун Влад
