File: 122_values.sql

package info (click to toggle)
sqlfmt 0.29.0-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 1,580 kB
  • sloc: python: 10,007; sql: 5,626; makefile: 39
file content (37 lines) | stat: -rw-r--r-- 967 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
select *
from (values 
    (1, 2, 3),
    (4, 5, 6)
);
select *
from (values ('some long string literal', 'another very long literal', 'more string literal values', 1, 2, 3),
    ('some long string literal', 'another very long literal', 'more string literal values', 4, 5, 6),
            ('something shorter', 'short', 'fits', 7, 8, 9)
) as v;
)))))__SQLFMT_OUTPUT__(((((
select *
from (values (1, 2, 3), (4, 5, 6))
;
select *
from
    (
        values
            (
                'some long string literal',
                'another very long literal',
                'more string literal values',
                1,
                2,
                3
            ),
            (
                'some long string literal',
                'another very long literal',
                'more string literal values',
                4,
                5,
                6
            ),
            ('something shorter', 'short', 'fits', 7, 8, 9)
    ) as v
;