5 Mar
1999
5 Mar
'99
2:30 p.m.
I am using PostgreSQL's array system for a "categories" field in a database, it return records in a format like: '{"foo"}' '{"foo","bar"}' '{"foo"}' I am trying to extract the list of unique categories - in this example: ["foo","bar"] This would be a complete nuisance to do in DTML. I have decided to read the SQL method's results into an external method and edit them there - but first I need to know how to call a SQL method without the "in" DTML tag. Or maybe there is a simpler solution to all this, for any PostgreSQL gurus out there?? --- Julian Morrison Programmer (Zereau Ltd)