匹配由“ ”分隔的字符串的前2位数字

作者: 别烦我
发布时间: 2025-03-17 08:48:03 (26天前)
转自：

2 条回复

0#
回复此人
只怕再见是故人 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 您可以创建UDF，因为它必须是通用的。 </p> <pre> <code> /* Reading in the data */ SELECT * INTO ordertable FROM (VALUES('order_1','5.3.4'), ('order_2','6.2'), ('order_3','3.5.6'), ('order_4','5.3' )) as input (order_number, version_number); /* Write Function */ CREATE OR REPLACE FUNCTION select_version(string text) RETURNS SETOF ordertable AS $$ BEGIN RETURN QUERY EXECUTE 'SELECT * FROM ordertable WHERE version_number LIKE ''' || $1 || '%'''; END $$ language plpgsql stable; SELECT * FROM select_version('5.3'); /*result*/ order_number | version_number --------------+---------------- order_1 | 5.3.4 order_4 | 5.3 (2 Zeilen) /* or */ SELECT * FROM select_version('5'); order_number | version_number --------------+---------------- order_1 | 5.3.4 order_4 | 5.3 (2 Zeilen) </code> </pre> <P> 希望能满足您的需求。 </p> </DIV>

编辑

登录后才能参与评论