Skip site navigation (1) Skip section navigation (2)

CREATE VIEW interp AS select DISTINCT itemkey from songs;

From: Peter Schaefer <schaefer(at)cys(dot)de>
To: "pgsql-bugs(at)postgreSQL(dot)org" <pgsql-bugs(at)postgreSQL(dot)org>
Subject: CREATE VIEW interp AS select DISTINCT itemkey from songs;
Date: 1999-10-13 08:36:57
Message-ID: 380444A8.D89E8555@cys.de (view raw or flat)
Thread:
Lists: pgsql-bugs
Excuse my weak knowledge of SQL, but this doesn't work the way I expect it to work:

codiak=> CREATE VIEW interp AS select DISTINCT ON id id from interp;
CREATE
codiak=> select id from interp where id=1063;
id
-------
   1063
   1063
   1063
(3 rows)

codiak=> \d interp

Table    = interp
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| id                               | int4                             |     4 |
+----------------------------------+----------------------------------+-------+

-- 
Peter Schäfer - mailto:schaefer(at)cys(dot)de, schaefer(at)dfu(dot)de
Motto of the 3D Designer: "I am a meshed potato, I can do the twist".

pgsql-bugs by date

Next:From: Tom LaneDate: 1999-10-13 14:27:22
Subject: Re: [BUGS] CREATE VIEW interp AS select DISTINCT itemkey from songs;
Previous:From: Vitaly PiniyginDate: 1999-10-13 05:33:58
Subject: Re: [BUGS] Pg module "eats" environment

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group