From: | Doo Suk Yang <microbe(at)mail(dot)lgchem(dot)co(dot)kr> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] How to express categorized items in relational tables |
Date: | 1999-05-17 07:59:20 |
Message-ID: | Pine.LNX.4.05.9905171656060.369-100000@maldives.rnd.lgchem.co.kr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 14 May 1999, Chris Bitmead wrote:
>
> I think you want something like...
> INSERT INTO child(foo,bar,baz,category) SELECT 'foo1', 'bar1', 'baz1,
> oid FROM category WHERE category.name = 'CategoryFoo';
YES!!! That's exactly what I looked for. :-)
Thank you, thank you so much.
>
> I'm not sure. Is that what you mean?
>
> Doo Suk Yang wrote:
>
> > Thank you for your answer. It is going to be working.
> >
> > BTW, when inserting a parents category I had to go through two steps;
> > selecting category of parents and inserting new title and selected
> > category. Of course I'm using Perl and the above two steps are not great
> > matter. But still I'm curious is it possible to write an SQL statement to
> > do it.
> >
> > ===============================================================================
> > Science is the game we play with God to find out what his rules are.
> > -------------------------------------------------------------------------------
> > Doo Suk Yang
> > Research Scientist Voice: 82-42-866-2222
> > LG Chemical Ltd. Research Park
> > Biotech Research Institute I FAX: 82-42-861-2566
> > -------------------------------------------------------------------------------
> > A fool hath no delight in understanding, but that his heart may discover itself.
> > (Proverbs 18:2)
> > ===============================================================================
>
===============================================================================
Science is the game we play with God to find out what his rules are.
-------------------------------------------------------------------------------
Doo Suk Yang
Research Scientist Voice: 82-42-866-2222
LG Chemical Ltd. Research Park
Biotech Research Institute I FAX: 82-42-861-2566
-------------------------------------------------------------------------------
A fool hath no delight in understanding, but that his heart may discover itself.
(Proverbs 18:2)
===============================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Long | 1999-05-17 12:19:02 | DELETE COLUMN function |
Previous Message | Bruce Momjian | 1999-05-17 06:51:50 | Re: [GENERAL] Linux + PostgreSQL stats? |