[GENERAL] powerset?

[Ben]

Does anybody have a stored proc they'd like to share (preferably pl/ 
pgsql) that generates the power set of an array? For instance:

select powerset({1,2,3});
....would give 8 rows:

{}
{1}
{2}
{3}
{1,2}
{2,3}
{1,3}
{1,2,3}



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly