| From: | Denis Perchine <dyp(at)perchine(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Problem specifying limit in select inside insert. |
| Date: | 2000-10-10 07:02:22 |
| Message-ID: | 00101014022218.02713@dyp.perchine.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Hello,
I have quite strange behavior of the following SQL:
insert into address (cid,email) select distinct '49'::int,member.email from
member imit 1 ;
It should insert just 1 record.
But it insert all recodrs which will be selected by subselect...
What's wrong with this SQL? Or this is a bug? If it is a bug...
How to fix it (patch, workaround...)
Thanks in advance.
--
Sincerely Yours,
Denis Perchine
----------------------------------
E-Mail: dyp(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | He Weiping (Laser Henry) | 2000-10-10 07:06:22 | Is there any caveats on toasted fields? |
| Previous Message | andrew | 2000-10-10 06:42:38 | Making changes visible to other connections |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pete Forman | 2000-10-10 08:21:37 | Re: ld.so error when inserting with a plpgsql trigger function |
| Previous Message | Alfred Perlstein | 2000-10-10 05:42:56 | more crashes with 7.0.2 from oct 4th-PATCHES |