| From: | Mark Morgan Lloyd <markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general(at)PostgreSQL(dot)org |
| Subject: | Re: Nulls in timestamps |
| Date: | 2005-07-13 22:51:00 |
| Message-ID: | 42D59AD4.B994302E@telemetry.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane wrote:
>
> According to the SQL spec it's "implementation defined", which means
> different DBs could do it differently but they have to tell you what
> they will do. "Implementation dependent" effectively means "the
> behavior is not specified at all".
One problem is that even if the server is supposed to tell you, the means it
uses to do so can vary widely: paper manual, release notes, variable accessible
by SHOW, value accessible by a special query (like the old-style PostgreSQL
EXPLAIN output) value accessible by a standard query (provided you know the
syntax in advance)...
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karsten Hilbert | 2005-07-13 23:25:49 | versioning schema changes was: chosing a database name |
| Previous Message | Matt Miller | 2005-07-13 22:33:42 | Re: Standalone Parser for PL/pgSQL |