The following bug has been logged online:
Bug reference: 3260
Logged by: Dhugael McLean
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.8
Operating system: FreeBSD
Description:Subtracting intervals
Details:
select '1 day'::interval - '55 minutes'::interval;
"Dhugael McLean" <[EMAIL PROTECTED]> writes:
> select '1 day'::interval - '55 minutes'::interval;
> ?column?
> -
> 1 day -00:55:00
> If the interval periods are both minutes (hours - hours, days - days, etc),
> this works fine. Days - minutes seems to fail. This should output
Dhugael McLean wrote:
> select '1 day'::interval - '55 minutes'::interval;
>
> ?column?
> -
> 1 day -00:55:00
>
> If the interval periods are both minutes (hours - hours, days - days, etc),
> this works fine. Days - minutes seems to fail. This should output 23:05:00.
No, th
I'm using version 7.3 of postgres and when I issue the following command
select author, sort_author from itemsbyauthor where sort_author like 'tan%';
I get the following results:
Author sort_author
Tan, Weihong| tan, weihong
Tang, S. C.
Your query doesn't appear to include an "order by" clause. The
results won't be sorted without an "order by".
On May 3, 2007, at 4:12 PM, Jose Blanco wrote:
I’m using version 7.3 of postgres and when I issue the following
command
select author, sort_author from itemsbyauthor where sort_
Jeff Davis wrote:
> GRANT "postgres" TO "test_role" GRANTED BY "";
>
> We either need to rethink the way we handle grantor information and when it's
> valid.
> Or we need to at least allow dump/restore to work as expected when a dropped
> role
> granted privileges to other users.
I've been st
