Re: [pgadmin-support] Creating functions with pgAdmin III

2003-12-08 Thread Andreas Pflug
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

Re: [pgadmin-support] Creating functions with pgAdmin III

2003-12-08 Thread Andreas Pflug
Ian Freislich wrote: Beigin new to this list, is there a place where I could suggest functionality (I have one nice to have request on low priority for the developers which would make pgAdmin a TOAD equivalent for PostgreSQL for us)? Yes, just post things like that on pgadmin-hackers. Regards,

Re: [pgadmin-support] Creating functions with pgAdmin III

2003-12-07 Thread Ian Freislich
Andreas Pflug wrote: > Ian Freislich wrote: > > >I can't find the pseudo-type RECORD in the drop-down list of return > >types so it is impossible to create functions like "CREATE OR REPLACE > >FUNCTION foo (TEXT) RETURNS SET OF RECORD AS..." using the gui. > > > > > Not all 'p' types are allowed

Re: [pgadmin-support] Creating functions with pgAdmin III

2003-12-07 Thread Andreas Pflug
Michael Shapiro wrote: The list in the pulldown is in a random order, especially srt to the list of tables in mutilple schemas. It woudld be nice if the list was ordered with builtin types listed first, then each table within each schema listed next. Within each of the builtin, and schemas the lis

Re: [pgadmin-support] Creating functions with pgAdmin III

2003-12-05 Thread Andreas Pflug
Ian Freislich wrote: I can't find the pseudo-type RECORD in the drop-down list of return types so it is impossible to create functions like "CREATE OR REPLACE FUNCTION foo (TEXT) RETURNS SET OF RECORD AS..." using the gui. Not all 'p' types are allowed as return types for functions, but appare

[pgadmin-support] Creating functions with pgAdmin III

2003-12-05 Thread Ian Freislich
Hi I don't know if anyone has encountered this problem before. I couldn't find any reference to this on the list archives or FAQ. I can't find the pseudo-type RECORD in the drop-down list of return types so it is impossible to create functions like "CREATE OR REPLACE FUNCTION foo (TEXT) RETURNS