Re: [gnome-db] Using gdb to debug libgda

On Sat, 2002-02-09 at 22:14, Daniel Morgan wrote:
> Serge,
> Thank you.
> Now, I was able to see my whole string.  :)
> SELECT a.aggname AS "Name", a.oid AS "Object Id",
>  t.typname as "IN Type",obj_description(a.oid) AS "Comments" 
> FROM pg_aggregate a, pg_type t, pg_user b 
> WHERE a.aggbasetype = t.oid AND b.usesysid=a.aggowner
> SELECT a.aggname AS "Name", a.oid AS "Object Id", '---' AS "IN Type", 
>  obj_description(a.oid) AS "Comments"
> FROM pg_aggregate a, pg_user b
> WHERE a.aggbasetype = 0
> AND b.usesysid=a.aggowner
> ORDER BY aggname, typname
> I changed my ORDER BY to 1, 3 and the query worked!
> I noticed PostgreSQL allows ORDER BY using aliases too.  I thought that
> was neat -- ORDER BY "Name", "IN Type"
hmm, do you mean you've fixed that query the postgres provider is doing?
If so, could you send us a patch, please?

Rodrigo Moya <rodrigo gnome-db org> - <rodrigo ximian com> -

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]