PostgreSQL 8.4的新功能介绍

--生成表

create table empsalary (depname char(30), empno int, salary int);

--插入数据

insert into empsalary values(’develop’,8,6000);

insert into empsalary values(’develop’,10,5200 );

insert into empsalary values(’develop’,11,5200 );

insert into empsalary values(’develop’,9,4500 );

insert into empsalary values(’develop’,7,4200 );

insert into empsalary values(’personnel’,2,3900);

insert into empsalary values(’personnel’,5,3500);

insert into empsalary values(’sales’,1,5000);

insert into empsalary values(’sales’,4,4800);

insert into empsalary values(’sales’,3,4800);