version issue?

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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)