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

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.