| From: | Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> | 
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> | 
| Subject: | isolation test output format | 
| Date: | 2021-11-17 01:44:00 | 
| Message-ID: | CAKU4AWrmVNxEntEyzYw6V2HwKUZfsEr0arVMLSkEk2BiW6FAnA@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
Hi:
I'm using the isolation test to write some tests, and then I found the
output is unclear some time.
for example:
a              b              c
1988-12-14 01:03:031988-12-13 22:03:03-011988-12-14
Actually what I want is there are some spaces among the fields. like:
a              b              c
1988-12-14 01:03:03  1988-12-13 22:03:03-01  1988-12-14
The simplest reproduce case is:
setup
{
    CREATE TABLE c_tm(a timestamp, b timestamptz, c date);
}
session "s1"
step "s1inserttm"
{
    INSERT INTO c_tm VALUES('1988-12-14 01:03:03 +2', '1988-12-14
01:03:03 +2', '1988-12-14 01:03:03 +2');
}
step "s1read"
{
    SELECT * FROM c_tm;
}
Is there any simple way to improve this?
-- 
Best Regards
Andy Fan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ken Kato | 2021-11-17 01:44:44 | CREATE tab completion | 
| Previous Message | Paul Jungwirth | 2021-11-16 23:55:26 | Re: SQL:2011 application time |