[ILUG] postgresql & composite types

[John P. Looney]

 I was working through the postgres tutorial on stored procedures in C,
and came across this example;

typedef struct
{
            double  x, y;
} Point;

Point *
makepoint(Point *pointx, Point *pointy )
{
    Point     *new_point = (Point *) palloc(sizeof(Point));

    new_point->x = pointx->x;
    new_point->y = pointy->y;

    return new_point;
}

 I can load it fine with;

CREATE FUNCTION makepoint(point, point) 
    RETURNS point
    AS '/var/lib/pgsql/functions/kate.so' 
    LANGUAGE 'c';

 But, how do i actually access it ? I was thinking something like;

    SELECT makepoint((2,3),(3,4)) AS point;

 but it's not happening. Any ideas ?


Kate

-- 
_______________________________________
John Looney             Chief Scientist
a n t e f a c t o     t: +353 1 8586004
www.antefacto.com     f: +353 1 8586014