Компилляция представлений

Fri, 08 Dec 2006 08:57:46 -0800 


Есть вопрос по 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

Ответить