Home
last modified time | relevance | path

Searched refs:rtest_empmass (Results 1 – 25 of 86) sorted by relevance

1234

/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/
H A Drules.sql137 CREATE TABLE rtest_empmass ( table
671 INSERT INTO rtest_empmass
674 INSERT INTO rtest_empmass
677 INSERT INTO rtest_empmass
684 rtest_empmass;
700 rtest_empmass
707 salary = rtest_empmass.salary
709 rtest_empmass
711 rtest_emp.ename = rtest_empmass.ename;
726 DELETE FROM rtest_emp USING rtest_empmass
[all …]
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money);
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money);
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/
H A Drules.sql62 create table rtest_empmass (ename char(20), salary money); table
284 insert into rtest_empmass values ('meyer', '4000.00');
285 insert into rtest_empmass values ('maier', '5000.00');
286 insert into rtest_empmass values ('mayr', '6000.00');
287 insert into rtest_emp select * from rtest_empmass;
289 update rtest_empmass set salary = salary + '1000.00';
290 update rtest_emp set salary = rtest_empmass.salary from rtest_empmass where rtest_emp.ename = rtest…
292 delete from rtest_emp using rtest_empmass where rtest_emp.ename = rtest_empmass.ename;

1234