Re: need some help with an opennms query/insert

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: need some help with an opennms query/insert
Date: 2007-11-02 18:39:28
Message-ID: 200711021139.29031@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Friday 02 November 2007, "Patrick Ramsey" <Patrick(dot)Ramsey(at)wellstar(dot)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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2007-11-02 18:49:14 Unflatten array
Previous Message Patrick Ramsey 2007-11-02 18:02:48 need some help with an opennms query/insert