使用ST_SetTexture设置sfmesh对象中第N个纹理(Oracle)_云原生数据库 PolarDB(PolarDB)-阿里云帮助中心

设置sfmesh对象中第N个纹理。

语法

sfmesh ST_SetTexture(sfmesh sfmeshObject, int4 index, texture textureObject);

参数

参数	描述
sfmeshObject	sfmesh对象。
index	纹理索引编号，从0开始。
textureObject	纹理对象。

示例

SELECT ST_SetTexture(
	'{"meshgeoms":["MESHGEOM(PATCH(TRIANGLESTRIP(0 0,0 10,10 10,10 0)))"],"materials":[{"type":"db","attributes":{"schema":"public","table":"t_material","column":"the_material","key":"num=1"}} ],"textures":[{"compressionType":"None","format":"JPEG","wrap":"Wrap","type":"DB","depth":3,"width":256,"height":256,"name":"texture_name3","size":72,"data":{"schema":"public","table":"test","column":"the_texture","key":"num=1"}}],"primitives":[{"meshgeom":0,"material":0}],"nodes":[{"primitive":0}]}'::sfmesh, 
  0, 
  '{"compressionType":"None","format":"JPEG","wrap":"Wrap","type":"DB","depth":3,"width":256,"height":256,"name":"texture_name3","size":72,"data":{"schema":"public","table":"test","column":"the_texture","key":"num=1"}}'::texture
);