| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
| H A D | portals.sql | 496 UPDATE local
521 UPDATE local
531 UPDATE local
558 UPDATE local
585 UPDATE local
595 UPDATE local
618 UPDATE local
662 UPDATE local
669 UPDATE local
676 UPDATE local
[all …]
|
| /dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | portals.sql | 331 DELETE FROM uctest WHERE CURRENT OF c1; local
347 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
356 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
358 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
362 DELETE FROM uctest WHERE CURRENT OF c1; local
375 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
377 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
379 DELETE FROM uctest WHERE CURRENT OF c1; local
398 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
471 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | portals.sql | 331 DELETE FROM uctest WHERE CURRENT OF c1; local
347 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
356 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
358 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
362 DELETE FROM uctest WHERE CURRENT OF c1; local
375 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
377 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
379 DELETE FROM uctest WHERE CURRENT OF c1; local
398 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
471 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
| H A D | portals.sql | 331 DELETE FROM uctest WHERE CURRENT OF c1; local
347 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
356 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
358 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
362 DELETE FROM uctest WHERE CURRENT OF c1; local
375 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
377 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
379 DELETE FROM uctest WHERE CURRENT OF c1; local
398 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
471 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | portals.sql | 331 DELETE FROM uctest WHERE CURRENT OF c1; local
347 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
356 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
358 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
362 DELETE FROM uctest WHERE CURRENT OF c1; local
375 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
377 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
379 DELETE FROM uctest WHERE CURRENT OF c1; local
398 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
471 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | portals.sql | 331 DELETE FROM uctest WHERE CURRENT OF c1; local
347 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
356 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
358 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
362 DELETE FROM uctest WHERE CURRENT OF c1; local
375 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
377 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
379 DELETE FROM uctest WHERE CURRENT OF c1; local
398 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
471 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/ |
| H A D | portals.sql | 331 DELETE FROM uctest WHERE CURRENT OF c1; local
347 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
356 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
358 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
362 DELETE FROM uctest WHERE CURRENT OF c1; local
375 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
377 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
379 DELETE FROM uctest WHERE CURRENT OF c1; local
398 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
471 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/ |
| H A D | portals.sql | 331 DELETE FROM uctest WHERE CURRENT OF c1; local
347 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
356 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
358 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
362 DELETE FROM uctest WHERE CURRENT OF c1; local
375 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
377 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
379 DELETE FROM uctest WHERE CURRENT OF c1; local
398 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
471 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/ |
| H A D | portals.sql | 331 DELETE FROM uctest WHERE CURRENT OF c1; local
347 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
356 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
358 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
362 DELETE FROM uctest WHERE CURRENT OF c1; local
375 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
377 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
379 DELETE FROM uctest WHERE CURRENT OF c1; local
398 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
471 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/ |
| H A D | portals.sql | 331 DELETE FROM uctest WHERE CURRENT OF c1; local
347 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
356 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
358 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
362 DELETE FROM uctest WHERE CURRENT OF c1; local
375 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
377 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
379 DELETE FROM uctest WHERE CURRENT OF c1; local
398 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
471 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/ |
| H A D | portals.sql | 331 DELETE FROM uctest WHERE CURRENT OF c1; local
347 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
356 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
358 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
362 DELETE FROM uctest WHERE CURRENT OF c1; local
375 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
377 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
379 DELETE FROM uctest WHERE CURRENT OF c1; local
398 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
471 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/ |
| H A D | portals.sql | 331 DELETE FROM uctest WHERE CURRENT OF c1; local
347 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
356 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
358 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
362 DELETE FROM uctest WHERE CURRENT OF c1; local
375 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
377 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
379 DELETE FROM uctest WHERE CURRENT OF c1; local
398 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
471 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/ |
| H A D | portals.sql | 331 DELETE FROM uctest WHERE CURRENT OF c1; local
347 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
356 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
358 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
362 DELETE FROM uctest WHERE CURRENT OF c1; local
375 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
377 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
379 DELETE FROM uctest WHERE CURRENT OF c1; local
398 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
471 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql96-docs/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | portals.sql | 331 DELETE FROM uctest WHERE CURRENT OF c1; local
347 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
356 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
358 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
362 DELETE FROM uctest WHERE CURRENT OF c1; local
375 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
377 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
379 DELETE FROM uctest WHERE CURRENT OF c1; local
398 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
471 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql96-client/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | portals.sql | 331 DELETE FROM uctest WHERE CURRENT OF c1; local
347 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
356 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
358 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
362 DELETE FROM uctest WHERE CURRENT OF c1; local
375 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
377 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
379 DELETE FROM uctest WHERE CURRENT OF c1; local
398 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
471 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql96-contrib/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | portals.sql | 331 DELETE FROM uctest WHERE CURRENT OF c1; local
347 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
356 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
358 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
362 DELETE FROM uctest WHERE CURRENT OF c1; local
375 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
377 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
379 DELETE FROM uctest WHERE CURRENT OF c1; local
398 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
471 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
| H A D | portals.sql | 351 DELETE FROM uctest WHERE CURRENT OF c1; local
367 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
376 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
378 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
382 DELETE FROM uctest WHERE CURRENT OF c1; local
395 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
397 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
399 DELETE FROM uctest WHERE CURRENT OF c1; local
433 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
506 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/ |
| H A D | portals.sql | 351 DELETE FROM uctest WHERE CURRENT OF c1; local
367 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
376 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
378 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
382 DELETE FROM uctest WHERE CURRENT OF c1; local
395 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
397 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
399 DELETE FROM uctest WHERE CURRENT OF c1; local
433 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
506 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
| H A D | portals.sql | 351 DELETE FROM uctest WHERE CURRENT OF c1; local
367 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
376 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
378 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
382 DELETE FROM uctest WHERE CURRENT OF c1; local
395 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
397 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
399 DELETE FROM uctest WHERE CURRENT OF c1; local
433 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
506 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/ |
| H A D | portals.sql | 351 DELETE FROM uctest WHERE CURRENT OF c1; local
367 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
376 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
378 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
382 DELETE FROM uctest WHERE CURRENT OF c1; local
395 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
397 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
399 DELETE FROM uctest WHERE CURRENT OF c1; local
433 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
506 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/ |
| H A D | portals.sql | 351 DELETE FROM uctest WHERE CURRENT OF c1; local
367 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
376 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
378 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
382 DELETE FROM uctest WHERE CURRENT OF c1; local
395 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
397 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
399 DELETE FROM uctest WHERE CURRENT OF c1; local
433 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
506 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql14-contrib/postgresql-14.1/src/test/regress/sql/ |
| H A D | portals.sql | 351 DELETE FROM uctest WHERE CURRENT OF c1; local
367 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
376 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
378 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
382 DELETE FROM uctest WHERE CURRENT OF c1; local
395 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
397 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
399 DELETE FROM uctest WHERE CURRENT OF c1; local
433 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
506 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql14-client/postgresql-14.1/src/test/regress/sql/ |
| H A D | portals.sql | 351 DELETE FROM uctest WHERE CURRENT OF c1; local
367 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
376 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
378 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
382 DELETE FROM uctest WHERE CURRENT OF c1; local
395 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
397 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
399 DELETE FROM uctest WHERE CURRENT OF c1; local
433 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
506 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/ |
| H A D | portals.sql | 351 DELETE FROM uctest WHERE CURRENT OF c1; local
367 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
376 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
378 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
382 DELETE FROM uctest WHERE CURRENT OF c1; local
395 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
397 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
399 DELETE FROM uctest WHERE CURRENT OF c1; local
418 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
491 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|
| /dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/ |
| H A D | portals.sql | 351 DELETE FROM uctest WHERE CURRENT OF c1; local
367 UPDATE uctest SET f1 = 8 WHERE CURRENT OF c1; local
376 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
378 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
382 DELETE FROM uctest WHERE CURRENT OF c1; local
395 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
397 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
399 DELETE FROM uctest WHERE CURRENT OF c1; local
418 UPDATE uctest SET f1 = f1 + 10 WHERE CURRENT OF c1; local
491 DELETE FROM onek WHERE CURRENT OF c1; local
[all …]
|