Re: create type input and output function examples

Поиск
Список
Период
Сортировка
От Christoph Haller
Тема Re: create type input and output function examples
Дата
Msg-id 200311041018.LAA19497@rodos
обсуждение исходный текст
Ответ на create type input and output function examples  ("Clint Stotesbery" <cstotes@hotmail.com>)
Список pgsql-sql
> 
> I've seen the docs for create type and an example of the syntax to create a 
> type. What I haven't seen is the functions that are passed for the input and 
> output elements.
> 
> CREATE TYPE box (INTERNALLENGTH = 8,
>     INPUT = my_procedure_1, OUTPUT = my_procedure_2);
> 
> Now what would be in my_procedure1 and my_procedure2 procedures? I know they 
> are just example placeholders above but I need to see a real example of what 
> would be in those procedures to better understand what they should do. 
> Thanks.
> 
Pretty late reply, hopefully not too late. 
My understanding is these procedures are C functions. 
For examples do the following:
List the types already in use and their io-functions as 
select typname, typinput, typoutput from pg_type ;
Then search the source code (*.c files) 
for <typinput> resp. <typoutput> 

There is a box type already. 
It's box_in and box_out functions can be found in 
$PGSQLD/src/backend/utils/adt/geo_ops.c 

HTH 
Regards, Christoph 



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

Предыдущее
От: Jeff Kowalczyk
Дата:
Сообщение: Re: Help on update that subselects other records in table, uses joins
Следующее
От: Jodi Kanter
Дата:
Сообщение: query assistance