From: | "Richard Huxton" <dev(at)archonet(dot)com> |
---|---|
To: | "Matteo Centenaro" <gente_che_mixa(at)hotmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Insert and limit |
Date: | 2001-06-15 12:04:48 |
Message-ID: | 003b01c0f593$7a540c20$1001a8c0@archonet.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
From: "Matteo Centenaro" <gente_che_mixa(at)hotmail(dot)com>
> Hi all,
> is possible that the limit statement dosen't run correctly in this case:
>
> Insert into temp
> Select * from tab1
> Where cod = xxxx
> Limit yyy;
Works here.
richardh=> select * from foo;
a | b
---+----------------------------------
4 | Jack Smith
5 | Andrea Ottwick
(2 rows)
richardh=> insert into foo2 select * from foo limit 1;
INSERT 20788 1
richardh=> select * from foo2;
a | b
---+----------------------------------
4 | Jack Smith
(1 row)
version 7.1.1
- Richard Huxton
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Bowman | 2001-06-15 12:17:32 | Re: Newbie questions |
Previous Message | Raoul Callaghan | 2001-06-15 11:49:31 | this is a "If update confirmed, commit, else rollback" question. |