"Karl Nack" <karlnack(at)futurityinc(dot)com> writes:
> This is driving me a little nuts.
> SET datestyle = 'us';
> And yet datestyle continues to come back as 'ISO, MDY'.
That's exactly what it should do. 'US' is a synonym for 'MDY',
and in any case it determines only one of the two components
of DateStyle.
(The fact that there are two components is a historical aberration,
and I'd be the first to agree it's ugly, but that's how it works.)
> What am I missing?
You need to read the manual a bit more closely, perhaps; or at
least explain what your *actual* problem is.
regards, tom lane