Re: "Mons" in JDBC driver

On Mon, Aug 2, 2010 at 10:23 AM, Kris Jurka <books(at)ejurka(dot)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