| From: | Keith Parks <emkxp01(at)mtcc(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | hackers(at)postgresql(dot)org, vadim(at)sable(dot)krasnoyarsk(dot)su |
| Subject: | Re: [HACKERS] Unexpected subselect result. |
| Date: | 1998-02-19 20:33:42 |
| Message-ID: | 199802192033.UAA10500@mtcc.demon.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
VAdim,
Great work.
Keith.
disks=> select * from tracks t1 where t1.artist = (
disks-> select distinct t2.artist from tracks t2 where t2.trackno = (
disks-> select max(t3.trackno) from tracks t3
disks-> )
disks-> );
diskid|trackno|artist |song
------+-------+-------------+-----------------------------------
51| 1|Elvis Presley|Hound Dog
.
.
.
.
.
248| 25|Elvis Presley|The Wonder Of You
248| 26|Elvis Presley|Bridge Over Troubled Water
(73 rows)
disks=>
Vadim B. Mikheev <vadim(at)sable(dot)krasnoyarsk(dot)su>
>
> Sorry, I decided to copy subselect' tuple unconditionally...
>
> Vadim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robson Paniago de Miranda | 1998-02-19 21:07:07 | [Fwd: Re: AW: [HACKERS] Solution to the pg_user passwd problem !?? (c)] |
| Previous Message | Frank Ridderbusch | 1998-02-19 20:32:14 | [HACKERS] Platform status |