Parent Directory | Revision Log
example how to manipulate with complex data
1 | 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 |