This appears to be a usage question. -hackers is about development of
Postgres, not use. Please ask in the correct forum.
Also, when you do ask on the correct list, please add more detail to
questions like this. In particular, show code that you have tried and
that didn't work like you expected. Mailing list readers aren't
mind-readers.
cheers
andrew
blay bloo wrote:
I was wondering how to access the schema of a type in PL/PGSQL
Basically, we've created some custom objects in the database, which
are somewhat similar to database/composite types (i.e. Create type..)-
essentially a named list of name/type pairs.
In PL/PGSQL you can define variables to be custom database types, but
when we try to do it with our custom objects we get:
ERROR: "myet is not a table"
Essentially we just want some way to create a variable (type
instance, or even row) with the appropriate name/type pairs for OUR
objects in PL/PGSQL.
Where would we start looking to 'hack' the code for this - i.e.
how/where in pgsql can i either a) add my object to be recognised as a
'type' or b) make it seem the equivalent to a custom db type
Thanks
BB
---------------------------(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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
