Re: Support TZ format code in to_timestamp() - Mailing list pgsql-hackers

From Aleksander Alekseev
Subject Re: Support TZ format code in to_timestamp()
Date
Msg-id CAJ7c6TOVPxAhqc6PyAtmT1=pnPjQTpx4oSXWtU=oOMW6cJnYYg@mail.gmail.com
Whole thread Raw
In response to Re: Support TZ format code in to_timestamp()  (Daniel Gustafsson <daniel@yesql.se>)
Responses Re: Support TZ format code in to_timestamp()
List pgsql-hackers
Hi,

> > Anyway, v2-0001 below is the previous patch rebased up to current
> > (only line numbers change), and then v2-0002 responds to your
> > and Daniel's review comments.
>
> LGTM.

```
+SELECT to_timestamp('2011-12-18 11:38 JUNK', 'YYYY-MM-DD HH12:MI
TZ');  -- error
+ERROR:  invalid value "JUNK" for "TZ"
+DETAIL:  Time zone abbreviation is not recognized.
+SELECT to_timestamp('2011-12-18 11:38 ...', 'YYYY-MM-DD HH12:MI TZ');  -- error
+ERROR:  invalid value ".." for "TZ"
```

Shouldn't the second error display the full value "..." (three dots)
similarly to the previous one? Also I think we need at least one
negative test for OF.

Other than that v2 looks OK.

-- 
Best regards,
Aleksander Alekseev



pgsql-hackers by date:

Previous
From: "Andrey M. Borodin"
Date:
Subject: Re: UUID v7
Next
From: Aleksander Alekseev
Date:
Subject: Re: UUID v7