Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f94IYXn33517 for ; Thu, 4 Oct 2001 14:34:33 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f94IGic67226 for pgsql-sql@postgresql.org; Thu, 4 Oct 2001 14:16:44 -0400 (EDT) (envelope-from news) From: bulk@colonnello.org (Paolo Colonnello) X-Newsgroups: cz.comp.microsoft.sql, mailing.database.sql-general, comp.databases.ms-sqlserver, comp.databases.postgresql.sql Subject: Re: Simple Query HELP!!! Date: 4 Oct 2001 11:16:42 -0700 Organization: http://groups.google.com/ Lines: 13 Message-ID: References: Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200110/84 X-Sequence-Number: 5037 71062.1056@compuserve.com (--CELKO--) wrote in message news:... > Please write DDL and not narrative. here is my guess at what you are > trying to do. What you posted was not a table because you had no key. > TEXT is not the datatype to use for names -- unless they are thousand > of characters long!! > Recording age as an integer is useless -- give us the birthday and we > can always compute their age. Is this what you meant to post? > I didnt give DDL because was to abstract to explain, this is just an example, i did translate the query (really was a subquery in a IN ) and it work... dont care about the data types, I was interest only in the relations....