Re: Creating functions with pgAdmin III

Michael Shapiro wrote:

>>Actually it isn't random, but the sort order might not be what you 
>>expect. It looks like (regard as meta code)
>>ORDER BY isdomain, isArray, typname
>>    
>>
>
>This doens't mean anything to me. What I am after is to not have to
>scroll up and down searching for the type. If there is no order by clause
>that will suffice, 
>
There *is* an ordering clause, look at that pseudo code above.

>then you could add code in PgAdmin itself to do
>the ordering. What I think would be a good order is
>    builtin types first
>    user defined types next
>    schema table types next (ordered by schema)
>alphabetic within each group. Does that make sense?
>  
>

Michael,

please don't send private mail. Everything should be discussed publicly; 
we're Open Source. Besides, private mail screws up my inbox processing; 
your answers might well go unnoticed to spam.

As I said we'll be refactoring types handling. You might find find the 
current ordering not helpful, others might do so (at least I like 
domains first, because I use domains to abstract from real database 
types, increasing portability)

Regards,
Andreas