Using Point data type in a function : Point « Data Type « PostgreSQL






Using Point data type in a function


postgres=#
postgres=# CREATE TABLE emp (
postgres(#    name        text,
postgres(#    salary      numeric,
postgres(#    age         integer,
postgres(#    cubicle     point
postgres(# );
CREATE TABLE
postgres=#
postgres=#
postgres=# CREATE FUNCTION new_emp() RETURNS emp AS $$
postgres$#    SELECT text 'None' AS name,
postgres$#        1000.0 AS salary,
postgres$#        25 AS age,
postgres$#        point '(2,2)' AS cubicle;
postgres$# $$ LANGUAGE SQL;
CREATE FUNCTION
postgres=#
postgres=# select new_emp();
         new_emp
--------------------------
 (None,1000.0,25,"(2,2)")
(1 row)

postgres=#
postgres=# drop function new_emp();
DROP FUNCTION
postgres=# drop table emp;
DROP TABLE
postgres=#
postgres=#
           
       








Related examples in the same category

1.Create table with point data type
2.Use Point data type in insert statement
3.Using point data type in insert statement