Getting the oid of an anyelement

Поиск
Список
Период
Сортировка
От Scott Bailey
Тема Getting the oid of an anyelement
Дата
Msg-id 4AA9453D.8010801@comcast.net
обсуждение исходный текст
Ответы Re: Getting the oid of an anyelement  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Getting the oid of an anyelement  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
If I've got a function (sql or plpgsql) that takes anyelement as a
param, how do I determine the type name or oid that was actually passed
in? I figure there is probably a function for this but darn if I can
find it.

Specifically, I'm trying to make a function like Oracle's dump that will
take anything as input and return the internal representation of it. So
I want to determine what type was passed in and call the appropriate
send function.

  SELECT dump(current_date);

  dump
  ------------------------------------------
  Type=date OID=1082 Len=4 Data=(0,0,13,212)

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: COPY command character set
Следующее
От: "Peter Headland"
Дата:
Сообщение: Re: COPY command character set