Thisa is probably the wrong forum for this question. But perhaps I could
be pointed to the correct forum.
I am in the final stages of converting an Oracle database to
PostgreSQL. I have just received the Perl script which will drive the
application and call my stored functions.
When the store
uom := (select uom from prodclass where code = prod_class) ;
Now I want to know why this syntax even compiles!?
What does this mean in plpgsql and where can I find a discussionin the
documentation?
Rick
Tom Lane wrote:
"Frank Millman" <[EMAIL PROTECTED]> writes:
uom := (select uo
_catalog.pg_user u ON u.usesysid = p.proowner
WHERE p.prorettype <> 'pg_catalog.cstring'::pg_catalog.regtype
AND p.proargtypes[0] <> 'pg_catalog.cstring'::pg_catalog.regtype
AND NOT p.proisagg
AND pg_catalog.pg_function_is_visible(p.oid)
ORDER BY 2, 3,
database so I could
query them.
Rick
Martijn van Oosterhout wrote:
On Fri, Dec 05, 2003 at 02:22:26PM -0500, Rich Hall wrote:
Can somebody tell me how Stored Functions are kept in the database? I've
gone through the catalog several times. I've found many interesting
things but N
Can somebody tell me how Stored Functions are kept in the database? I've
gone through the catalog several times. I've found many interesting
things but NOT the 300-odd functions I've created.
Rick
--
---(end of broadcast)---
TIP 3: if posting/r
