| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Steve Lane <slane(at)fmpro(dot)com> |
| Cc: | PostgreSQL General Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Update question and SQL question |
| Date: | 2002-07-02 13:54:54 |
| Message-ID: | 12647.1025618094@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-general |
Steve Lane <slane(at)fmpro(dot)com> writes:
> NOTICE: Error occurred while executing PL/pgSQL function
> lookup_name_district
> NOTICE: line 1 at select into variables
> ERROR: record student_rec is unassigned yet
Hm. Could we see a complete example (eg, a runnable psql script to set
up the tables and the function and cause the error)? Trying to fill in
the missing pieces is no fun.
> 2. I thought I had understood the SQL standard to say that using AS when
> making column aliases was always optional,
The spec says that, but AS is always required for a column alias in PG.
See the "Compatibility" discussion on the SELECT reference page.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Clift | 2002-07-03 23:25:40 | Another win for PostgreSQL & a good basis for a case study |
| Previous Message | Steve Lane | 2002-07-02 05:28:19 | Update question and SQL question |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-07-02 14:40:10 | Re: pgsql compile error |
| Previous Message | Jan Wieck | 2002-07-02 13:52:18 | Re: (A) native Windows port |