Re: casting interval to time
От | Antti Haapala |
---|---|
Тема | Re: casting interval to time |
Дата | |
Msg-id | Pine.GSO.4.55.0306161843230.12828@paju.oulu.fi обсуждение исходный текст |
Ответ на | Re: casting interval to time (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: casting interval to time
(Tom Lane <tgl@sss.pgh.pa.us>)
Re: casting interval to time (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-sql |
On Mon, 16 Jun 2003, Tom Lane wrote: > Tomasz Myrta <jasiek@klaster.net> writes: > > Dnia 2003-06-16 16:53, U¿ytkownik Tom Lane napisa³: > > > Tomasz Myrta <jasiek@klaster.net> writes: > > > > > > > psql (PostgreSQL) 7.3.2 > > > > SELECT cast(cast('1 day 12 hours' as interval) as time); > > > > time > > > > ---------- > > > > 00:00:00 > > > > (1 row) > > > > > > > > > I get 12:00:00 here, using 7.3.3 ... platform-specific problem maybe? > > > Default Debian package. I got the same result even on a 7.3.3 Debian > > package. > > What do you get from "pg_config --configure"? What's the hardware > platform --- i386, or something else? Can anyone else reproduce this, > on any platform? template1=# select cast('25 hours'::interval as time); time ----------00:00:00 (1 row) template1=# select version(); version ------------------------------------------------------------------------PostgreSQL 7.3.2 on i386-pc-linux-gnu, compiled byGCC gcc (GCC) 3.2.3 (1 row) It's also Debian (3.0). % pg_config --configure '--host=i386-linux' '--build=i386-linux' '--prefix=/usr' '--mandir=/usr/share/man' '--docdir=/usr/share/doc' '--bindir=/usr/lib/postgresql/bin' '--libdir=/usr/lib' '--includedir=/usr/include/postgresql' '--enable-recode' '--enable-nls' '--enable-integer-datetimes' (could be this?) '--enable-debug' '--disable-rpath' '--with-tcl' '--with-perl' '--with-python' '--with-pam' '--with-openssl' '--with-gnu-ld' '--with-krb5' '--with-tclconfig=/usr/lib/tcl8.4' '--with-tkconfig=/usr/lib/tk8.4' '--with-includes=/usr/include/tcl8.4' '--with-maxbackends=64' '--with-pgport=5432' 'DOCBOOKSTYLE=/usr/share/sgml/docbook/stylesheet/dsssl/modular' 'build_alias=i386-linux' 'host_alias=i386-linux' --- Not affected: GentooLinux 1.4 rc2 x86 w/ pg 7.3, gcc 3.2.1, glibc 2.3.1 w/ following configure options: '--prefix=/usr' '--mandir=/usr/share/man' '--host=i586-pc-linux-gnu' '--docdir=/usr/share/doc/postgresql-7.3' '--libdir=/usr/lib' '--enable-syslog' '--enable-depend' '--with-gnu-ld' '--with-pam' '--with-maxbackends=1024' '--with-python' '--with-perl' '--with-java' '--with-openssl' '--enable-locale' '--enable-nls' '--enable-multibyte' '--with-CXX' 'CC=gcc' 'CFLAGS=-march=pentium-mmx -O3 -pipe' 'host_alias=i586-pc-linux-gnu' -- Antti Haapala
В списке pgsql-sql по дате отправления: