cursor and update + view
От | Engard Ferenc |
---|---|
Тема | cursor and update + view |
Дата | |
Msg-id | Pine.LNX.3.96.981123201117.31498B-100000@Pons.sote.hu обсуждение исходный текст |
Ответы |
Re: [SQL] cursor and update + view
|
Список | pgsql-sql |
Hi all, I would like to greet averybody on the list; this is my first mail. Anyway... I need to use the UPDATE ... WHERE CURRENT OF ... clausule, but it doesn't work: oeptest=> update shorttest set b='blahblah' where current of c1; ERROR: CURRENT used in non-rule query What does it mean? IT would be urgent... My other problem is with the views: it seems not work if there is an aggregate command in the SELECT. It's only my experience, or others noticed it also? (The details are on the pgsql-novice (subject: view and aggregate command problem)) Thanks, and sorry, if the questions were answered an hour ago; I have subscribed to the list 5 minutes ago... :-) Circum __ @ / \ _ _ Engard Ferenc l | ( \ / | | (\/) mailto:s-fery@kkt.sote.hu \__/ | | \_ \_/ I I http://pons.sote.hu/~s-fery
В списке pgsql-sql по дате отправления: