[prev] 10 [next]

PostgreSQL Functionality (cont)

PostgreSQL's dialect of SQL is mostly standard (but with extensions).
  • attributes containing arrays of atomic values 

    create table R ( id integer, values integer[] );
insert into R values ( 123, '{5,4,3,2,1}' );

  • table-valued functions 

    create function f(integer) returns setof TupleType;

  • multiple langauges available for functions
    • PLpgSQL, Python, Perl, Java, R, Tcl, ...
    • function bodies are strings in whatever language