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
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_
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.
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
"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
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;
