Patch applied. Thanks.
---
Guillaume Lelarge wrote:
> Hi all,
>
> This patch fixes a small typo in information_schema.sgml.
>
> Regards.
>
>
> --
> Guillaume.
>
> ? information_schema.patch
> Index: doc/src/sgml/inf
Hi all,
This patch fixes a small typo in information_schema.sgml.
Regards.
--
Guillaume.
? information_schema.patch
Index: doc/src/sgml/information_schema.sgml
===
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/information_schema
On Wed, Dec 03, 2003 at 10:49:01AM -0500, Tom Lane wrote:
>
> SELECT 'epoch'::timestamp + '1070430858 seconds'::interval;
>
> because it will produce a timestamp without time zone, thus
> effectively making the epoch be 1970-1-1 midnight local time. But
> of course the correct Unix epoch is 19
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Whoops:
> SELECT 1070430858::abstime::timestamp;
Or you can do
SELECT '1070430858'::int4::abstime::timestamp;
which helps expose the fact that you're really depending on the
int4-to-abstime binary equivalence. This will certainly break in
template1=# SELECT '1070430858'::abstime;
ERROR: invalid input syntax for type abstime: "1070430858"
I agree its more stable :-). That's on HEAD.
Whoops:
SELECT 1070430858::abstime::timestamp;
Chris
---(end of broadcast)---
TIP 4: Don't 'kill -
On Wed, Dec 03, 2003 at 05:59:25PM +1100, Gavin Sherry wrote:
> On Wed, 3 Dec 2003, Christopher Kings-Lynne wrote:
>
> >
> > > + SELECT 'epoch'::timestamp + '1070430858 seconds'::interval;
> > > + Result: 2003-12-03
> > > 05:54:18
> > >
> >
> > You could also go:
> >
> > SELECT '1070430858'::a
On Wed, 3 Dec 2003, Christopher Kings-Lynne wrote:
>
> > + SELECT 'epoch'::timestamp + '1070430858 seconds'::interval;
> > + Result: 2003-12-03
> > 05:54:18
> >
>
> You could also go:
>
> SELECT '1070430858'::abstime;
>
> But your way is probably a bit more stable...dunno...
template1=# SELEC
+ SELECT 'epoch'::timestamp + '1070430858 seconds'::interval;
+ Result: 2003-12-03
05:54:18
You could also go:
SELECT '1070430858'::abstime;
But your way is probably a bit more stable...dunno...
Chris
---(end of broadcast)---
TIP 1: subscri
Kind people,
This patch shows how to change UNIX timestamps into PostgreSQL
timestamps, and clarifies how PERFORM works in PL/PgSQL. :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
Index: func.sgml
