[ILUG] postgresql & composite types

From: John P. Looney (john at domain antefacto.com)
Date: Thu 04 Oct 2001 - 11:26:07 IST

 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

This archive was generated by hypermail 2.1.6 : Thu 06 Feb 2003 - 13:12:30 GMT