This topic describes the ST_Textures function. This function returns an array that consists of all textures in a material or sfmesh object.
Syntax
texture[] ST_Textures(sfmesh sfmeshObject);
texture[] ST_Textures(material material);Parameters
| Parameter | Description |
|---|---|
| sfmeshObject | The sfmesh object. |
| material | The material object. |
Description
This function returns an array that consists of all textures in a material or sfmesh object.
Examples
- Example 1:
select ST_Textures('{"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); ------------------------------ {01010001010303000100000001000005000000123456FFFF} - Example 2:
-- Array elements by index select (ST_Textures('{"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))[1]; ---------------- 01010001010303000100000001000005000000123456FFFF