Pass 'row' function to function : Row « Select Query « PostgreSQL






  1. PostgreSQL
  2. Select Query
  3. Row

Pass 'row' function to function


postgres=#
postgres=#
postgres=# CREATE TABLE mytable(f1 int, f2 float, f3 text);
CREATE TABLE
postgres=#
postgres=# CREATE FUNCTION getf1(mytable) RETURNS int AS 'SELECT $1.f1' LANGUAGE SQL;
CREATE FUNCTION
postgres=#
postgres=# -- No cast needed since only one getf1() exists
postgres=# SELECT getf1(ROW(1,2.5,'this is a test'));
 getf1
-------
     1
(1 row)

postgres=#
postgres=#
postgres=# drop function getf1(mytable);
DROP FUNCTION
postgres=# drop table mytable;
DROP TABLE
postgres=#
postgres=#
postgres=#








Related examples in the same category

1.Row Constructors
2.Cast row function
3.Using 'Row' function in a function