| From: | Franco Bruno Borghesi <franco(at)akyasociados(dot)com(dot)ar> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | SRF question |
| Date: | 2003-09-08 14:21:39 |
| Message-ID: | 1063030898.6309.1.camel@taz.oficina |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi everyone.
I need to create a C function that returns a row, and the type of this
row must be the same of a type that I've created using CREATE TYPE.
I've seen the function:
TupleDesc TypeGetTupleDesc(Oid typeoid, List *colaliases)
but I don't understand two things:
1)I just know the name of the type, not its oid... woud it be ok if I
execute a SELECT on pg_type asking for typname to find the oid of the
type I want to return? or is there any function like
RelationNameGetTupleDesc (maybe TypeNameGetTupleDesc) that I can call
passing just the typename as a char *?
2)in case TypeGetTupleDesc is the only option, what is the second
argument?
Thanks in advance.
PS: sorry if you receive this message twice, I sent it on saturday but
it seems it never arrived :)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Warford | 2003-09-08 14:30:27 | PL/PerlU problems executing other scripts |
| Previous Message | Tom Lane | 2003-09-08 14:19:43 | Re: [SQL] plPGSQL bug in function creation |