Sets the texture at the specified index in an sfmesh object.
Syntax
sfmesh ST_SetTexture(sfmesh sfmeshObject, int4 index, texture textureObject);Parameters
| Parameter | Description |
|---|---|
sfmeshObject | The sfmesh object. |
index | The index of the texture to set. The index starts from 0. |
textureObject | The texture object. |
Examples
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
);