How would I do this in postgres :
Lets say I have an x and a y and I want to show all possible combinations :
xx yy xy yx
How can I make postgres do this for me ?
Apparently this does not work in 8.4, but the following should:
Thanks to Bruno for testing this.