Re: [GENERAL] Where Statement

2005-11-10 Thread Michael Fuhr
[Please copy the mailing list on replies so others can contribute to and learn from the discussion.] On Wed, Nov 09, 2005 at 11:06:22AM -0800, Bob Pawley wrote: > The postgre is version 8 - the about calls it version 1.2.1 March 28, 2005 What version exactly? What does "SELECT version()" show?

Re: [GENERAL] Where Statement

2005-11-09 Thread Michael Fuhr
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 pi

[GENERAL] Where Statement

2005-11-09 Thread Bob Pawley
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.   I can't see what I have done wrong