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(at)tpchd(dot)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(at)ecw(dot)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(at)postgresql(dot)org)