All Products
Search
Document Center

PolarDB:ST_SetMaterial

Last Updated:Jun 08, 2023

This topic describes the ST_SetMaterial function. This function configures the Nth material in an sfmesh object.

Syntax

sfmesh ST_SetMaterial(sfmesh sfmeshObject, int4 index, material materialObject);

Parameters

Parameter

Description

sfmeshObject

The sfmesh object.

index

The index number of the material. The value starts from 0.

materialObject

The material object.

Examples

SELECT ST_SetMaterial(
	'{"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"}}],"primitives":[{"meshgeom":0,"material":0}],"nodes":[{"primitive" : 0}]}'::sfmesh, 
  0,
  '{"type":"db","attributes":{"schema":"public","table":"t_material","column":"the_material","key":"num=10"}}'
);