This is perfect.
select extract(epoch from '1 day 1 hour 15
minute'::interval)/3600 || 'hours';
?column?
25.25hours
(1 row)
I must have looked at this for hours and not seen the
'interval' part of the epoch...
Thanks,
Ted
--- Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Su
i'm having trouble figuring out how to search in inet arraysits
been a long time since i used postgres array support, so i may just be
bone-headed..
how can i determine if a given ip address is contained in the subnet
declaration inside an array?
{134.53.25.0/24,134.53.0.0/16}
{13
On Mon, Apr 25, 2005 at 02:46:37PM -0400, Rob Casson wrote:
>
> i'm having trouble figuring out how to search in inet arraysits
> been a long time since i used postgres array support, so i may just be
> bone-headed..
>
> how can i determine if a given ip address is contained in the subnet
[Please copy the mailing list on replies so others can contribute
to and learn from discussions.]
On Mon, Apr 25, 2005 at 09:31:35AM -0600, Veronica L Bounmixay wrote:
>
> Thank you so much for responding. I did dig around until I was able to
> find pg_tables but I must be extremely stupid. I'
The goal of my query is: given a book, what did other people who
bought this book also buy? I plan the list the 5 most popular such
books. In reality, this isn't about books, but that makes it easier
to understand I think.
We have a table of customer_id (watch_list_id) and book_id
(element_i
Hi Guys!
I need to make an UPDATE on a column reordering it with a sequence
using order by a description.
Confusing??? Well.. Let me give an example...
Today, my table it's organized like this:
Code / Description
9 Orange
15 Apple
1 Pear
3 Tomato
I wa
