Received: from nf.enveng.titech.ac.jp (nf.enveng.titech.ac.jp [131.112.148.3]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA52158 for ; Fri, 10 Dec 1999 01:28:33 -0500 (EST) (envelope-from masao@nf.enveng.titech.ac.jp) Received: from localhost (neon.enveng.titech.ac.jp [131.112.148.211]) by nf.enveng.titech.ac.jp (8.8.7/8.8.7) with ESMTP id PAA09784 for ; Fri, 10 Dec 1999 15:23:25 +0900 (JST) (envelope-from masao@nf.enveng.titech.ac.jp) To: pgsql-sql@hub.org Subject: numbered table? X-Mailer: Mew version 1.94.1 on Emacs 20.4 / Mule 4.0 (HANANOEN) Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-Id: <19991210153410K.masao@nf.enveng.titech.ac.jp> Date: Fri, 10 Dec 1999 15:34:10 +0900 From: "UEBAYASHI 'UMA' Masao" X-Dispatcher: imput version 990905(IM130) Lines: 24 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