在存储过程中创建用户定义数据类型的实例

时间:2022-07-14 17:01:27

I have a postgres function where it returns a data type, a data type that was user-defined, I am modifying the function by removing a function call, that returned that user-defined object. I now need to create an instance of that object in that stored procedure, and I am not sure how to do so, any suggestions?

我有一个postgres函数,它返回一个数据类型,一个用户定义的数据类型,我通过删除函数调用修改函数,返回该用户定义的对象。我现在需要在该存储过程中创建该对象的实例,我不知道该怎么做,有什么建议吗?

Thanks

1 个解决方案

#1


0  

The simples way to create an "instance of that object":

创建“该对象的实例”的简单方法:

NULL::name_of_composite_type

For more, you'll need to provide (a lot) more details in the question.

更多信息,您需要在问题中提供(很多)更多细节。

#1


0  

The simples way to create an "instance of that object":

创建“该对象的实例”的简单方法:

NULL::name_of_composite_type

For more, you'll need to provide (a lot) more details in the question.

更多信息,您需要在问题中提供(很多)更多细节。