FAQ
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@cys.de, schaefer@dfu.de
Motto of the 3D Designer: "I am a meshed potato, I can do the twist".

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 3 | next ›
Discussion Overview
grouppgsql-bugs @
categoriespostgresql
postedOct 13, '99 at 8:38a
activeOct 14, '99 at 7:41a
posts3
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Peter Schaefer: 2 posts Tom Lane: 1 post

People

Translate

site design / logo © 2022 Grokbase