Re: need some help with an opennms query/insert - Mailing list pgsql-novice

From Patrick Ramsey
Subject Re: need some help with an opennms query/insert
Date
Msg-id 472C85CF.17DE.0070.0@wellstar.org
Whole thread Raw
In response to Re: need some help with an opennms query/insert  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-novice
Thanks Alan!  Obviously I was NOT on the right track... :)

>>> Alan Hodgson <ahodgson@simkin.ca> 11/2/2007 2:39 PM >>>
On Friday 02 November 2007, "Patrick Ramsey" <Patrick.Ramsey@wellstar.org>
wrote:
> I think I have this much:
>
> SELECT "categoryid" FROM "public"."category_node" WHERE "categoryid" =
> '27'

INSERT INTO public.category_node (categoryid,nodeid) SELECT 30,nodeid 
  FROM public.category_node WHERE categoryid = 27;


--
Q: Why did God create economists?
A: In order to make weather forecasters look good.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

____________________________________________________________ 
This email and any files transmitted with it may contain confidential and /or proprietary information in the possession of WellStar Health System, Inc. ("WellStar") and is intended only for the individual or entity to whom addressed. This email may contain information that is held to be privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any unauthorized access, dissemination, distribution or copying of any information from this email is strictly prohibited, and may subject you to criminal and/or civil liability. If you have received this email in error, please notify the sender by reply email and then delete this email and its attachments from your computer. - Thank you.

pgsql-novice by date:

Previous
From: norman
Date:
Subject: Re: Graphical tools for PostGres
Next
From: John DeSoi
Date:
Subject: Re: Uncertain about recoding prepared statements from MySQL to PostgreSQL