Confusion in Insert Query syntax
| От | Shadkam Islam |
|---|---|
| Тема | Confusion in Insert Query syntax |
| Дата | |
| Msg-id | Pine.LNX.3.96.991006095532.24263D-100000@trishul.wipinfo.soft.net обсуждение исходный текст |
| Ответ на | Some information about JDBC ("Ing. Arturo de la Torre" <adltor@waccom.net.ec>) |
| Ответы |
Re: [GENERAL] Confusion in Insert Query syntax
|
| Список | pgsql-general |
Hi All,
If I type \h insert at psql it shows me,
INSERT INTO class_name [(attr1, ...attrN)]
VALUES (expr1,..exprN) |
SELECT [DISTINCT [ON attrN]]
expr1, ...exprN
[FROM from_clause]
[WHERE qual]
[GROUP BY group_list]
[HAVING having_clause]
[ { UNION [ALL] | INTERSECT | EXCEPT } SELECT ...];
But when I tried the following query it gave the parse error
INSERT INTO EffortTable (EffortID)
VALUES (ValueForEffortID) |
SELECT MAX(EffortID) AS ValueForEffortID
FROM EffortTable
WHERE ProjectID=200;
the error is --> ERROR: parser: parse error at or near "|"
What is the syntax I should use.
Thanx in advance,
Shad.
В списке pgsql-general по дате отправления: