[HACKERS] \da doesn't show result type

2007-04-10 Thread Peter Eisentraut
Is there a reason that \da doesn't show the functions result type, like \df 
does?  I would find that information useful.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


Re: [HACKERS] \da doesn't show result type

2007-04-10 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes:
 Is there a reason that \da doesn't show the functions result type, like \df 
 does?  I would find that information useful.

+1, I've been annoyed by that too.

regards, tom lane

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [HACKERS] \da doesn't show result type

2007-04-10 Thread Magnus Hagander
On Tue, Apr 10, 2007 at 10:32:38AM -0400, Tom Lane wrote:
 Peter Eisentraut [EMAIL PROTECTED] writes:
  Is there a reason that \da doesn't show the functions result type, like \df 
  does?  I would find that information useful.
 
 +1, I've been annoyed by that too.

Eh, but it does? As of
http://archives.postgresql.org/pgsql-committers/2007-03/msg00138.php.

Or am I missing what you're asking for here? :-)

//Magnus


---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


Re: [HACKERS] \da doesn't show result type

2007-04-10 Thread Peter Eisentraut
Am Dienstag, 10. April 2007 17:12 schrieb Magnus Hagander:
   Is there a reason that \da doesn't show the functions result type, like
   \df does?  I would find that information useful.

 Eh, but it does? As of
 http://archives.postgresql.org/pgsql-committers/2007-03/msg00138.php.

Ah, OK, one feature in 8.3 that I can use. :)

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster