Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commita938f32

Browse files
committed
New depend code auto-drops sequence, fix copy2.out.
1 parent1133342 commita938f32

File tree

2 files changed

+0
-148
lines changed

2 files changed

+0
-148
lines changed

‎src/test/regress/expected/copy2.out

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -40,6 +40,5 @@ COPY x TO stdout;
4040
44stufftest_4after trigger fired
4141
55stufftest_5after trigger fired
4242
DROP TABLE x;
43-
DROP SEQUENCE x_a_seq;
4443
DROP FUNCTION fn_x_before();
4544
DROP FUNCTION fn_x_after();

‎src/test/regress/expected/select.out

Lines changed: 0 additions & 147 deletions
Original file line numberDiff line numberDiff line change
@@ -430,150 +430,3 @@ SELECT p.name, p.age FROM person* p ORDER BY age using >, name;
430430
mary | 8
431431
(58 rows)
432432

433-
--
434-
-- Test between syntax
435-
--
436-
SELECT 2 BETWEEN 1 AND 3;
437-
?column?
438-
----------
439-
t
440-
(1 row)
441-
442-
SELECT 2 BETWEEN 3 AND 1;
443-
?column?
444-
----------
445-
f
446-
(1 row)
447-
448-
SELECT 2 BETWEEN ASYMMETRIC 1 AND 3;
449-
?column?
450-
----------
451-
t
452-
(1 row)
453-
454-
SELECT 2 BETWEEN ASYMMETRIC 3 AND 1;
455-
?column?
456-
----------
457-
f
458-
(1 row)
459-
460-
SELECT 2 BETWEEN SYMMETRIC 1 AND 3;
461-
?column?
462-
----------
463-
t
464-
(1 row)
465-
466-
SELECT 2 BETWEEN SYMMETRIC 3 AND 1;
467-
?column?
468-
----------
469-
t
470-
(1 row)
471-
472-
SELECT 2 NOT BETWEEN 1 AND 3;
473-
?column?
474-
----------
475-
f
476-
(1 row)
477-
478-
SELECT 2 NOT BETWEEN 3 AND 1;
479-
?column?
480-
----------
481-
t
482-
(1 row)
483-
484-
SELECT 2 NOT BETWEEN ASYMMETRIC 1 AND 3;
485-
?column?
486-
----------
487-
f
488-
(1 row)
489-
490-
SELECT 2 NOT BETWEEN ASYMMETRIC 3 AND 1;
491-
?column?
492-
----------
493-
t
494-
(1 row)
495-
496-
SELECT 2 NOT BETWEEN SYMMETRIC 1 AND 3;
497-
?column?
498-
----------
499-
f
500-
(1 row)
501-
502-
SELECT 2 NOT BETWEEN SYMMETRIC 3 AND 1;
503-
?column?
504-
----------
505-
f
506-
(1 row)
507-
508-
SELECT -4 BETWEEN -1 AND -3;
509-
?column?
510-
----------
511-
f
512-
(1 row)
513-
514-
SELECT -4 BETWEEN -3 AND -1;
515-
?column?
516-
----------
517-
f
518-
(1 row)
519-
520-
SELECT -4 BETWEEN ASYMMETRIC -1 AND -3;
521-
?column?
522-
----------
523-
f
524-
(1 row)
525-
526-
SELECT -4 BETWEEN ASYMMETRIC -3 AND -1;
527-
?column?
528-
----------
529-
f
530-
(1 row)
531-
532-
SELECT -4 BETWEEN SYMMETRIC -1 AND -3;
533-
?column?
534-
----------
535-
f
536-
(1 row)
537-
538-
SELECT -4 BETWEEN SYMMETRIC -3 AND -1;
539-
?column?
540-
----------
541-
f
542-
(1 row)
543-
544-
SELECT -4 NOT BETWEEN -1 AND -3;
545-
?column?
546-
----------
547-
t
548-
(1 row)
549-
550-
SELECT -4 NOT BETWEEN -3 AND -1;
551-
?column?
552-
----------
553-
t
554-
(1 row)
555-
556-
SELECT -4 NOT BETWEEN ASYMMETRIC -1 AND -3;
557-
?column?
558-
----------
559-
t
560-
(1 row)
561-
562-
SELECT -4 NOT BETWEEN ASYMMETRIC -3 AND -1;
563-
?column?
564-
----------
565-
t
566-
(1 row)
567-
568-
SELECT -4 NOT BETWEEN SYMMETRIC -1 AND -3;
569-
?column?
570-
----------
571-
t
572-
(1 row)
573-
574-
SELECT -4 NOT BETWEEN SYMMETRIC -3 AND -1;
575-
?column?
576-
----------
577-
t
578-
(1 row)
579-

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp