Parent Directory | Revision Log
example how to manipulate with complex data
1 | dpavlin | 272 | begin; |
2 | |||
3 | select * from archive_burned order by archive_id,part,copy; | ||
4 | |||
5 | select * into a from archive_burned where archive_id in (select archive_id from archive_burned group by archive_id having sum(copy) < 2) ; | ||
6 | |||
7 | update a set copy = 2 ; | ||
8 | |||
9 | insert into archive_burned select * from a; | ||
10 | |||
11 | select * from archive_burned order by archive_id,part,copy; | ||
12 | |||
13 | drop table a ; | ||
14 |
ViewVC Help | |
Powered by ViewVC 1.1.26 |