Using 'Row' function in a function : Row « Select Query

Using 'Row' function in a function : Row « Select Query « PostgreSQL

1.	Aggregate Functions
2.	Analytical Functions
3.	Array
4.	Constraints
5.	Cursor
6.	Data Type
7.	Database
8.	Date Timezone
9.	Index
10.	Inheritance
11.	Insert Delete Update
12.	Math Functions
13.	Postgre SQL
14.	Select Query
15.	Sequence
16.	Store Procedure Function
17.	String Functions
18.	Subquery
19.	Table
20.	Table Joins
21.	Transaction
22.	User Previliege
23.	View

SQL / MySQL

MySQL Tutorial

PostgreSQL » Select Query » Row

Using 'Row' function 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=# insert into emp values ('None', 1000.0, 25, '(2,2)');

INSERT 0 1

postgres=#

postgres=#

postgres=# CREATE FUNCTION new_emp() RETURNS emp AS $$

postgres$#    SELECT ROW('None', 1000.0, 25, '(2,2)')::emp;

postgres$# $$ LANGUAGE SQL;

CREATE FUNCTION

postgres=#

postgres=# SELECT (new_emp()).name;

REATE

 name

------

 None

(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.	Row Constructors
2.	Pass 'row' function to function
3.	Cast row function

java2s.com |

| Contact Us | Privacy Policy

All other trademarks are property of their respective owners.