Skip to main content

​
Overview

Updates the name of an existing month in tab_meses.

​
Signature

fun_update_meses(
    wid_mes INTEGER,
    new_nom_mes VARCHAR
) RETURNS VOID

​
Parameters

​
wid_mes
INTEGER
required
Month ID to update
​
new_nom_mes
VARCHAR
required
New month name

​
Returns

VOID (no return value)

​
Example Usage

-- Update month name
SELECT fun_update_meses(4, 'el mes del más lindo');

-- Update to standard month name
SELECT fun_update_meses(1, 'enero');

​
Validation Rules

  • Month ID must exist in the table
  • New month name cannot be NULL

​
Source

source/func/meses/fun_update_meses.sql

Build docs developers (and LLMs) love

Get started for freeTalk to us