pg sql

Sql code posted
created at 08 Jun 12:31

Edit | Back 
1
2
3
4
5
6
7
8
9
10
 
CREATE FUNCTION get_name(integer) RETURNS varchar AS $$
DECLARE
uname varchar;
BEGIN
  SELECT name into uname
  FROM table_test1
  WHERE id = $1;
  RETURN uname;
END;
$$ LANGUAGE plpgsql;
194 Bytes in 2 ms with coderay