Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id C2DDD632910 for ; Fri, 14 May 2010 06:28:12 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 89066-09 for ; Fri, 14 May 2010 09:28:04 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com [74.125.82.174]) by mail.postgresql.org (Postfix) with ESMTP id 1743F6323A7 for ; Fri, 14 May 2010 06:28:04 -0300 (ADT) Received: by wyb32 with SMTP id 32so1540476wyb.19 for ; Fri, 14 May 2010 02:28:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:content-type; bh=O9fxgeAmSPW2xmI2NzpdbLoml35csqwElpWbIrLXKlw=; b=Xs+HzzZwSG9lANhECVzeykRqU3pYjCLCBOW/TYMlGHb4UEs61QsegJ7ivxCKjAlaT+ 5z5DVNJElT4OfL4KiL7mXXRAOALwXHpTEwmeCsWbHCeBhnfYS86N5N4NI7tFDmwhgg/z L/ee5aUw+qqtIiz64m3NMH/4qE+fdhtpgPPjI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=maMZMjqCTqOlRqpJLpC9u5Itq35fTvoD65SmLptFFIPekR/PMqogdp587dW6HhkCYL qhXLlCPSYy75yZcaac1FKas/HTtHVIsbeah15W7UF1i7KleQTccBE3U5fwDyYK+KyZnj gGFPm7J2qbKcIYEp0vT82IPInOfAkRha/gDAc= MIME-Version: 1.0 Received: by 10.216.87.143 with SMTP id y15mr671604wee.104.1273829283289; Fri, 14 May 2010 02:28:03 -0700 (PDT) Received: by 10.216.159.20 with HTTP; Fri, 14 May 2010 02:28:03 -0700 (PDT) In-Reply-To: <4BED1459.3080405@bankir.ru> References: <4BED1459.3080405@bankir.ru> Date: Fri, 14 May 2010 14:58:03 +0530 Message-ID: Subject: Re: Postgresql database From: Trinath Somanchi To: pgsql-sql@postgresql.org Content-Type: multipart/alternative; boundary=0016e6d77e32ef5e9604868a7deb X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.499 tagged_above=-5 required=5 tests=BAYES_05=-0.5, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201005/68 X-Sequence-Number: 34116 --0016e6d77e32ef5e9604868a7deb Content-Type: text/plain; charset=UTF-8 yes... But attribute of this table asl has an instance .. that two year of releases are possible also... I'm speaking of a very trivial case. On Fri, May 14, 2010 at 2:44 PM, silly sad wrote: > On 05/14/10 12:42, Trinath Somanchi wrote: > >> Hi All, >> >> I have Tree structured database to maintain. >> >> Its as follows. >> >> Vehicles >> > > u r talking about a single entity vehicles > it is very common to represent a single entity with a single table > > and IF u also have to have an entity "class of vehicles" > u r free to declare the second table named "class" > > and IF u also have to represent a reference of manfacturers, another one > table u have to create then. > > that's trivial case > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- Regards, ---------------------------------------------- Trinath Somanchi, --0016e6d77e32ef5e9604868a7deb Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable yes... But attribute of this table asl has an instance .. that two year of = releases are possible
also... I'm speaking of a very trivial case.<= br>
On Fri, May 14, 2010 at 2:44 PM, silly sa= d <sad@bankir.ru&= gt; wrote:
On 05/14/10 12:42, Trinat= h Somanchi wrote:
Hi All,

I have Tree structured database to maintain.

Its as follows.

Vehicles

u r talking about a single entity vehicles
it is very common to represent a single entity with a single table

and IF u also have to have an entity "class of vehicles"
u r free to declare the second table named "class"

and IF u also have to represent a reference of manfacturers, another one ta= ble u have to create then.

that's trivial case

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
= http://www.postgresql.org/mailpref/pgsql-sql



--
Regards,
----= ------------------------------------------
Trinath Somanchi,
--0016e6d77e32ef5e9604868a7deb--