Re: [ILUG] postgresql & composite types

From: John P. Looney (john at domain antefacto.com)
Date: Thu 04 Oct 2001 - 12:25:39 IST


On Thu, Oct 04, 2001 at 11:26:02AM +0100, John P. Looney mentioned:
> 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 ?

 Bah, worked it out.

    select makepoint('(2,3)'::point,'(3,4)'::point) as point;

 Obvious, huh ?

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:31 GMT