Re: "Mons" in JDBC driver

On Mon, Aug 2, 2010 at 10:23 AM, Kris Jurka <books@ejurka.com> wrote:

> Yes, this mirrors the server's behavior:
>
> kjurka=# select '3 months'::interval;
>  interval
> ----------
>  3 mons
> (1 row)


From:
http://www.postgresql.org/docs/9.0/static/runtime-config-client.html#GUC-INTERVALSTYLE

Here is what I see from the server:

p2082849b=> SET SESSION IntervalStyle TO DEFAULT;
SET
p2082849b=> select Interval '3 months';
 interval
----------
 3 mons
(1 row)

p2082849b=> SET session IntervalStyle TO 'postgres';
SET
p2082849b=> select Interval '3 months';
 interval
----------
 3 mons
(1 row)

p2082849b=> SET session IntervalStyle TO 'postgres_verbose';
SET
p2082849b=> select Interval '3 months';
 interval
----------
 @ 3 mons
(1 row)

p2082849b=> SET session IntervalStyle TO 'sql_standard';
SET
p2082849b=> select Interval '3 months';
 interval
----------
 0-3
(1 row)

p2082849b=> SET session IntervalStyle TO 'iso_8601';
SET
p2082849b=> select Interval '3 months';
 interval
----------
 P3M
(1 row)


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug