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 по дате отправления: