Re: Graphical Query Builder - usage stats?
От | Guillaume Lelarge |
---|---|
Тема | Re: Graphical Query Builder - usage stats? |
Дата | |
Msg-id | 4BA0BDA5.6000206@lelarge.info обсуждение исходный текст |
Ответ на | Re: Graphical Query Builder - usage stats? (Julius Tuskenis <julius@nsoft.lt>) |
Список | pgadmin-support |
Le 15/03/2010 09:54, Julius Tuskenis a écrit : > [...] > I don't usually use the builder, but sometimes it is convenient for long > table/column names having queries. I'd like to propose some improvements > to it: > 1. Why not join the selected tables if they are related over foreign > key? Usually well designed database uses FK to keep relations in order, > so when you drop a new table to a query builder window there could be > checked if the table can be linked to the already used tables in builder. > 2. I think, that tables should be linked using join statement, not the > where clause. That way we could have left, right and inner joins easily. > > I think these 2 impovements would make the builder more usable :). > Sure, that would be interesting. I added a ticket to remember about your feature request: http://code.pgadmin.org/trac/ticket/150 . -- Guillaume.http://www.postgresqlfr.orghttp://dalibo.com
В списке pgadmin-support по дате отправления: