Re: Simple Query HELP!!! - Mailing list pgsql-sql

From bulk@colonnello.org (Paolo Colonnello)
Subject Re: Simple Query HELP!!!
Date
Msg-id a27df63d.0110041016.7c54eb66@posting.google.com
Whole thread Raw
In response to Simple Query HELP!!!  (bulk@colonnello.org (Paolo Colonnello))
List pgsql-sql
71062.1056@compuserve.com (--CELKO--) wrote in message news:<c0d87ec0.0109231949.4080c0a1@posting.google.com>...
> 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....


pgsql-sql by date:

Previous
From: "Bob Swerdlow"
Date:
Subject: Re: ORDER BY case insensitive?
Next
From: Vladimir Vukicevic
Date:
Subject: getting OID from PL/PgSQL AFTER trigger