Re: Functions question

Thanks to all who replied.  That explains it my function returns opaque,
is there another command that will show a function that returns opaque?

Thanks,
Linn

>>> "Ian Harding" <ianh@tpchd.org> 08/19/02 05:26PM >>>
\df accepts regular expressions.  Try

\df ins.*

or better yet,

\df ins_news

Also, \df will not show functions returning opaque.

>>> "Linn Kubler" <LKubler@ecw.org> 08/19/02 03:22PM >>>
Hi,

Just wondering, is there a way to see a function from within psql?  I
was looking at the \? command list and found \df but that didn't seem
to
work.  I created a function, ins_news(), and when I typed \df
ins_news()
it came back and said zero rows.  Using pgadmin II on a windows
workstation I can see the function I created and the function works so
I
know it's there but how can I list out the function?  There must be a
way since it is listed in pgadmin.

Thanks in advance,
Linn


---------------------------(end of
broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)