On Jun 13, 2005, at 4:39 AM, stig erikson wrote:
hi.
i need to cast from timestamp to seconds (in the form of integer).
i have a table with a column:
expiretime timestamp
i have tried the following, it gives errors as below:
SELECT expiretime::float4 AS timeleft FROM table WHERE
something='
stig erikson wrote:
hi.
i need to cast from timestamp to seconds (in the form of integer).
i have a table with a column:
expiretime timestamp
i have tried the following, it gives errors as below:
SELECT expiretime::float4 AS timeleft FROM table WHERE something='1234';
ERROR: cannot cast type t
hi.
i need to cast from timestamp to seconds (in the form of integer).
i have a table with a column:
expiretime timestamp
i have tried the following, it gives errors as below:
SELECT expiretime::float4 AS timeleft FROM table WHERE something='1234';
ERROR: cannot cast type timestamp without time
Oh, thanks. Fixed in 8.0.X.
---
Kris Jurka wrote:
>
>
> On Fri, 17 Jun 2005, Bruce Momjian wrote:
>
> > Kris Jurka wrote:
> > >
> > > The documentation describing NetBSD kernel configuration mentions that it
> > > uses
On Fri, 17 Jun 2005, Bruce Momjian wrote:
> Kris Jurka wrote:
> >
> > The documentation describing NetBSD kernel configuration mentions that it
> > uses the "option" keyword like OpenBSD, but in fact it uses the "options"
> > keyword like FreeBSD.
> >
>
> Fix applied. Thanks. This problem
Kris Jurka wrote:
>
> The documentation describing NetBSD kernel configuration mentions that it
> uses the "option" keyword like OpenBSD, but in fact it uses the "options"
> keyword like FreeBSD.
>
> http://developer.postgresql.org/docs/postgres/kernel-resources.html#SYSVIPC
>
> http://cvsweb.
The documentation describing NetBSD kernel configuration mentions that it
uses the "option" keyword like OpenBSD, but in fact it uses the "options"
keyword like FreeBSD.
http://developer.postgresql.org/docs/postgres/kernel-resources.html#SYSVIPC
http://cvsweb.netbsd.org/bsdweb.cgi/src/sys/arch
