rbt wrote:
> Say I have a list that has 3 letters in it:
>
> ['a', 'b', 'c']
>
> I want to print all the possible 4 digit combinations of those 3
> letters:
>
> 4^3 = 64

Should be 3**4 = 81.

>
> aaaa
> abaa
> aaba
> aaab
> acaa
> aaca
> aaac
> ...
>
> What is the most efficient way to do this?

Table t
[c]
a
b
c

Query q
SELECT t_3.c AS c1, t_2.c AS c2, t_1.c AS c3, t.c AS c4
FROM t, t AS t_1, t AS t_2, t AS t_3;

output
[c1]    [c2]    [c3]    [c4]
a       a       a       a
a       a       a       b
a       a       a       c
a       a       b       a
a       a       b       b
a       a       b       c
a       a       c       a
a       a       c       b
a       a       c       c
a       b       a       a
a       b       a       b
a       b       a       c
a       b       b       a
a       b       b       b
a       b       b       c
a       b       c       a
a       b       c       b
a       b       c       c
a       c       a       a
a       c       a       b
a       c       a       c
a       c       b       a
a       c       b       b
a       c       b       c
a       c       c       a
a       c       c       b
a       c       c       c
b       a       a       a
b       a       a       b
b       a       a       c
b       a       b       a
b       a       b       b
b       a       b       c
b       a       c       a
b       a       c       b
b       a       c       c
b       b       a       a
b       b       a       b
b       b       a       c
b       b       b       a
b       b       b       b
b       b       b       c
b       b       c       a
b       b       c       b
b       b       c       c
b       c       a       a
b       c       a       b
b       c       a       c
b       c       b       a
b       c       b       b
b       c       b       c
b       c       c       a
b       c       c       b
b       c       c       c
c       a       a       a
c       a       a       b
c       a       a       c
c       a       b       a
c       a       b       b
c       a       b       c
c       a       c       a
c       a       c       b
c       a       c       c
c       b       a       a
c       b       a       b
c       b       a       c
c       b       b       a
c       b       b       b
c       b       b       c
c       b       c       a
c       b       c       b
c       b       c       c
c       c       a       a
c       c       a       b
c       c       a       c
c       c       b       a
c       c       b       b
c       c       b       c
c       c       c       a
c       c       c       b
c       c       c       c
Record 81 of 81

-- 
http://mail.python.org/mailman/listinfo/python-list

Reply via email to