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