Postgres Pro
Downloads
Home   >   mailing lists

numbered table? - Mailing list pgsql-sql

From UEBAYASHI 'UMA' Masao
Subject numbered table?
Date
Msg-id 19991210153410K.masao@nf.enveng.titech.ac.jp
Whole thread Raw
Responses Re: [SQL] numbered table?  ("UEBAYASHI 'UMA' Masao" <masao@nf.enveng.titech.ac.jp>)
List pgsql-sql
Tree view 
I want to create a table looks like:
 num|code ---+----   1|   2   2|   3   3|   5   4|   9

from
 code ----    2    3    5    9


Actually, original (code) table is not ordered, but ``SELECT DISTINCT
...'' does good work for me. I wonder if SQL has iterator or thing
like that.

Masao

pgsql-sql by date:

Previous
From: marten@feki.toppoint.de
Date:
Subject: Re: [SQL] subquery, except and view
Next
From: "UEBAYASHI 'UMA' Masao"
Date:
Subject: Re: [SQL] numbered table?