Terry Lee Tucker <[EMAIL PROTECTED]> writes:
> I'm trying to figure out how to convert a floating point value into an
> interval of time.
Use something like
regression=# select (478 / 45.0) * '1 hour'::interval;
?column?
--
10:37:20
(1 row)
... or whatever other scale factor you have
Thanks for the reply. My answer was a little different than yours because I
used 488 instead of 478. Well, that three ways so far ;o)
On Tuesday 11 January 2005 05:06 pm, Guy Fraser saith:
> Convert to seconds first (3600 sec/hr) :
>
> select (
> '3600'::int4
> * '478'::int4
> / '45.0'::float8
Thank you for the reply in spite of the subject.
On Tuesday 11 January 2005 05:15 pm, Michael Fuhr saith:
> On Tue, Jan 11, 2005 at 04:42:21PM -0500, Terry Lee Tucker wrote:
> > Subject: [SQL] Simple Question
>
> Please use a more descriptive subject -- think about how somebody
On Tue, 11 Jan 2005, Terry Lee Tucker wrote:
> Hello:
>
> I'm trying to figure out how to convert a floating point value into an
> interval of time. I'm calculating the time required to drive from point A to
> point B. For the sake of this question, we'll just say it is miles/speed. So:
>
> drv_t
Convert to seconds first (3600 sec/hr) :
select (
'3600'::int4
* '478'::int4
/ '45.0'::float8
)::int4::reltime::interval ;
interval
--
10:37:20
(1 row)
I don't know if "::int4::reltime::interval" is the best
way to end up with an interval, but its the only way I
could figure out
On Tue, Jan 11, 2005 at 04:42:21PM -0500, Terry Lee Tucker wrote:
> Subject: [SQL] Simple Question
Please use a more descriptive subject -- think about how somebody
looking at a list of 200 messages, all with subjects like "Simple
Question" or "PostgreSQL Question," would
I figured it out. This works:
travel_window INTERVAL;
drv_time FLOAT;
drv_time = miles / 45.0;-- drive time
travel_window = quote_literal(drv_time || '' hours'');
The variable, travel_window becomes: @ 10 hours 50 mins 40 secs, which is
what I wanted.
If anybody knows any othe
Hello:
I'm trying to figure out how to convert a floating point value into an
interval of time. I'm calculating the time required to drive from point A to
point B. For the sake of this question, we'll just say it is miles/speed. So:
drv_time = 478 / 45.0;
The value of this is: 10.6
Esteban,
> is there a command intersect? I mean exist a union command, but
> I
> don't know if exist a intersect command.
> thanks
Yes. There is also EXCEPT as well as INTERSECT and UNION. See the
online docs, in SQL COMMANDS --> SELECT
-Josh
__AGLIO DATABASE SOLUTIONS___
hi.
I have a simple question!
is there a command intersect? I mean exist a union command, but I
don't know if exist a intersect command.
thanks
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
Hello All,
This may be the wrong mailing list for this question but I hope someone can
answer it for me as it is holding up my development progress.
I have now been able to compile the tutorial/complex.c functions and test them
out with no problems.
I made a copy of the Makefile, Makefile.globa
11 matches
Mail list logo
