| From: | bulk(at)colonnello(dot)org (Paolo Colonnello) |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Simple Query HELP!!! |
| Date: | 2001-10-04 18:16:42 |
| Message-ID: | a27df63d.0110041016.7c54eb66@posting.google.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
71062(dot)1056(at)compuserve(dot)com (--CELKO--) wrote in message news:<c0d87ec0(dot)0109231949(dot)4080c0a1(at)posting(dot)google(dot)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....
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-10-04 19:21:42 | Re: Beginner's List |
| Previous Message | Bruce Momjian | 2001-10-04 17:43:22 | Re: temporary views |