From: | Alfred Perlstein <bright(at)wintelcom(dot)net> |
---|---|
To: | Dan Wilson <phpPgAdmin(at)acucore(dot)com> |
Cc: | pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: version issue? |
Date: | 2001-02-26 07:30:46 |
Message-ID: | 20010225233046.Y8663@fw.wintelcom.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
* Dan Wilson <phpPgAdmin(at)acucore(dot)com> [010225 22:47] wrote:
> I have the following query running on two different servers. It works on
> 7.0.3 and gives the following error on 7.1beta4.
>
> ERROR: Attribute 'last_name' not found
>
> Your SQL statement:
> SELECT first_name, last_name, middle_name, u.uid, end_year
> FROM user_info u, auth a
> WHERE u.uid = pri_key AND a.auth_table = 'user_info' AND live = 't'
> AND site_id IN ('214') AND u.end_year > date_part('year', date 'today') - 2
> UNION
> SELECT first_name, last_name, middle_name, u.uid, end_year
> FROM user_info u, current c
> WHERE u.uid = c.uid
> ORDER BY UPPER(last_name)
>
> I'm figuring it is in the ORDER BY, but I'm not sure. Can anyone help me
> out?
(just a guess) try adding the table name, like: 'u.last_name'.
--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
From | Date | Subject | |
---|---|---|---|
Next Message | Renaud Tthonnart | 2001-02-26 08:14:08 | Re: How to create a dynamic list? |
Previous Message | Dan Wilson | 2001-02-26 06:26:31 | version issue? |