Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Odd sql error .. - Mailing list pgsql-sql

From Steve Midgley
Subject Re: [SQL] Odd sql error ..
Date
Msg-id CAJexoSJyK6FTtQok8Bz5Bmi+0fRmSmsvT+1B2aw0wqQ9nWGgDA@mail.gmail.com
Whole thread Raw
In response to [SQL] Odd sql error ..  (PropAAS DBA <dba@propaas.com>)
List pgsql-sql
Tree view
On Sat, Sep 16, 2017 at 8:01 PM, PropAAS DBA <dba@propaas.com> wrote:
I'm running this sql (see below) and I get this error:

ERROR:  column "last_modified" does not exist
LINE 3: ...repricefee"  , "tot_savings"  , "last_updated"  , "last_modi...
                                                             ^
HINT:  There is a column named "last_modified" in table "mytable", but it can
not be referenced from this part of the query.


Thoughts?

If you just run the select portion of that insert statement, does it work?
 

pgsql-sql by date:

Previous
From: PropAAS DBA
Date:
Subject: [SQL] Odd sql error ..
Next
From: athinivas
Date:
Subject: [SQL] SETOF any table records AS return in pgSQL functions