ЯТ
Потому что иначе можно хранить вообще где и как угодно...
Size: a a a
ЯТ
ЯТ
ЯТ
YS
ЯТ
ЯТ
A
A
ЯТ
ЯТ
SC
ЯТ
A
ЯТ
A
ЯТ
ЯТ
line 1:28 no viable alternative at input '('
K
DO
$$
BEGIN
IF EXISTS
(SELECT 1
FROM ids
WHERE table_name = 'widget'
AND field_name = 'widgetid'
)
THEN
UPDATE ids
SET nextid = nextid + 1
WHERE table_name = 'widget'
AND field_name = 'widgetid'
RETURNING nextid;
END IF;
END
$$ LANGUAGE plpgsql;
ERROR: query has no destination for result data
IZ
DO
$$
BEGIN
IF EXISTS
(SELECT 1
FROM ids
WHERE table_name = 'widget'
AND field_name = 'widgetid'
)
THEN
UPDATE ids
SET nextid = nextid + 1
WHERE table_name = 'widget'
AND field_name = 'widgetid'
RETURNING nextid;
END IF;
END
$$ LANGUAGE plpgsql;
ERROR: query has no destination for result data
YS
DO
$$
BEGIN
IF EXISTS
(SELECT 1
FROM ids
WHERE table_name = 'widget'
AND field_name = 'widgetid'
)
THEN
UPDATE ids
SET nextid = nextid + 1
WHERE table_name = 'widget'
AND field_name = 'widgetid'
RETURNING nextid;
END IF;
END
$$ LANGUAGE plpgsql;
ERROR: query has no destination for result data