select generate_series(1,(select count(*) from tax)), country from tax; you should use braces around the sub select.
Thanks Deepak On Wed, Oct 20, 2010 at 3:30 PM, David Kerr <d...@mr-paradox.net> wrote: > On Wed, Oct 20, 2010 at 11:28:18PM +0100, Raymond O'Donnell wrote: > - On 20/10/2010 23:22, David Kerr wrote: > - >I know I've seen posts on how to do this, but i can't seem to find them. > - > > - >I've got a data set > - > > - >A, B > - >A, C > - >A, D > - >[...] > - > > - >and so on > - > > - >and i'd like to be able to wite a query that would result in > - > > - >1,A,B > - >2,A,C > - >3,A,D > - >[...] > - > > - >PG version is 8.3. > - > > - >Any ideas? > - > - You probably want generate_series(): > - > - http://www.postgresql.org/docs/8.3/static/functions-srf.html > - > - Ray. > > I thought, so. what would that look like? > > select generate_series(1,select count(*) from table), field1, field2 from > table > doesn't work.. > > > thanks > > Dave > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
