| From: | "Dan Wilson" <phpPgAdmin(at)acucore(dot)com> |
|---|---|
| To: | "pgsql general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | version issue? |
| Date: | 2001-02-26 06:26:31 |
| Message-ID: | 00d701c09fbd$0ff120b0$078353d8@danwilson |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
-Dan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alfred Perlstein | 2001-02-26 07:30:46 | Re: version issue? |
| Previous Message | Katsuyuki Tanaka | 2001-02-26 05:06:56 | IPC Shared Memory (fwd) |