Re: [gnome-db] Using gdb to debug libgda
- From: Rodrigo Moya <rodrigo gnome-db org>
- To: Daniel Morgan <danmorg sc rr com>
- Cc: GDA <gnome-db-list gnome org>
- Subject: Re: [gnome-db] Using gdb to debug libgda
- Date: 10 Feb 2002 00:36:42 +0100
On Sat, 2002-02-09 at 22:14, Daniel Morgan wrote:
> 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>
http://www.gnome-db.org/ - http://www.ximian.com/
] [Thread Prev