| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
| Cc: | Postgre General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Where Statement |
| Date: | 2005-11-09 18:44:36 |
| Message-ID: | 20051109184436.GA42283@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Nov 09, 2005 at 10:06:06AM -0800, Bob Pawley wrote:
> The following transfers the serial number of fluid_id into the two
> tables, specification and pipe.
>
> However, it doesn't follow the WHERE instruction. All fluid_id serial
> numbers in process are transferred to fluid_id column in pipe with no
> discrimination.
Could you post a minimal but complete example with all create,
insert, and select statements necessary to reproduce the problem?
What version of PostgreSQL are you running?
What's the purpose of "create table pro as" when you drop it without
doing anything? Or does the actual code do something before the drop?
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2005-11-09 18:45:46 | Re: using new bitmap scans to index bit columns? |
| Previous Message | Andrus | 2005-11-09 18:43:28 | Foreign key reference causes invalid DELETE trigger calls |